For the table below Use the sample data shown io find all function dependencies

Question

For the table below Use the sample data shown io find all function dependencies For each functional dependency, indicate whether or not it is likely to be true in general and why List the candidate keys Indicate whether or not the table is well-formed and why.

Explanation / Answer

1.Functional dependencies: Coursenumber->Coursename Reference->all the columns in the table(Coursenumber,Coursename,....etc) 2. Reference->all the columns in the table(studentid,studentname....etc) is should always be true in general since it is the primary key Coursenumber->Coursename may not be applicable if courseno changes without coursename changing in different semesters 3. Candidate key = Reference 4.The table is well formed since there is no null value in any of the entries

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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