Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

From as Little as $6

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Northern Virginia Community College Normalization Discussion

Northern Virginia Community College Normalization Discussion

Question Description

1. To keep track of students and their advisors, a university uses the table structure shown below. Assuming that the sample data are representative, draw a dependency diagram in Powerpoint that shows all functional dependencies including both partial and transitive dependencies. (Hint: Look at the sample values to determine the nature of the relationships.)

Attribute Name

Sample Value

Sample Value

Sample Value

Sample Value

STUDENT_ID

123456

478596

123456

389987

STUDENT_NAME

Kim Brutt

Mary King

Kim Brutt

Donald Nouglle

ADVISOR_ID

123

473

567

123

ADVISOR_NAME

John Smith

Kim Young

Julia Roberts

John Smith

DEPARTMENT_CODE

AIT

CS

ECE

AIT

DEPARTMENT_NAME

Applied Information Technology

Computer Science

Electrical Engineering

Applied Information Technology

APPOINTMENT_DATE

01/01/2009

05/03/2009

03/06/2009

01/01/2009

2. Using the initial dependency diagram drawn in question 1, remove all partial dependencies, draw the new dependency diagrams in Powerpoint, and identify the normal forms for each table structure you created.

3. Using the table structures you created in question 2, remove all transitive dependencies, and draw the new dependency diagrams in Powerpoint. Also identify the normal forms for each table structure you created. If necessary, add or modify attributes to create appropriate determinants or to adhere to the naming conventions.

4. Using the results of question 3, draw the fully labeled Crow’s Foot ERD in Powerpoint. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.