ITEC-8145 Week 3 Assignment Normalization Complete Solution

Document Content and Description Below

ITEC-8145 Week 3 Assignment Normalization Complete Solution 0 NF- A flat table with multiple concepts. 0 NF • Flat File • Repeating Groups (Blank) On the Customer Table, there is no repeating Grou... p Customer Customer ID Last Name First Name Street Adress City State Zip Current balance Credit Limit Sales Rep ID 124 Student's Last name Student's First name 481 Oak Lansing MI 49224 818.75 1000 3 256 Instructor's Last Name Instructor's First Name 215 Pete Grant MI 49219 21.5 1500 6 311 Charles Don 48 College Ira MI 49034 825.75 1000 12 315 Daniels Tom 914 Cherry Kent MI 48391 770.75 750 6 405 Williams Al 519 Watson Grant MI 49219 402.75 1500 12 412 Adams Sally 16 Elm Lansing MI 49224 1817.5 2000 3 522 Nelson Mary 108 Pine Ada MI 49441 98.75 1500 12 567 Dinh Tran 808 Ridge Harper MI 48421 402.4 750 6 587 Galvez Mara 512 Pine Ada MI 49441 114.6 1000 6 622 Martin Dan 419 Chip Grant MI 49219 1045.75 1000 3 0 NF • Flat File • Repeating Groups (Blank) On the Sales Representative Table, there is no repeating Group Sales Representative Sales Rep ID Last Name First Name Street Address City State Zip Region Region Description Total Commission Commission Rate 3 Johnes Mary 123 Main Grant MI 49219 C Central 2150 0.05 E Eastern 2150 0.05 6 Smith William 102 Raymond Ada MI 49441 W Western 4912.5 0.07 12 Diaz Miguel 419 Harper Lansing MI 49224 SC South Central 2150 0.05 420 Harper UP Upper Peninsula 2150 0.05 0 NF • Flat File • Repeating Groups (Blank) On the Order Table, there is no repeating Group [Show More]

Last updated: 1 year ago

Preview 1 out of 15 pages