Entity-Relationship Diagrams (ERD) Background Information: Study the following statements to determine the relationship between the entities • Each student has an academic advisor. An academic advisor...

Entity-Relationship Diagrams (ERD) Background Information:

Study the following statements to determine the relationship between the entities

• Each student has an academic advisor. An academic advisor can advise many students.

• Each academic advisor has a specific parking spot assigned.

• Each student can take up to five courses. and each course has up to 24 students.

• Several adjunct faculty members share an office.

Tasks: 1. Draw an ERD (it is just one diagram) showing the entities and the relationships among them. Include associative entities, if any. Also, remember to show cardinality (1:1, 1:M, M:N); you can use the cardinality notation or the crow’s foot notation. Remember that this is a graphical language, and you must follow the shapes of the elements in the diagram.