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.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
create a 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 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.
Transcribed Image Text: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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY