Do you need this or any other assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 10% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
Conceptual Modeling Assignment
Upload entity relationship (ER) diagrams for the
Conceptual Modeling Assignment
Upload entity relationship (ER) diagrams for the following two scenarios. Show appropriate cardinalities and all the applicable constraints. Clearly state any assumptions that you may have made. Your assumptions cannot contradict the given description.
An airline company has many planes that travel back and forth between different airports. A trip is handled by one pilot and involves one particular plane. Trips depart on a certain day and time from a departing airport, arriving at a different day and time in an arrival airport. Each airport is identified by a code, has a type (e.g., domestic), city and country of origin, and a maximum plane capacity (e.g., 100). Each plane has a unique name and a date of construction. A plane also has both weight and passenger capacities that cannot be exceeded. Each pilot has a name and an experience level (junior or senior). A senior pilot can supervise one (or many) junior pilots. However, a junior pilot can be supervised by only one senior pilot, if any. Create a database to record which pilots and planes are assigned to which trips, and to record the departure/arrival dates, times, and locations of different trips.>
A fiberglass manufacturer, Floating Fiber Inc. (FFI), specializes in manufacturing boats. The company has only two types of customers, retail and wholesale. For retail customers, FFI wants to store name (identifier), address and cost of the previous boat(s) owned. For wholesale customers, FFI wants to store name (identifier), address and Tax ID Number. There are three kinds of boats that the company makes: sailboats, rowboats and fishing boats. For all different types of boats that FFI manufactures, it wants to store ID (identifier) and the size of the boat (which is composed of the length and the maximum capacity). Customers can place orders for boats. A customer can purchase one or many boats and each boat is purchased by exactly one customer.
Do you need this or any other assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 10% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
