Step 1: Draw ERD and Map to Relations. Step 2: Map the ERD you have created to relations including all keys (PKs and FKs). After the solution convert the shape to schema Be aware that you will use Specialization (merge) Disclaimer: Do not resort to the previous solution on the site because the answer is wrong       Galaxy is an international Airline company. The company has several Airports each Airport is located at a different country. Each Airport has a name and capacity. Each Airport can hold several Aircrafts at the same time. Each Aircraft has ID, Type and Capacity. The Company has many Employees working in Airports. Each Airport has many employees working in it. Every employee working in an Airport can only one of three Jobs: Pilots, Admins and Mechanics. Each Employee has an ID, Name and salary. Pilots have Number of Flight hours and Mechanics have years of experience. The company keeps information of its customers. Each customer has Name and Passport ID. A customers can book one or more tickets. The company keeps information of its tickets such as flight date, Flight ID and Ticket ID. Each Ticket is associated with one customer and Aircraft.

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
icon
Related questions
Question

Step 1: Draw ERD and Map to Relations.

Step 2: Map the ERD you have created to relations including all keys (PKs and FKs).

After the solution convert the shape to schema Be aware that you will use Specialization (merge)

Disclaimer: Do not resort to the previous solution on the site because the answer is wrong

 

 

 

Galaxy is an international Airline company. The company has several Airports each
Airport is located at a different country. Each Airport has a name and capacity.
Each Airport can hold several Aircrafts at the same time. Each Aircraft has ID,
Type and Capacity. The Company has many Employees working in Airports. Each
Airport has many employees working in it. Every employee working in an Airport
can only one of three Jobs: Pilots, Admins and Mechanics. Each Employee has an
ID, Name and salary. Pilots have Number of Flight hours and Mechanics have
years of experience. The company keeps information of its customers. Each
customer has Name and Passport ID. A customers can book one or more tickets.
The company keeps information of its tickets such as flight date, Flight ID and
Ticket ID. Each Ticket is associated with one customer and Aircraft. 

 

Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Normalization
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education