Please read the Question CAREFULLY before you answer

b. [25 points] Consider the schema Customer (order file figure 9-1). Is this schema normalized? If yes, explain. If not, normalize it and explain. I Hints: you can decompose the table to multiple tables if necessary] Payment Order Number 234 Cust ID Amount Tax Type Prior Customer Y Y MC N Y 236 237 238 239 Y Y 240 241 2242 9500 1556 2242 2242 1035 9501 1123 9500 4254 9500 2242 4254 2241 4254 N N Date 11/2100 11/2370 11/2100 1121700 11/23/00 11/21 112000 11/2000 11/2000 11/2400 11/24/00 11124.00 11/24.00 1112400 11/24,00 11/24/00 11/2400 1112400 112400 11/2400 242 243 244 Last Name DeBerry Chin Tracken Deferry DeBerry Black Kaplan Williams Chin Bailey Chin Detery Bailey Jones Bailey Lee DeBerry Chin Deferry Deblery First Name Ann April Chris Ann An John Bruce Mary April Ryan April Anin Kyan Chris Ryan Diane Ann April Ann Ann $90.00 5.12.00 $ 50.00 5 75.00 560.00 SOXXO 550.00 5120.00 $ 60,00 $ 90,00 $ 24,00 $ 12.00 $ 20.00 $ 50.00 $ 12.00 $50.00 $ 12.00 $ 15.00 $112.00 $12.00 55.85 0. $2.50 54.80 53.0 54 50 $250 59.60 $3.00 54.30 $1.20 $0.78 51.00 $2.50 $0.60 $2.50 $0.78 50.75 $8.50 Total 5.9585 $12.00 $ $2.50 5.79.88 563.90 S94.50 5 52.50 $129.60 5 63.00 $94.50 $ 25.20 5 12.7 $ 21.00 $ 52.50 $ 12.60 5 52.50 5127 $15.75 S14058 $ 76.68 Y Y Y VISA VISA AMEX MC AMEX VISA MC VIA VISA VISA AMEX MC VISA AMEX AMEX MC MC MC AMEX Y Y 246 N Y 5927 24 249 250 251 252 N y Y 2242 9500 2242 2242 $4.651 Y FIGURE 9-1 Customer Order File b. [25 points] Consider the schema Customer (order file figure 9-1). Is this schema normalized? If yes, explain. If not, normalize it and explain. I Hints: you can decompose the table to multiple tables if necessary] Payment Order Number 234 Cust ID Amount Tax Type Prior Customer Y Y MC N Y 236 237 238 239 Y Y 240 241 2242 9500 1556 2242 2242 1035 9501 1123 9500 4254 9500 2242 4254 2241 4254 N N Date 11/2100 11/2370 11/2100 1121700 11/23/00 11/21 112000 11/2000 11/2000 11/2400 11/24/00 11124.00 11/24.00 1112400 11/24,00 11/24/00 11/2400 1112400 112400 11/2400 242 243 244 Last Name DeBerry Chin Tracken Deferry DeBerry Black Kaplan Williams Chin Bailey Chin Detery Bailey Jones Bailey Lee DeBerry Chin Deferry Deblery First Name Ann April Chris Ann An John Bruce Mary April Ryan April Anin Kyan Chris Ryan Diane Ann April Ann Ann $90.00 5.12.00 $ 50.00 5 75.00 560.00 SOXXO 550.00 5120.00 $ 60,00 $ 90,00 $ 24,00 $ 12.00 $ 20.00 $ 50.00 $ 12.00 $50.00 $ 12.00 $ 15.00 $112.00 $12.00 55.85 0. $2.50 54.80 53.0 54 50 $250 59.60 $3.00 54.30 $1.20 $0.78 51.00 $2.50 $0.60 $2.50 $0.78 50.75 $8.50 Total 5.9585 $12.00 $ $2.50 5.79.88 563.90 S94.50 5 52.50 $129.60 5 63.00 $94.50 $ 25.20 5 12.7 $ 21.00 $ 52.50 $ 12.60 5 52.50 5127 $15.75 S14058 $ 76.68 Y Y Y VISA VISA AMEX MC AMEX VISA MC VIA VISA VISA AMEX MC VISA AMEX AMEX MC MC MC AMEX Y Y 246 N Y 5927 24 249 250 251 252 N y Y 2242 9500 2242 2242 $4.651 Y FIGURE 9-1 Customer Order File