Identify the relationships among the entities and draw an ER diagram for the student accommodation office.
Introduction to Health Database and Technologies
The accommodation office of a university wishes to create a database to monitor the allocation of accommodation to
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.
