Apply all the normalization forms applicable to create separate tables with proper attributes on the below denormalized
Posted: Fri May 20, 2022 5:01 pm
- Apply All The Normalization Forms Applicable To Create Separate Tables With Proper Attributes On The Below Denormalized 1 (148.04 KiB) Viewed 53 times
I only need 5NF only
Apply all the normalization forms applicable to create separate tables with proper attributes on the below denormalized table (data) (Hint: There should be 5 tables at the end). Create 5 tables with columns and data. Split these data and put it in each of those tables, show the PK, FK wherever needed. Apply Norm forms 1-5 wherever is applicable but not necessarily all forms are applied to each table. Make sure all the data points in below table make it to some normalized tables. If any table requires PK like Customer ID etc. then add it and reference that ID in other tables. Sales Records: Cust Name Alan Smith Roger Banks Evan Wilson Alan Smith Item Xbox One PlayStation 4 Xbox One, PS Vita PlayStation 4 Shipping Address 35 Palm St, Miami 47 Campus Rd, Boston 28 Rock Av, Denver 47 Campus Rd, Boston Newsletter Xbox News PlayStation News Xbox News, PlayStation News PlayStation News Supplier Microsoft Sony Wholesale Sony Supplier Phone (800) BUY-XBOX (800) BUY-SONY Toll Free (800) BUY-SONY Price 250 300 450 300