dimanche 1 mars 2015

ERD to data structure


I'm new to databases. I converted my ERD to data structure. Althougt I made sure all the 1NF, 2NF and 3NF are handled, I'm skeptic about it. This is the data structure.



Port(PortID(pk), Name, Country, Population, PassPort_Req, DockingFee, Attractions)
Cruise(SerialNumber(pk), SailingDate, ReturnDate, DeparturePort)
Passenger(PassNum(pk), Name, HomeAddress, Nationality, Age)
Ship(ShipNum(pk), Name, Weight, YrBuilt, Capacity)
Sailor(SailorID(pk), Name, YrsService, Nationality)


Any suggestions?





Aucun commentaire:

Enregistrer un commentaire