Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Regional Labs Case Questions Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. and

Regional Labs Case Questions Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary) A. Assuming that all functional dependencies are apparent in this data, which of the following are true? 1. ProjectID -> EmployeeName 2. ProjectID -> EmployeeSalary 3.(ProjectID, EmployeeName)-> Employee Salary 4. EmployeeName -> Employee Salary 5. EmployeeSalary ProjectID 6. EmployeeSalary ->(ProjectID, EmployeeName) FIGURE 3-32 Sample Data for Regional Labs ProjectID EmployeeName Employee Salary 100-A Eric Jones 64,000.00100-A Donna Smith 70,000.00100-B Donna Smith 70,000.00200-A Eric Jones 64,000.00200-B Eric Jones 64,000.00200-C Eric Parks 58,000.00200-C Donna Smith 70,000.00200-D Eric Parks 58,000.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatial Databases With Application To GIS

Authors: Philippe Rigaux, Michel Scholl, Agnès Voisard

1st Edition

1558605886, 978-1558605886

More Books

Students also viewed these Databases questions

Question

Is this investment worthwhile? Why or why not?

Answered: 1 week ago