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, 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
Given the relation and functional dependency Relation EmployeeSS Name Address Phone Father Skills FD ... View full answer
Get step-by-step solutions from verified subject matter experts
