Question: 1 ) For the following relation, what attribute ( s ) would you select as the primary key? ( 2 pts ) Explain your answer.

1) For the following relation, what attribute(s) would you select as the primary key? (2 pts) Explain your answer. (4 pts). Suppose an employee can only work in multiple employees.Employee NameEmployee IDBranch IDBranch LocationKate Smith10101LondonEric Green12302NYAmee White11504HoustonJane Lee11903LA2) Find the precise form (e.g. UNF, 1N,2NF, or 3NF) of the relation (2 pts).3) If the relation is in 3NF, explain why; if it's not, normalize it to 3NF (6 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 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 Programming Questions!