Normalization/ERD for Flight Schedule

C1116

A user who schedules planes for flights determines the type of plane to be used each day for each flight, and can change the type of plane if necessary. Normalize to 3NF and come up with a relational model. You should look at the data carefully and note details like Flight #'s are not unique, but they appear to determine other attributes.

given table

How can I normalize this? If there are no unique identifiers (primary keys) then how can this be done? I've started drawing the dependencies(below), but I'm not sure where to go from here/if I'm doing it right.

work so far

WorkSmarter

I would do something like this

**Flight**
Flightid, flight_num, plane_typeid, destinationid, departdatetime

**Reservation**
Reservationid, Flightid, seatsreserved, userid

**Destination**
Destinationid, destination

**Plane_type**
Plane_typeid, Plane_type, capacity

**User**
Userid, firstname, lastname

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Related Related

HotTag

Archive