Question: 1 ) For the following relation, what attribute ( s ) would you select as the primary key? ( 2 pts ) Explain your answer.
For the following relation, what attributes would you select as the primary key? pts Explain your answer. pts Suppose an employee can only work in multiple employees.Employee NameEmployee IDBranch IDBranch LocationKate SmithLondonEric GreenNYAmee WhiteHoustonJane LeeLA Find the precise form eg UNF, NNF or NF of the relation pts If the relation is in NF explain why; if it's not, normalize it to NF pts You don't have to copy the data in the table; just write the schemas.
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
