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: F

Answer

No, ProjectID is not a determinant

Work Step by Step

A determinant is an attribute (or set of attributes) on which some other attribute is functionally dependent. ProjectID alone does not determine EmployeeName. ProjectID alone does not determine EmployeeSalary, because many employees can work on the same project. Therefore, ProjectID is not a determinant. The determinants in this table are: (ProjectID, EmployeeName) → EmployeeSalary (primary key) EmployeeName → EmployeeSalary (partial dependency)
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.