What is the primary key of project

Assignment Help Database Management System

Reference no: EM131897384

Assignment - Consider the following relation definition and sample data (PROJECT)

ProjectID	EmployeeName	EmployeeSalary
100A	Jones	64k
100A	Smith	51k
100B	Smith	51k
200A	Jones	64k
200B	Jones	64k
200C	Parks	51k
200C	Smith	51k
200D	Parks	51k

Where ProjectID is the name of a work project; EmployeeName is the name of an employee who works on that project; EmployeeSalary is the salary of the employee whose name is EmployeeName.

Please answer:

A: ProjectID → EmployeeName. T or F

B: ProjectID → EmployeeSalary T or F

C: (ProjectID, EmployeeName) → EmployeeSalary T or F

D: EmployeeName → EmployeeSalary T or F

E: EmployeeSalary → ProjectID T or F

F: EmployeeSalary → (ProjectID, EmployeeName) T or F

G: What is the primary key of PROJECT?

H. Does this table contain partial dependency and/or transitive dependency?

I. Describe two modification anomalies from which PROJECT suffers.

J. In what normal form is PROJECT?

K: Redesign this relation to eliminate the modification anomalies. Please give the table (structures) with data.

Attachment:- Assignment File.rar

Reference no: EM131897384

Questions Cloud

Valuation of merger target : Hastings Corporation is interested in acquiring Vandell Corporation. What are Vandell’s cost of equity and weighted average cost of capital?

Embrace nontraditional practices : How will this affect diseases in the United States in the future? How as medical professionals (nurses) can we embrace these nontraditional practices?

Canada criminal code : Polygamy is illegal under Canada's Criminal Code. A woman who follows a religion that endorses polygamy applies to the clerk of her municipality

What event prompted the usa to join the world war i : Name two houses of the British Parliament. What event prompted the United States of America (USA) to join the First World War in 1917?

What is the primary key of project : What is the primary key of PROJECT? Describe two modification anomalies from which PROJECT suffers. In what normal form is PROJECT

How can socialization and mentoring be used : The team has been invited to present at a conference before top executives of Fortune 500 companies. The topic the team is presenting on.

Learning environment in a modern classroom : How does one create a positive learning environment in a modern classroom?

What is the profitability index of the investment : The investment will cost you $ 7,650 today. If appropriate Cost of Capital (quoted interest rate) is 12.1 %, what is the Profitability Index of the investment?

What are some examples of sustainability issues : What are some examples of sustainability issues that we can find in our community?

User Account

All Pages