Question: 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

 b) Describe and illustrate the process of normalizing the data shown

in this table to third normal form (3NF)? Basically, design the tables

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] Examine the table shown below sta/No branch No branchuddress name position hours Parrot SASSS B002 City Center Plaza, Seanile, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 - 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza, Seanle, WA 98122 Dave Sinclair Assistant 54612 B004 16 - 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 stating and branchNe are the composite primary key pair of the table. Deducelthe following a) Identify the Normal Form of the Table? Mention step by step reasoning [2 marks]

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!