You are to draw an ER diagram for a hotel management system. This is
a system that has a number of hotels across the country. Each hotel
has a possibly different number of rooms.
Rooms can be classified in a number of ways (for example, 2 double
beds, a suite, one king, etc). Rooms have different prices based on
the day of the week and time of year. If there is a festival or other
tourist draw then rooms are generally priced higher, and Thursday,
Friday, Saturday night rooms are more expensive.
Guests or customers are given a bill for each stay (a stay is one or
more nights in a row) and notation is made of the date of payment.
Customers check into a particular room in a particular hotel on a
date, check out is assumed to be the date of the bill.
Generally, there is no need to have all the names of people staying
in a room, but a count of the number of adults and children is
necessary as rooms and each hotel have maximum occupancy rules.
You need to draw an ER diagram that represents this. Note all of the
entities and relationships, cardinality, indicate key attributes on
your diagram (and others if there is room and it is readable). On a
separate page list each entity and relationship that has any
attributes and list all of the attributes again indicating the
primary key for each. You can make up fields like person_id for keys
as long as they make sense.
Use the symbols and conventions taught in class. You need to turn
this in on Blackboard as a pdf with your name and section on both
pages. Do not do a hand drawing and take a picture of it! You must
also turn in the same thing on paper – a hard copy. It is easier for
the TA to grade and write corrections and suggestions on a piece of
paper. If either one is late, the assignment will be marked late.