In this assignment, you will create an E-R Diagram and a corresponding formal written description for a small database of information about college students.

The main thing we keep track of is students. Each student has a name and an ID number. We also keep information about the high school that each student graduated from: its name and location (the location is made up of the city and state). We may not know every students high school. Every student has a faculty member who serves as their advisor; we keep track of their names and departments (faculty members also have ID numbers). Not all faculty members advise students, though we wish they would. Most students live on campus, so we also keep track of the rooms in our one dormitory its brand new all of the rooms are single occupancy. Each room has a room number, and is in either the South or North wing. The dormitory isnt full, even though we still have some students who do not live on campus.

Draw an E-R diagram containing the four entities discussed above, their attributes and keys, and the relationships among them. Also give a formal written description of your E-R model, with all of the necessary information for each entity include attributes and key and each relationship.