2.1 Creating an REA Diagram based on given tables Examine the following tables and indicate the primary key (using PK) and the foreign key(s) (using FK) for each table. Based on the given tables, draw a complete REA diagram for the database. . Inventory Unit Cost Item_No Description Unit Price QOH 100 200 150 95 2010 2015 2020 2025 2030 2035 2040 2045 Blender Toaster Mixer Television Freezer Refrigerator Radio Clock 14.00 12.00 23.00 499.00 799.00 699.00 45.00 79.00 29.95 19.95 33.95 699.95 999.95 849.95 79.95 99.95 52 75 200 150 Salesperson Cashier Salesperson_No Salesperson_Name Cashier_No Name 101 John Smith 201 Scott Brown Stony Lee 102 Brenda Kim 202 103 Julia Berens 203 Jim White 104 Joe McGuire 204 Pat Thomas Customer City Customer_No Name State Credit Limit 1000 1001 1002 1003 1004 1005 1006 1007 Smith Phoenix Jones St. Louis Jeffries Atlanta Gilkey Phoenix Lankford Phoenix Zeile Chicago Pagnozzi Salt Lake Arocha Chicago AZ MO GA AZ AZ 2500 1500 4000 5000 2000 2000 IL UT 3000 IL 1000 Sales Salesperson_No Invoice_No Date Customer_No Amount 101 102 101 103 103 104 4/03/2006 4/05/2006 4/05/2006 4/15/2006 4/15/2006 4/16/2006 5/02/2006 5/03/2006 1000 1003 1002 1000 1005 1007 1002 1000 103 104 102 102 101 1549.90 299.85 1449.80 799.90 849.95 99.95 2209.70 799.90 105 106 107 108 103 Cash Collections Amount Invoice_No Cashier_No Customer_No Rimittance_No Date 203 1000 220 278 276 5/02/2006 1549.90 5/10/2006 799.90 5/30/2006 2209.70 5/30/2006 849.95 101 108 107 105 202 202 1000 1002 289 204 1005 Invoice_No Sales-Inventory Item_No Quantity Extension 101 101 102 103 103 103 104 104 105 106 107 107 107 107 108 108 1025 1035 1045 1010 1015 1025 1025 1045 1035 1045 1030 1035 1040 1045 1025 1045 1 1 3 1 1 2 1 1 1 1 1 1 2 699.95 849.95 299.85 29.95 19.95 1399.95 699.95 99.95 849.95 99.95 999.95 849.95 159.90 199.90 699.95 99.95 2 1 1 2.1 Creating an REA Diagram based on given tables Examine the following tables and indicate the primary key (using PK) and the foreign key(s) (using FK) for each table. Based on the given tables, draw a complete REA diagram for the database. . Inventory Unit Cost Item_No Description Unit Price QOH 100 200 150 95 2010 2015 2020 2025 2030 2035 2040 2045 Blender Toaster Mixer Television Freezer Refrigerator Radio Clock 14.00 12.00 23.00 499.00 799.00 699.00 45.00 79.00 29.95 19.95 33.95 699.95 999.95 849.95 79.95 99.95 52 75 200 150 Salesperson Cashier Salesperson_No Salesperson_Name Cashier_No Name 101 John Smith 201 Scott Brown Stony Lee 102 Brenda Kim 202 103 Julia Berens 203 Jim White 104 Joe McGuire 204 Pat Thomas Customer City Customer_No Name State Credit Limit 1000 1001 1002 1003 1004 1005 1006 1007 Smith Phoenix Jones St. Louis Jeffries Atlanta Gilkey Phoenix Lankford Phoenix Zeile Chicago Pagnozzi Salt Lake Arocha Chicago AZ MO GA AZ AZ 2500 1500 4000 5000 2000 2000 IL UT 3000 IL 1000 Sales Salesperson_No Invoice_No Date Customer_No Amount 101 102 101 103 103 104 4/03/2006 4/05/2006 4/05/2006 4/15/2006 4/15/2006 4/16/2006 5/02/2006 5/03/2006 1000 1003 1002 1000 1005 1007 1002 1000 103 104 102 102 101 1549.90 299.85 1449.80 799.90 849.95 99.95 2209.70 799.90 105 106 107 108 103 Cash Collections Amount Invoice_No Cashier_No Customer_No Rimittance_No Date 203 1000 220 278 276 5/02/2006 1549.90 5/10/2006 799.90 5/30/2006 2209.70 5/30/2006 849.95 101 108 107 105 202 202 1000 1002 289 204 1005 Invoice_No Sales-Inventory Item_No Quantity Extension 101 101 102 103 103 103 104 104 105 106 107 107 107 107 108 108 1025 1035 1045 1010 1015 1025 1025 1045 1035 1045 1030 1035 1040 1045 1025 1045 1 1 3 1 1 2 1 1 1 1 1 1 2 699.95 849.95 299.85 29.95 19.95 1399.95 699.95 99.95 849.95 99.95 999.95 849.95 159.90 199.90 699.95 99.95 2 1 1