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.
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
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.
Step by step
Solved in 4 steps with 2 images