NOTE: DO NOT COPY

create an E$-$R Diagram ON PAPER OR ANY DRAWING FORMAT 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 $($similar to 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.

Note: The verbal description may not have all of the information you need to determine some of the properties of the entities, attributes, or relationships. You may have to use your own judgment, or think of what follow$-$up questions you might ask and decide what you think the reasonable answers would be$.$ If you find that you make any assumptions that are not stated in the verbal description, list them under a heading $$Additional Assumptions$$ at the end of your formal written description. For example, you might include assumptions such as $$A faculty member can belong to more than one department.$$ or $$Can two students have the same name? Yes.$$