need 1) ERD and 2) relational model for an airline company An airline company has many planes
Question:
need 1) ERD and 2) relational model for an airline company
An airline company has many planes that travel between different airports. A trip is handled by one pilot and involves one plane. Trips depart on a certain day and time from a departing airport and arrive 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, and a maximum plane capacity (e.g., 100). Each plane has a unique name and a date of manufacturing. 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. need an ERD (conceptual model) and a relational model (logical model) to capture the data as described.
If information provided is insufficient for a decision (e.g. determining the cardinality of a relationship), you can make reasonable assumptions. However, your assumptions must 1) not contradict information provided and 2) must be clearly noted on your models. You may add a simple key (e.g. customerID) to an entity if there is not a clear choice of an existing attribute that should serve as a primary key.
1) ERD and 2) Relational Model on the following criteria relative to the case given:
- Identifying and including all of the entities, and no others.
- Identifying and including all of the attributes of each entity, and no others.
- Identifying and including appropriate primary keys.
- Identifying, including and correctly characterizing relationships between entities.
- Addressing many-to-many relationships appropriately.
- Clearly legible and easy to interpret.
- Relational Model Only: Identifying foreign keys.
1- ERD created by Visio (or similar) and saved as a PDF
2- Relational Model created by Visio (or similar) or Excel and saved as a PDF
Auditing a business risk appraoch
ISBN: 978-0324375589
6th Edition
Authors: larry e. rittenberg, bradley j. schwieger, karla m. johnston