Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(1) 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

image text in transcribed

(1) 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: ProjectlD FIGURE 3-32 Sample Data for Regional Labs EmployeeName EmployeeSalary 64,000.00 Eric Jones 100-A 100-A Donna Smith 70,000.00 100-B Donna Smith 70,000.00 200-A Eric Jones 64,000.00 64,000.00 Eric Jones 200-B 200-C 200-C Eric Parks 58,000.00 Donna Smith 70,000.00 200-D Eric Parks 58,000.00 1. Assuming that all functional dependencies are apparent in this data. Please list all the functional dependencies in the table in the following format: 2. Please describe the table structure with the table structure notation, as shown below: 3. Does the table violate 1NF? If so correct it (please also put it sentence structure). 4. Does the table in question 3 violate 2NF? If so correct it and describe the new tables with the table structure notation. Example: SKU_DATA ORDER_ITEM (SKU, SKU_Description, Department, Buyer) (OrderNumber, SKU, Quantity, Price, ExtendedPrice) Where ORDER_ITEM.SKU must exist in SKU_DATA.SKU 5. Does the table in question 4 violate 3NF? If so correct it and describe the new tables with the table structure notation

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

MongoDB Applied Design Patterns Practical Use Cases With The Leading NoSQL Database

Authors: Rick Copeland

1st Edition

1449340040, 978-1449340049

More Books

Students also viewed these Databases questions