Reference no: EM133234584

Utilize different concepts ( relationship = diamond shape , mapping cardinalities , min and max, partial relationship= one line , total relationship= two lines, identifying relationship= double diamond shape, weak entity set= double rectangle shape , strong entity set= single rectangle shape , primary key= underline , partial key = dotted line ) to design a database (single ER diagram) for a new airline company with the following specifications:

1. Pilots are identified by Pilot ID, and the SSN, first and last-name, full address, and salary must be recorded for each pilot.

2. Pilot Profiles are identified by Profile ID, and the food preferences (one or more values) and favorite destinations (one or more values) must be recorded for each profile.

3. Each pilot has only one profile; and If a pilot is deleted, you need not keep track of his/her stored profile.

4. Aircraft-Models are identified by Model ID, and the name, capacity, and cruising-range must be recorded for each Aircraft-Model.

5. Each Pilot is certified for one or more Aircraft-Model, and the date of each certification should be recorded.

6. Flights are identified by Flight ID, and the from-airport, to-airport, distance, departure-time, and arrivaltime must be recorded for each flight.

7. Pilots can operate many flights using different Aircraft-Models.

8. Tourists are identified by Tourist ID, and the first and last name, nickname, budget, and age must be recorded for each tourist.

9. Each tourist can book many flights, and each flight can hold many tourists.