magine you are asked to design a simple database for an airport. You should accommodate for: - Passengers, their personal and their booking information - Airplanes, their cargo and their destinations - All available destinations and their distances. Please create or sketch the relational model of such database structure, including the relationships and cardinalities. The model should have at least 5 entities. Write SQL queries for the designed database which will return: - All people on the same flight - All planes on the same destination - If the sum of all cargo weight on the plane is under a threshold.
Imagine you are asked to design a simple
- Passengers, their personal and their booking information
- Airplanes, their cargo and their destinations
- All available destinations and their distances.
Please create or sketch the relational model of such database structure, including the relationships and cardinalities. The model should have at least 5 entities.
Write SQL queries for the designed database which will return:
- All people on the same flight
- All planes on the same destination
- If the sum of all cargo weight on the plane is under a threshold.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Hi.
What about this question. What does this mean exactly please to sketch and create the relational model etc?
"Please create or sketch the relational model of such
by Bartleby ExpertHello, can you provide an answer or add two more entities to make it 5 please?
What makes an entity set? Is one big table supposed to include all entity data or are you referring to separate tables?
by Bartleby ExpertHello. Thanks for the answer. Does this answer cover 5 entitities or is it 3? Thanks.
by Bartleby Expert
