Question: You have the table T = ( name , ssn , phone number ) representing a person. Each name is uniquely identified by ssn ,
You have the table T name ssn phone number representing a person. Each name is uniquely identified by ssn but the same name can have multiple phone numbers. Suppose you break the table into two tables Tname ssn and Tname phone number
a What are the candidate keys of T T and T respectively?
b Does the decomposition remove redundancy? If so why?
c Which problems ie operation anomalies can appear in table T Explain your answer.
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
