Question: meadle.telt.unsw.edu.au INFS1603-51 Solved: Prepare an E Https:/moodle.t INFS1603-510 Exercise 3 Identify potential problems with the following table. Identify the PK. Draw dependencies diagrams and normalize

meadle.telt.unsw.edu.au INFS1603-51 Solved: Prepare an E Https:/moodle.t INFS1603-510 Exercise 3 Identify potential problems with the following table. Identify the PK. Draw dependencies diagrams and normalize the table to 3NF. alesPerson SalesPerso Code Region Region Company CompanySales Code Name Code Phone Name Name Amount ($) West 202 Gem Appliances 29,564 304 Sound Terrific35,986 515 United Kitchens 11, 870 134 r Brown 5674 286 Mr Green8976 2East137Rich Appliances 17, 796 174 Ms Pink 9765 1West 202 Gem Appliances 10,895 304 Sound Terrific 23, 896 879 Lisbon Furniture 89,653
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
