Answered step by step
Verified Expert Solution
Link Copied!

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 multi-valued attributes (if applicable) M:N relationships properly.
1. 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.
2. 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions