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

  

Transcribed Image Text:

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). 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).

Answer rating: 100% (QA)

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