Normalization Process

i. Apply the normalization process to normalize the database to 3NF.

ii. Show each step taken that is, movement from one normal form to another. 

iii. Show the final normalized database. 

 

Transcribed Image Text:

Contract Contract Number Claims 00 Contract Number Description Claim Number Division Bill_Number District Completed Bill Description Item Number Item Description Unit Rate Place Quantity Date Items 00 Contract Number Bill Number Bill Description Item Number Item Description Unit Rate Total Quantity Contract Contract Number Claims 00 Contract Number Description Claim Number Division Bill_Number District Completed Bill Description Item Number Item Description Unit Rate Place Quantity Date Items 00 Contract Number Bill Number Bill Description Item Number Item Description Unit Rate Total Quantity