Question

modation office of a university wishes to create a database to monitor the allocation of accommodation to The a students. Students may rent a room in a hall of residence. New lease agreements are negotiated with rental periods and rates. The students are sent an invoice at the start of each semester. The entities are identified as following, o Student o Lease o Room o Hall o Invoice Please identify the relationships among the entities and draw an ER diagram for student accommodation office. Hints: "Lease will be the center and directly related to Student, Room and Invoice. "Hall is directly related to Room.

Answer 1

The accommodation office of university wishes to create a data base to monitor the allocation and accommodation to students the students are sent an invoice at the starts of each segments. * student * lease * room * hall * invoice