Question

Rest in Peace (RIP) is a hotel management company with 'unique' properties. RIP maintains a database to track their properties, rooms, bookings, and employees. Assuming you have entities for: PROPERTY - one row per property (hotel, lodge, inn, etc) ROOM - one row per room within a property EMPLOYEE - one row per employee working for RIP, Inc. 1. Using the above entities, describe a 1:M relationship and a M:N relationship. How about a 1:1 relationship? For this item, describe the relationships in terms of business rules. Remember that business rules should describe both sides of the relationship and should be able to be used to directly create the ERD.

2. Create an ERD using the relationships described in 1. Use Crow's foot notation for this.

3. If you were to covert the model as described in 2 to a set of tables and their relationships (i.e. a relational schema), what would the attributes for each of the entities be?

Answer 1