Question: 1) Create a relation by listing all the functional dependencies of composite primary keys. 2) Normalize to 3NF. 3) Populate data and explain how the

1) Create a relation by listing all the functional dependencies of

1) Create a relation by listing all the functional dependencies of composite primary keys.

2) Normalize to 3NF.

3) Populate data and explain how the 3 anomalies are eliminated.

DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE - The DEPARTMENT OF TRANSPORIATION (DOT) Project Table captures the data about projects and their length (in miles). - Each project has a unique Project ID and Project Name. - Each county has a unique County ID and County Name. - Each project manager has a unique Project Manager ID and Project Manager Name. - Each project has one project manager. - A project manager can manage several projects. - A project can span across several counties. - This table records the length of the project in a county in the ProjectMilesWithinCounty colunn. Answer the following questions based on the DOT relation and descriptions given above. 1) Create a relation by listing all the functional dependencies of composite primary keys. 2) Normalize to 3NF. 3) Populate data and explain how the 3 anomalies are eliminated. DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE - The DEPARTMENT OF TRANSPORIATION (DOT) Project Table captures the data about projects and their length (in miles). - Each project has a unique Project ID and Project Name. - Each county has a unique County ID and County Name. - Each project manager has a unique Project Manager ID and Project Manager Name. - Each project has one project manager. - A project manager can manage several projects. - A project can span across several counties. - This table records the length of the project in a county in the ProjectMilesWithinCounty colunn. Answer the following questions based on the DOT relation and descriptions given above. 1) Create a relation by listing all the functional dependencies of composite primary keys. 2) Normalize to 3NF. 3) Populate data and explain how the 3 anomalies are eliminated

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 General Management Questions!

Database Design Problem You have been hired to review the accuracy of the books of Northeast Seasonal Jobs International (NSJI), a job broker. NSJI matches employers whose business is seasonal (like...

Dear Tutor, Attached please find my assignment. Could you help me? Thanks in advance . Database Design Problem You have been hired to review the accuracy of the books of Northeast Seasonal Jobs...

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

Please answer assignment task 2. This lab assignment is intended to analyze the issues surrounding the database tables provided, to identify functional dependencies in those tables and to normalize...

Please answer assignment task 4. This lab assignment is intended to analyze the issues surrounding the database tables provided, to identify functional dependencies in those tables and to normalize...

Please answer assignment task 3. This lab assignment is intended to analyze the issues surrounding the database tables provided, to identify functional dependencies in those tables and to normalize...

Please answer assignment task 1. This lab assignment is intended to analyze the issues surrounding the database tables provided, to identify functional dependencies in those tables and to normalize...

Skills needed: Given a non-normalized Relation (Table) and a set of functional dependencies FDs, analyze the FDs to normalize the relation up to 3NF or BCNF to avoid anomalies: 1- Identify...

Page. 1 210.02 Lab 210.02 Data Normalization Lab (Revised 2/11/04) Data Normalization Basics This exercise consists of two exercises that will demonstrate your ability to normalize data using the...

Needs correct answer for the 18 multiple choice questions on Accounting Information & Control Systems (AIS) home / homework help / questions and answers / business / accounting / 1. of the following,...

An analyst projects that company XYZs sales will increase from $2.2 million to $2.4 million. COGS will increase from $1.4 million to $1.5 million, but fixed costs and depreciation expense should...

Joint Cost Allocation. Memory Manufacturing Company (MMC) produces memory modules in a two-step process: chip fabrication and module assembly. In chip fabrication, each batch of raw silicon wafers...

The Devin Booker Co . has an asset that costs $ 4 4 0 , 0 0 0 and is depreciated straight - line to zero over its 8 - year tax life. The asset is to be used in a 3 - year project; at the end of the...

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...