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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!