Question: Problem 4. Examine the table shown below. staf No branch No branchAddress name position hours Per Week $4555 B002 City Center Plaza. Seattle, WA 98122

 Problem 4. Examine the table shown below. staf No branch No

branchAddress name position hours Per Week $4555 B002 City Center Plaza. Seattle,

Problem 4. Examine the table shown below. staf No branch No branchAddress name position hours Per Week $4555 B002 City Center Plaza. Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 - 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 $4612 B002 City Center Plaza, Seattle, WA 98122 Dave Sinclair Assistant S4612 B004 16 - 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 staffNo and branchNe are the composite primary key pair of the table. Deduce the following: I 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!