Database Concepts

Published by Pearson
ISBN 10: 0133544621
ISBN 13: 978-0-13354-462-6

Chapter 2 - The Relational Model - Figure 2-33 - Sample Data for Regional Labs - Page 114: D

Answer

1st Normal Form

Work Step by Step

The table PROJECT table is in 1st Normal Form because there exist no multi valued attributes. It is not in the higher order Normal Form because there exist a dependency between EmployeeName and EmployeeSalary (EmployeeSalary can only be determined by Employee Name).The reason why it is not in 2nd Normal Form is that there exist a partial dependency EmployeeName->Employee Salary. So it is not in 2nd Normal Form, then higher normal forms are out of question.
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.