B&B Example –Generated Database Scheme

Room(RoomNr, RoomName, NrBeds, Cost)

Guest(GuestNr, GuestName, StreetNr, City)

Reservation(GuestNr, RoomNr, ArrivalDate, NrDays)

Room[RoomNr] ? Reservation[RoomNr]

Guest[GuestNr] = Reservation[GuestNr]

Previous slide

Next slide

Back to first slide

View graphic version