Relation R(SSN, EmpName, DeptNo, DeptName, DeptLoc) FDs: SSN → EmpName, DeptNo DeptNo → DeptName, DeptLoc Primary Key = {SSN} Which is correct?

Crowdly

Add to Chrome

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Relation R(SSN, EmpName, DeptNo, DeptName, DeptLoc)

FDs:

Primary Key = {SSN}

Which is correct?

d. R is in 1NF only

a. R is in 2NF but not 3NF

b. R is in 3NF

c. R is in BCNF

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome