Question: 6 . Based on the following description, draw an ER diagram of a campus housing information system. Apartment owners offer their property for rent. Owners

6. Based on the following description, draw anER diagramof a campus housing information system. Apartment owners offer their property for rent. Owners can have several apartments which appear on the apartment listing on the web. Apartments on the listing are characterized by location, number of bedrooms, monthly rent. Students interested in renting an apartment must register in the system using their student number. After that, student can review the apartment listing and select rental apartments. Students contact apartment owners through the system to make an appointment to see the apartment. The system keeps information about appointments. If students decide to rent an apartment, they sign a rental agreement with the owner and the apartment is deleted from the listing.
a. Indicate minimum and maximum cardinalities and degree of each relationship;
b. Show the attributes of each data entity;
c. If required, present a solution to avoid many-to-many relationships.[20 points]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!