Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sketch the ERD for the following two scenarios. Please use the same format as the attached image ( attached image is unrelated to this problem,
Sketch the ERD for the following two scenarios. Please use the same format as the attached image attached image is unrelated to this problem, I just included it to show you the formatting I need using draw.io Use proper ERD notations for attributes, entities, and relationships. Show all cardinalities, primary keys and foreign keys. Resolve all multivalued attributes if applicable M:N relationships properly.
Yale has many Dorms on Campus. Each Dorm has a Dorm Code, that is unique, as well as a dorm Name and dorm Location that is not unique. Dorms have Rooms. Each room has a Room Number that are unique within a Dorm but may not be unique between Dorms. Rooms also have a room Status and a room Size. All Rooms must exist within a Dorm. Students are also at Yale. A student has a unique Student Id Students also have a Name and a PO Box. A student may or may not live in a dorm room. A dorm room may have more than one student living in it or there may be no one living in a dorm room.
In the state of Connecticut there are many High Schools. Each high school is identified by a high school Name and has and Address, Phone number, Mascot, and Track Team. The track team is composed of students. Each student has a Student Id and Name. Students must be on a school team and can only be on one school team. One of the students is selected as the team Captain and leads the other team members. The track team competes in Track Meets across the state. The track meet is sponsored by one of the high schools and has a unique Meet Id as well as a Meet Date and Start Time. The meet consists of several events. Each event has a Name, and Description. Students from the different teams will compete in the different events. A student must compete in at least one event but may compete in many events. Some events do not have students competing in them. When a student competes in an event, their event Time, Distance, Place, and Points Earned is recorded.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started