Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
1. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies in 1NF. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.) 2. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams normalizing to 2NF. Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams, normalizing to 3NF. Also, identify the normal forms for each table structure you created. 4. Draw the Crow's Foot ERD.

1. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies in 1NF. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.) 2. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams normalizing to 2NF. Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams, normalizing to 3NF. Also, identify the normal forms for each table structure you created. 4. Draw the Crow's Foot ERD.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
100%

Normalization Diagram. See the attached picture. 

Using the table below, complete the following tasks: INVOICE INV_NUM PROD_NUM SALE_DATE PROD_LABEL 211347 211347 211347 211348 211349 AA- E3422QW QD- 300932X RU- 995748G AA- E3422QW GH- 778345P 15-JAN- 2016 15-JAN- 2016 15-JAN- 2016 15-JAN- 2016 16-JAN- 2016 Rotary sander 211 0.25-in. drill bit VEND_ CODE Band saw 211 309 Rotary sander 211 Power drill 157 VEND_NAME QUANT_PROD_ Neverfail, Inc. 1 Neverfail, Inc. 8 BeGood, Inc. 1 Neverfail, Inc. 2 ToughGo, Inc. 1 SOLD PRICE $49.95 $3.45 $39.99 $49.95 $87.75 1. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies in 1NF. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.) 2. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams normalizing to 2NF. Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams, normalizing to 3NF. Also, identify the normal forms for each table structure you created. 4. Draw the Crow's Foot ERD. 5. Submit your .vsdx Visio file containing all dependency diagrams and relational schemas for 1NF, 2NF, and 3NF as well as the Crow's feet ER diagram for grading. I ■
Transcribed Image Text:Using the table below, complete the following tasks: INVOICE INV_NUM PROD_NUM SALE_DATE PROD_LABEL 211347 211347 211347 211348 211349 AA- E3422QW QD- 300932X RU- 995748G AA- E3422QW GH- 778345P 15-JAN- 2016 15-JAN- 2016 15-JAN- 2016 15-JAN- 2016 16-JAN- 2016 Rotary sander 211 0.25-in. drill bit VEND_ CODE Band saw 211 309 Rotary sander 211 Power drill 157 VEND_NAME QUANT_PROD_ Neverfail, Inc. 1 Neverfail, Inc. 8 BeGood, Inc. 1 Neverfail, Inc. 2 ToughGo, Inc. 1 SOLD PRICE $49.95 $3.45 $39.99 $49.95 $87.75 1. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies in 1NF. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.) 2. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams normalizing to 2NF. Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams, normalizing to 3NF. Also, identify the normal forms for each table structure you created. 4. Draw the Crow's Foot ERD. 5. Submit your .vsdx Visio file containing all dependency diagrams and relational schemas for 1NF, 2NF, and 3NF as well as the Crow's feet ER diagram for grading. I ■
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS