Question: 234 A b. [25 points] Consider the schema Customer (order file figure 9-1). Is this schema normalized? If yes, explain. If not, normalize it and

234 A 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. (Hints: you can decompose the table to multiple tables if necessary Order Gust Last First Number Prior Date ID Name Payment Name Amount Tax Total Customer Type 11/23/00 2242 Deberry An $ 0.00 $5.85 5.95 85 Y MC 235 11/2100 9500 Chin April 5 12.00 $0.60 5.12.00 Y VISA 236 11200 156 Fracken Chris 550.00 $2.50 5 52.50 N VA 237 11/200 22:42 Delery 5 75.00 54.36 $79.00 Y AMEX 238 11/2100 2242 Ovey Ann $ 60.00 53.00 $1.00 Y MC 219 11/20 1015 Black John $ 0.00 54.50 SH.SO AK 240 11/23/00 9501 Kaplan S 50.00 $2.50 $ 5250 N VISA 241 11/21/00 1123 Williams $120.00 $9.60 $129.60 N MC 242 11/24/ 95C Chin April SOLINI $3.00 50.00 V VISA 24 11/24 4254 Bailey Ryan 590.00 $4.50 5.50 Y VISA 244 11/24 9500 April $24.00 $1.20 5 25.20 VISA 245 11/24/00 2242 Dellery Ann $ 12.00 $0.78 $ 12.78 Y AMEX 11/24/00 4254 Bailey Ryan $ 20.00 $1.00 $ 21.00 Y MC 247 11/24700 2241 Chris 550.00 $2.50 $ 52.50 N VISA 11/24/00 4254 Bailey Ryan $12.00 50.60 $12.00 Y AMEX 249 1122400 5927 Lee Diane $50.00 $2.50 5 52.50 N AMEX 250 2242 11/2400 DeBerry Ann $ 12.00 $0.78 Y $ 12.78 MC 11/2000 9500 Chin April $ 15.00 50.75 5 15.75 MO 252 11/24/10 Dellery 2242 Ann $112.00 Y $8.58 5140.58 MC 253 11/24/00 2242 Deberry Ann 5 72.00 $4.65 $ 76,65 Y AMEX Mary Chis FIGURE 9-1 Customer Order File

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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....

please try and simply the work I will appreciate thankyou a) Show that, with flexible prices, the natural level of output can be written as IT = ry,9 T= - o+ wy Briefly explain how and why a...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Chapter 9 Performance Management Skills A leader becomes complete only after giving something back. LAURENCE S. LYONS LEARNING OBJECTIVES By the end of this chapter, you will be able to do the...

2.2 51 Summarizing Data for a Quantitative Variable Exercises Methods 11. Consider the following data. WEB 14 19 24 19 16 20 24 20 file Frequency a. b. SELF test 21 22 24 18 17 23 26 22 23 25 25 19...

Warren Buffett?s Annual Shareholder Letter (page numbers for your convenience, but may not be comprehensive) 1. Describe the methods Warren Buffett uses to measure both his own firm?s performance and...

The University of Southern Mississippi College of Science & Technology IET 670 Section: G001 Supply Chain Design & Management Midterm Exam Full Points: 100 Student ID: Name: Closed book closed notes...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Read the article, "John D.R. Leonard, Plaintiff, -against- PepsiCo, Inc., Defendant," found on the website provided in the Reading & Study folder. Watch the presentations (also found in the Reading &...

Presented below is information for the Hale Partnership for the year ended 31 December 2012. Use the information to prepare a statement of cash flows.

Assume that the employees in Exercise 77 are paid from the companys regular bank account (check numbers 981 and 982). Prepare the entry to record and pay the payroll in general journal form, dated...

The managing broker of a corporation does not have to have an ownership interest in the corporation. A . True B . Fatse

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...