Answered: the different concepts we discussed to…

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...

See similar textbooks

Related questions

Question

100%

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 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