ZOOM
HCA-537: Introduction to Health Database and Technologies Instructor: Wu,M Homework 5: 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. Hints: ** Lease will be the center and directly related to Student, Room and Invoice. ** Hall is directly related to Room.