Question: Consider the Entity Relational ( ER ) schema of relation R = ( A , B , C , D , E ( E 1
Consider the Entity Relational ER schema of relation RA B C D EE E; knowing that there are the following functional dependencies fd: fd: A CB E fd: AD Can you guess the primary key attributes Justify your answer Is R in NF If yes why? If not modify R so as to put it in NF Let us call R the result of this step Is R in NF If yes why? If not modify R so as to put it in NF Let us call R the result of this step Is R in NF If yes why? If not modify R so as to put it in NF Question: Knowing the relational schema of the Company database: Write a relational algebra query to derive the new relation: EMPDEPENAME SSN BDATA, ADDRESS, DNAME, DMGRSNN Populate your new relation with at least entries, Discuss insertion, deletion and modification anomalies.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
