Question: 2. Consider the following relation definition and sample data (PROJECT) Where ProjectiID is the name of a work project, EmployeeName is the name of an

2. Consider the following relation definition and sample data (PROJECT) Where ProjectiID 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: Describe two modification anomalies from which PROJECT suffers. B: ProjectlD->EmployeeName True or False? C: (ProjectlD, EmployeeName)-> EmployeeSalary True or False? D: EmployeeName-> EmployeeSalary True or False? E: EmployeeSalary-> ProjectID True or False? F: What is the primary key of PROJECT? G: List the full, partial, and transitive dependencies (if any). H: In what normal form is PROJECT? I: Redesign this relation into 3NF. Please give the table (structures) with data. EmployeeName EmployeeSalary ProjectlD 64k 100A Jones Smith 51k 100A 51k 100B Smith 64k 200A ones Jones 64k 200 200C Parks 51k 200C Smith 51k 200D Parks 51k

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Consider the following relation definition and sample data (PROJECT) Where ProjectID is the name of a work project; EmployeeName is the name of an employee who works on that project; EmployeeSalary...

Mail - Jitwan Singh - Outlook x Content X + X C O...

You are required to design a system for assigning different projects to different employees of a company. Each project has a title, cost, and duration in months. Consider the following class...

2) Consider the following relation with sample data. - A student has a unique SID and a non-unique name. - A faculty member has a unique FID and a non-unique name. - A student can work for only one...

The tuple relational calculus {SP(S)} is the set of all tuples such that P(S) is neither true nor false. such that P(S) is true. such that P(S) is false. such that S is s subset of P in S Given two...

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

GEIT 3 3 4 1 : Database I Assignment# 1 1 ) Let R ( A 1 , A 2 , A 3 ) be a relation schema such that: dom ( A 1 ) = { A , B , C } dom ( A 2 ) = { 1 , 2 } dom ( A 3 ) = { 1 0 , 2 0 } 1 . 1 Give an...

Assignment# 1 1 ) Let R ( A 1 , A 2 , A 3 ) be a relation schema such that: dom ( A 1 ) = { A , B , C } dom ( A 2 ) = { 1 , 2 } dom ( A 3 ) = { 1 0 , 2 0 } 1 . 1 Give an example of a valid 4 3 -...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

what is the EFN Using the percent sales method, estimate the amount of external financing XYZ corp will need to fund the next years operations only compute 3 iterations. Assume that Sales will grow...

Give the magnitude and bearing for each vector. a. X-component: -9.1 units Y-component: 4.1 units b. X-component: 16.6 units Y-component: 14.4 units

EXERCISE 3-6. Cost per Equivalent Unit The balance in beginning Work in Process at Franz Silicon Compound Co. for direct labor was $120,000. During the month of May, an additional $500,000 of direct...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Explain why business communication is important to individuals and organizations.

Explain how cultural differences affect business communication.

List and explain the goals of business communication.