DO NOT COPY FROM INTERNET. $($ Create an E$-$R Diagram ON PAPER and a corresponding formal written description for a

small database of information about college students. Here is the verbal description of the data to be

modeled:

"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 student's 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 $-$ it's 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 isn't full, even though we still have some students who do not live on

campus."

Your task is to 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 $($similarto what you see

in text or what I showed on slides during class$)$ of your E$-$R model, with all of the necessary information

for each entity $($including its attributes and key if one exists$)$ and each relationship.