Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Fundamental of database management system:

Fundamental of database management system:

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

Fundamental of database management  system:

Paul Bunyan is the owner of a wooden toy distributor named Blue Ox Distribution. He has decided to store his data in an electronic, relational database in order to ensure that it is current and accurate. Currently, he stores his data in a simple table, as shown below. 

1. Using Figure 7.27 below, identify the functional determinants and their associated dependencies. Salesperson Number Salesperson Number Salesperson Number Salesperson Number Salesperson Number Salesperson Name Commission Percentage Year of Hire Department Number > M anager Name Product Number Product Name Product Number Unit Price Department Number Salesperson Number, Product Number > M anager Name Quantity 2. Using Figure 7.30 below, convert the unnormalized table into First Normal Form (1NF). Explain the conversion process. HINT: When done, you will still have just a single table. SALESPERSON/PRODUCT table Salesperson Number Product Number Salesperson Name Commissian Percentage Year of Hire Department Number Manager Name Product Name Urit Price Quentity 137 137 19440 24013 1995 1995 17.50 26.25 Baker Scott Scott Scott 473 10 10 73 73 Hammer Saw Pliers Baker 170 1995 2001 2001 2001 137 26722 Baker 10 73 11.50 688 186 186 16386 19440 21765 A dams A dams 15 15 15 59 59 59 Lopez Lopez Lopez Lopez Scott W rench Hammer Drill 12.95 17.50 32.99 26.25 1475 2529 A dams A dams Dickens Dickens Carlyle Carlyle Carlyle 186 186 1962 3071 24013 15 2001 59 Saw 204 21765 1998 Drill Pliers W rench 10 73 32.99 809 204 361 361 361 26722 16386 21765 10 20 20 20 1998 2001 73 73 73 Scott Scott Scott 734 3729 11.50 2001 2001 Drill Pliers 12.95 32.99 11.50 3110 2738 26722 73 Scott
Transcribed Image Text:1. Using Figure 7.27 below, identify the functional determinants and their associated dependencies. Salesperson Number Salesperson Number Salesperson Number Salesperson Number Salesperson Number Salesperson Name Commission Percentage Year of Hire Department Number > M anager Name Product Number Product Name Product Number Unit Price Department Number Salesperson Number, Product Number > M anager Name Quantity 2. Using Figure 7.30 below, convert the unnormalized table into First Normal Form (1NF). Explain the conversion process. HINT: When done, you will still have just a single table. SALESPERSON/PRODUCT table Salesperson Number Product Number Salesperson Name Commissian Percentage Year of Hire Department Number Manager Name Product Name Urit Price Quentity 137 137 19440 24013 1995 1995 17.50 26.25 Baker Scott Scott Scott 473 10 10 73 73 Hammer Saw Pliers Baker 170 1995 2001 2001 2001 137 26722 Baker 10 73 11.50 688 186 186 16386 19440 21765 A dams A dams 15 15 15 59 59 59 Lopez Lopez Lopez Lopez Scott W rench Hammer Drill 12.95 17.50 32.99 26.25 1475 2529 A dams A dams Dickens Dickens Carlyle Carlyle Carlyle 186 186 1962 3071 24013 15 2001 59 Saw 204 21765 1998 Drill Pliers W rench 10 73 32.99 809 204 361 361 361 26722 16386 21765 10 20 20 20 1998 2001 73 73 73 Scott Scott Scott 734 3729 11.50 2001 2001 Drill Pliers 12.95 32.99 11.50 3110 2738 26722 73 Scott
3. Using Figure 7.32 below, convert the 1NF table from Step 2 into Second Normal Form (2NF). Explain the conversion process. HINT: When done, you will now have three tables. SALESPERSON table Salesperson Number Salesperson Name Year of Hire Commission Department Number Manager Name Рercentage 137 Baker 10 1995 73 Scott 186 A dams 15 2001 59 Lopez 204 Dickens 10 1998 73 Scott 361 Carlyle 20 2001 73 Scott PRODUCT table Product Number Product Name Unit Price 16386 W rench 12.95 19440 Hammer 17.50 21765 Drill 32.99 24013 Saw 26.25 26722 Pliers 11.50 QUANTITY table Salesperson Number Product Number Quantity 137 19440 473 137 24013 170 137 26722 688 186 16386 1745 186 19440 2529 186 21765 1962 186 24013 3071 204 21765 809 204 26722 734 361 16386 3729 361 21765 3110 361 26722 2738
Transcribed Image Text:3. Using Figure 7.32 below, convert the 1NF table from Step 2 into Second Normal Form (2NF). Explain the conversion process. HINT: When done, you will now have three tables. SALESPERSON table Salesperson Number Salesperson Name Year of Hire Commission Department Number Manager Name Рercentage 137 Baker 10 1995 73 Scott 186 A dams 15 2001 59 Lopez 204 Dickens 10 1998 73 Scott 361 Carlyle 20 2001 73 Scott PRODUCT table Product Number Product Name Unit Price 16386 W rench 12.95 19440 Hammer 17.50 21765 Drill 32.99 24013 Saw 26.25 26722 Pliers 11.50 QUANTITY table Salesperson Number Product Number Quantity 137 19440 473 137 24013 170 137 26722 688 186 16386 1745 186 19440 2529 186 21765 1962 186 24013 3071 204 21765 809 204 26722 734 361 16386 3729 361 21765 3110 361 26722 2738
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Transaction Processing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS