for the table below use the sample data shown to find all functional dependencie

Question

for the table below use the sample data shown to find all functional dependencies. For each functional dependency indicate whether or not it is like to be there general and why list the candidates keys. Indicate whether or not the table is well formed and why.

Explanation / Answer

1.Functional dependencies: Coursenumber->Coursename Recordid->all the columns in the table(studentid,studentname....etc) 2. Recordid->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 = Recordid 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.