answer a and b questions below Examine the table shown below. This table represents the hours worked per week for temporary staff at each branch of a company staffNo branchNo BranchAddress name position hoursPerWeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 – 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza,Seattle, WA 98122 Dave Sinclair Assistant 14 S4612 B004 16 – 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 a. Identify the functional dependencies represented by the data shown in the table. State any assumptions you make about the data (if necessary b. Using the functional dependencies identified in part (b), describe and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.
answer a and b questions below
Examine the table shown below. This table represents the hours worked per week for temporary staff at each branch of a company
|
staffNo |
branchNo
|
BranchAddress |
name |
position |
hoursPerWeek |
|
S4555 |
B002 |
City Center Plaza, Seattle, WA 98122 |
Ellen Layman |
Assistant |
16 |
|
S4555 |
B004 |
16 – 14th Avenue, Seattle, WA 98128 |
Ellen Layman |
Assistant |
9 |
|
S4612 |
B002 |
City Center Plaza,Seattle, WA 98122 |
Dave Sinclair |
Assistant |
14 |
|
S4612 |
B004 |
16 – 14th Avenue, Seattle, WA 98128 |
Dave Sinclair |
Assistant |
10 |
a. Identify the functional dependencies represented by the data shown in the table. State any assumptions you make about the data (if necessary
b. Using the functional dependencies identified in part (b), describe and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.
Trending now
This is a popular solution!
Step by step
Solved in 6 steps
