Utilize the different concepts we discussed to design a database (single ER diagram) Question 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 arrival- time 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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Transcribed Image Text:Question 1 for a new airline company with the following specifications: Utilize the different concepts we discussed to design a database (single ER diagram) 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 arrival- time must be recorded for each flight. 7. Pilots can operate many flights using different Aircraft-Models. 8. Tourists are ified 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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions