Question

Design ER diagrams for the three problems below based on the information given. Use Visio or another drawing program: I will not grade hand-drawn diagrams. Your diagrams will include entities, attributes, relationships, candidate keys (PKs), and cardinality and participation constraints. Use the style of ER notation shown in the ER slides (also in Elmasri & Navathe, 6th edition, Figure 7.2 and Figure 7.14). Be sure to use good naming practice with your entities, relationships, and attributes. If you make any assumptions in addition to those given in the problem descriptions, include a note in the ER diagram to explain the assumption.

#1: Apartment Complex ER diagram. A management company needs a database to keep track various aspects of an apartment complex. The complex has 35 units in 7 buildings. Example queries and reports: • Which apartments are currently not rented, and what buildings are they in? • Generate a directory that lists all tenants in alphabetical order by last name, their apartment and building number, and phone number. • Who has clubhouse reservations for next month?

For each apartment, the database needs to keep track of the apartment number, the building number, the number of bedrooms, and the current rental price. Buildings are numbered 1-7 and in each building the apartments are numbered 1-5.

For each tenant, the database should store the tenant’s name, make and model of car (if any), and phone number. The management company assigns each tenant a unique tenant id number that should also be stored in the database. Each tenant can only rent one apartment, but an apartment can be rented by up to three tenants sharing the apartment. Some apartments may not be currently rented, but should still be listed in the database.

The apartment complex has a clubhouse with a kitchen, couches, and a large-screen television. Tenants can make a reservation to use the clubhouse. Reservations should record the date, starting time, and ending time for the reservation Each reservation is made by one tenant who will be responsible if there is any damage. Each tenant can reserve the clubhouse up to 3 times per month. Reservations should be recorded in the database when they are made.

Answer 1

#1