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.
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
