Draw ERD and Map to Relations Map the ERD you have created to relations including all keys (PKs and FKs) 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
Draw ERD and Map to Relations
Map the ERD you have created to relations including all keys (PKs and FKs)
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
