This is for the following class CS-432_Database Systems. Please answer the following question(s) and keep it simple. Thank you(will leave like). No need for codes, just design.

Use ER-diagram to design an ER model for a Student Residence Life Database, to store anything you believe essential for this database system.

For examples (you can use your own words):

Student Info: SID (student id), sname(incluse first & last) , email.

Student Contact Info: name(guardian first & last name), relationship, phone(includes work & cell).

Residence Hall Info: building name, capacity, location.

Dorm Room Info: building(residence hall), room #, type(ex. single, double).

============================================================================

(Please consider to design Dorm Room as weak entity type. eg. Room 101 of Park Hall and Room 101 of Garden Hall have the same Room #, but belong to different buildings).

One Student can live in one (only current) dorm, specifying the semester; RA must live in a residence hall, to cover a bunch of dorms as RA job, for a specific semester.