Fundamental of database management system:
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Applications
Section: Chapter Questions
Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...
Related questions
Question
Fundamental of
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F085b2e97-d168-4009-ac33-6dadb7d2d456%2F79692528-0c01-4b9c-b418-1e5347c6108a%2F0pva4mg_processed.jpeg&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F085b2e97-d168-4009-ac33-6dadb7d2d456%2F79692528-0c01-4b9c-b418-1e5347c6108a%2Fj5y07sa_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning