Please help identify the cardinality for each relationship, assuming the followi

Question

Please help identify the cardinality for each relationship, assuming the following rules:

A pool may or may not ever have a class.

The levels table must always be associated with at least one class.

The staff table may not have ever taught a class.

All students must be enrolled in at least one class.

The class must have students enrolled in it.

The class must have a valid pool.

The class may not have an instructor assigned.

The class must always be associated with an existing level.

Thank you.

tblLevels Level ClassName tblClasses Lessonindex Level SectionID Semester Days Time Pool Instructor Limit Enrolled Price tblStudents tblEnrollment LessonIndex SID Status Charged AmountPaid DateEnrolled SID FirstName Middlelnitial LastName Suffix Birthday LocalStreet LocalCity LocalPostalCode LocalPhone tblPool Pool PoolName Location tblStaff StaffID FirstName MiddleInitial LastName Suffix Salaried PayAmount

Explanation / Answer

1. One to Many

2. One to Many

3. One to Many

4. Many to Many

5. One to Many

6. Many to One

7. Many to One

8. Many to One

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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