Identify and describe at least 5 constraints that you were unable to model in th

Question

Identify and describe at least 5 constraints that you were unable to model in the ER diagram. (Hint: there are at least 12, think of the rules of baseball and the game and the limits on many in 1 to many relationships.

CONFERENCE ld (PK) Description SCHOOL ld Description specifie by PARTICIPANT Stadiumld (PFK) HomeTeam GAME Stadiumld (PFK) Date TickctPrice Attendance TEAM plays as/ played by Teamld (PFK) plays in Iplayed by ld (PKI (PK) PK) (PFK) specified by Confeld (FK) Schoolid (FK) specifiess location of held in OB Coachld(PFK) StartingDate (PK) EndingDate Salary Titield Teamld (FK) employer in employed by COACH ld (PK) Name SSN holds /held by STADIUM ld PK) City State (FK) JOB TITLE ld (PK) Description types typed by PITCHER member of consists of Playerld (PEK plays as lis Preference PLAYER ld SSN (PK) OUTFIELDER plays as Playerld (PFK Wcight Classiticationld (FK) Typcld Teamld Errors (FK) (FK) OTHER Playcrld (PFK Preference Comment plays as is PLAYER TYPE types /typed by ld (PK) Description PLAYER CLASSIFICATION ld classifies Iclas sified by (PK) Description

Explanation / Answer

1)

The CONFERENCE table is referencing to TEAM table with its primary key id and the referential key in TEAM table is Conferenceid, the relationship between these two is 1 to 0 or many.

2)

The SCHOOL table is referencing to TEAM table with its primary key id and the referential key in TEAM table is Schoolid, the relationship between these is 1 to 0 or many.

3)

The STADIUM table is referencing to GAME table with its primary key id and the referential key in GAME table is Stadiumid, the relationship between these is 1 to 0 or many.

4)

The GAME table is referencing to PARTICIPANT table with its primary key Date and the referential key in PARTICIPANT table is Teamid, Stadiuid, and Date the relationship between these is 1 to 0 or many.

5)

The TEAM table is referencing to PARTICIPANT table with its primary key id and the referential key in PARTICIPANT table is Teamid, Stadiumid, and Date the relationship between these is 1 to 0 or many.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.