Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 3-32 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary) Assuming that all functional dependencies are apparent in this data, which of the following are true? ProjectID ->EmployeeName ___ ProjectID ->EmployeeSalary _ EmployeeName -> EmployeeSalary _ EmployeeSalary -> ProjectID _ EmployeeSalary -> (ProjectID, EmployeeName) What is the primary key of PROJECT? Are all the non-key attributes (if any) dependent on the primary key? In what normal form is PROJECT? Describe two modification anomalies that affect PROJECT. The two modification anomalies that affect PROJECT are: _ ____________ Is ProjectID a determinant? If so, based on which functional dependencies in part A? Is EmployeeName a determinant? If so, based on which functional dependencies in part A? _ Is (ProjectID, EmployeeName) a determinant? If so, based on which functional dependencies in part A? _______________________

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Instructions: Write your answers by replacing the blue lines. Explain your answers if necessary.

REGIONAL LABS CASE QUESTIONS

Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 3-32 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT:

PROJECT (ProjectID, EmployeeName, EmployeeSalary)

Assuming that all functional dependencies are apparent in this data, which of the following are true?
ProjectID ->EmployeeName _______
ProjectID ->EmployeeSalary _______
EmployeeName -> EmployeeSalary _______
EmployeeSalary -> ProjectID _______
EmployeeSalary -> (ProjectID, EmployeeName) ______
What is the primary key of PROJECT?

________________________________

Are all the non-key attributes (if any) dependent on the primary key?

____________________________________________

In what normal form is PROJECT?

____________________

Describe two modification anomalies that affect PROJECT.

The two modification anomalies that affect PROJECT are:

___________________________________________________________________________

____________________________________________________________________________

Is ProjectID a determinant? If so, based on which functional dependencies in part A?

______________

Is EmployeeName a determinant? If so, based on which functional dependencies
in part A?

_________________________________

Is (ProjectID, EmployeeName) a determinant? If so, based on which functional dependencies in part A?

_______________________________________

ProjectID
100-A
100-A
100-B
200-A
200-B
200-C
200-C
200-D
EmployeeName
Eric Jones
Donna Smith
Donna Smith
Eric Jones
Eric Jones
Eric Parks
Donna Smith
Eric Parks
EmployeeSalary
64,000.00
70,000.00
70,000.00
64,000.00
64,000.00
58,000.00
70,000.00
58,000.00

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions