Question:
You want to extend the schema depicted in Table 4-16 (see next page) to include information about payments from customers. Customers can make installment pay¬ ments oh each invoice. They may also write one check to pay for several different invoices. Ashton specifically wants to store the following information;
amount applied to a specific invoice cash receipt number customer name customer number date of receipt employee processing payment invoice payment applies to total amount received Required
a. Modify the set of relational tables in Table 4-16 to store this additional data.
b. Identify the primary key for each new table you created in step a.
c. Implement your schema using any relational DBMS package available to you. Indicate which attributes are primary and foreign keys, and enter sample data in each table you create.
Transcribed Image Text:
Table 4-16 Database That Needs to Be Extended Sventery: Teble Number 1267) 19 Monetar Descaption Quaditya Hand List Price 13 5496 00 10574 21 Mor B $949 00 10622 Laser Pre 22 $395.00 10623 Color Laver Printer 5699 00 10624 Mb Anctional Printer 12 $799 00 Record 4 TENTOS Tavantery Table (Item sumber is primary key) Customer Table Customer 11255 G Hearg 12971 Jackson 13629 P Szabe 15637 S Man 18229 8 Adama Speet 2903 Man City State Op Code Credit Un Accue Balance Mesa AZ 15201 $4.00000 $875 00 466 W Oak Tempe AZ 16236 $5.00000 $2.500 246 Plan Mess AZ 35291 $6 000 00 $3.955.00 2066 Spring Tempe AZ 35207 55 000 00 1744 Apache Tempe AZ 85287 $3.000.00 $250.00 $1.675.00 Second TOCROS Customer Table (Customer samber is primary key) Sales: Table Invoice Date Salesperson Customer Amont 10001 08 Sep 0 25 15637 $399 00 10002 10-Sep-00 22 12975 $1,748.00 10003 25 Sap-08 24 13629 $1,105 00 10004 02-01-00 25 11256 $1900 10006 11-Oct-08 22 15637 $1,050 00 10006 25-04-48 25 18225 $330.00 Pacard or Sales Table (laveice Number is primary key) Sales Inventory Lite items Tabl wice tem Number Quaanty Actual Une Price 10001 10573 5435.00 10002 10574 1 5949.00 10002 10624 1 $799.00 10000 10622 3 $395 00 10004 10673 1 $495.00 10005 1067) 1 5495 00 10005 10623 + $699.00 10005 10673 2 $455.00 TENDE teare Sales-laventory Line Items Table (Combination of levoice Number and Tram Namber farms primary key)