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