Question: Consider the relation below and the given functional dependency (FD). Employee: (SS#, Name, Address, Phone, Father, Skills) FD: Address Phone Which of the following

 Consider the relation below and the given functional dependency (FD). Employee: (SS#, Name, Address, Phone, 

Consider the relation below and the given functional dependency (FD). Employee: (SS#, Name, Address, Phone, Father, Skills) FD: Address Phone Which of the following statement(s) is/are true? Select one or more: OA. It cannot be further decomposed. OB. Relation Employee is in 1NF. O C. The relation can be further decomposed as Employee( SS#, Name, Address, Father, Skills) Emp_Phone(Address, Phone). OD. Relation Employee is currently in 3NF. OE. The relation can be decomposed as Employee(SS#, Name, Address, Father, Skills) Amp_Address(Name, Phone, Address).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Given the relation and functional dependency Relation EmployeeSS Name Address Phone Father Skills FD ... View full answer

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!