Question: Problem 4. Examine the table shown below. staf No branchNo branchAddress name position hoursPerMeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant


Problem 4. Examine the table shown below. staf No branchNo branchAddress name position hoursPerMeek 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 Sinclau Assistant 14 S4612 B004 16 - 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 staffing and branchNo are the composite primary key pair of the table. Deduce the following: a) Identify the Normal Form of the Table? Mention step by step reasoning. [2 marks] b) Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF)? Basically, design the tables with its attributes and keys which will be formed as a result of the table converted to a 3NF. Show the resulting tables below. You can use crows foot notation if needed to display the tables. Displaying data is not mandatory. Proper display of the resulting #NF normalised Table Schema is what is needed. [3 Mark]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
