Question: Functional dependencies ( 2 0 points ) This task also relates to the university schema. Given the following relational schema: AssistantBossDiplomastudents : PersNr, Name, AreaofExpertise,

Functional dependencies (20 points)
This task also relates to the university schema. Given the following relational schema:
AssistantBossDiplomastudents : PersNr, Name, AreaofExpertise, BossPersNr, BossName, MatrNr, SName, Semester, SResidence]}
MatrNr, SName, Semester, SResidence are the data of the students supervised by the assistants. BossPersNr and BossName are the data of the professors who employ the assistants.
Proceed step by step:
(a) Determine the applicable functional dependencies (5 points) Briefly describe each step of your procedure so that the methodology can be recognized.
(b) Determine the candidate keys (5 points)
Briefly describe each step of your procedure so that the methodology can be recognized.
(c) Determine the canonical coverage of the functional dependencies (10 points)
Briefly describe each step of your procedure so that the methodology can be recognized.
 Functional dependencies (20 points) This task also relates to the university

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!