Based on the given tables, draw a complete REA diagram, 2.1 Creating an REA Diagram based...

     

Transcribed Image Text:

Based on the given tables, draw a complete REA diagram, 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. Item No Description 2010 Blender 2015 Toaster 2020 Mixer 2025 Television 2030 Freezer 2035 Refrigerator 2040 Radio 2045 Clock Inventory Unit Cost 14.00 12.00 23.00 499,00 799.00 699.00 45.00 79.00 Unit Price 29.95 19.95 33.95 699.95 999.95 849.95 79.95 99.95 QOH 100 200 150 95 52 75 200 150 == Salesperson No Salesperson Name 101 102 103 104 Salesperson Customer No 1000 1001 1002 1003 1004 1005 1006 1007 John Smith Brenda Kim Julia Berens Joe McGuire Name Customer City Smith Jones Jeffries Gilkey Lankford Zeile Pagnozzi Arocha Chicago Phoenix AZ St. Louis MO GA AZ AZ Atlanta Phoenix Phoenix Chicago Cashier No 201 202 203 IL Salt Lake UT IL Cashier 204 State Credit Limit Scott Brown Stony Lee Jim White Pat Thomas 2500 1500 4000 Name 5000 2000 2000 3000 1000 Invoice_No 101 102 103 104 105 106 107 108 Sales Date Salesperson No Customer_No 4/03/2006 4/05/2006 4/05/2006 4/15/2006 4/15/2006 4/16/2006 5/02/2006 5/03/2006 101 103 103 104 102 102 101 103 1000 1003 1002 1000 1005 1007 1002 1000 Amount 1549.90 299.85 1449.80 799.90 849.95 99.95 2209.70 799.90 Rimittance_No Date 220 278 276 289 Cash Collections Amount Invoice No Cashier_No Customer_No 5/02/2006 1549.90 101 5/10/2006 799.90 108 5/30/2006 2209.70 107 5/30/2006 849.95 105 203 202 202 204 1000 1000 1002 1005 Invoice_No 101 101 102 103 103 103 104 104 105 106 107 107 107 107 108 108 Sales Inventory Item No Quantity Extension 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 2 1 1 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 Based on the given tables, draw a complete REA diagram, 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. Item No Description 2010 Blender 2015 Toaster 2020 Mixer 2025 Television 2030 Freezer 2035 Refrigerator 2040 Radio 2045 Clock Inventory Unit Cost 14.00 12.00 23.00 499,00 799.00 699.00 45.00 79.00 Unit Price 29.95 19.95 33.95 699.95 999.95 849.95 79.95 99.95 QOH 100 200 150 95 52 75 200 150 == Salesperson No Salesperson Name 101 102 103 104 Salesperson Customer No 1000 1001 1002 1003 1004 1005 1006 1007 John Smith Brenda Kim Julia Berens Joe McGuire Name Customer City Smith Jones Jeffries Gilkey Lankford Zeile Pagnozzi Arocha Chicago Phoenix AZ St. Louis MO GA AZ AZ Atlanta Phoenix Phoenix Chicago Cashier No 201 202 203 IL Salt Lake UT IL Cashier 204 State Credit Limit Scott Brown Stony Lee Jim White Pat Thomas 2500 1500 4000 Name 5000 2000 2000 3000 1000 Invoice_No 101 102 103 104 105 106 107 108 Sales Date Salesperson No Customer_No 4/03/2006 4/05/2006 4/05/2006 4/15/2006 4/15/2006 4/16/2006 5/02/2006 5/03/2006 101 103 103 104 102 102 101 103 1000 1003 1002 1000 1005 1007 1002 1000 Amount 1549.90 299.85 1449.80 799.90 849.95 99.95 2209.70 799.90 Rimittance_No Date 220 278 276 289 Cash Collections Amount Invoice No Cashier_No Customer_No 5/02/2006 1549.90 101 5/10/2006 799.90 108 5/30/2006 2209.70 107 5/30/2006 849.95 105 203 202 202 204 1000 1000 1002 1005 Invoice_No 101 101 102 103 103 103 104 104 105 106 107 107 107 107 108 108 Sales Inventory Item No Quantity Extension 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 2 1 1 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 Based on the given tables, draw a complete REA diagram, 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. Item No Description 2010 Blender 2015 Toaster 2020 Mixer 2025 Television 2030 Freezer 2035 Refrigerator 2040 Radio 2045 Clock Inventory Unit Cost 14.00 12.00 23.00 499,00 799.00 699.00 45.00 79.00 Unit Price 29.95 19.95 33.95 699.95 999.95 849.95 79.95 99.95 QOH 100 200 150 95 52 75 200 150 == Salesperson No Salesperson Name 101 102 103 104 Salesperson Customer No 1000 1001 1002 1003 1004 1005 1006 1007 John Smith Brenda Kim Julia Berens Joe McGuire Name Customer City Smith Jones Jeffries Gilkey Lankford Zeile Pagnozzi Arocha Chicago Phoenix AZ St. Louis MO GA AZ AZ Atlanta Phoenix Phoenix Chicago Cashier No 201 202 203 IL Salt Lake UT IL Cashier 204 State Credit Limit Scott Brown Stony Lee Jim White Pat Thomas 2500 1500 4000 Name 5000 2000 2000 3000 1000 Invoice_No 101 102 103 104 105 106 107 108 Sales Date Salesperson No Customer_No 4/03/2006 4/05/2006 4/05/2006 4/15/2006 4/15/2006 4/16/2006 5/02/2006 5/03/2006 101 103 103 104 102 102 101 103 1000 1003 1002 1000 1005 1007 1002 1000 Amount 1549.90 299.85 1449.80 799.90 849.95 99.95 2209.70 799.90 Rimittance_No Date 220 278 276 289 Cash Collections Amount Invoice No Cashier_No Customer_No 5/02/2006 1549.90 101 5/10/2006 799.90 108 5/30/2006 2209.70 107 5/30/2006 849.95 105 203 202 202 204 1000 1000 1002 1005 Invoice_No 101 101 102 103 103 103 104 104 105 106 107 107 107 107 108 108 Sales Inventory Item No Quantity Extension 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 2 1 1 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 Based on the given tables, draw a complete REA diagram, 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. Item No Description 2010 Blender 2015 Toaster 2020 Mixer 2025 Television 2030 Freezer 2035 Refrigerator 2040 Radio 2045 Clock Inventory Unit Cost 14.00 12.00 23.00 499,00 799.00 699.00 45.00 79.00 Unit Price 29.95 19.95 33.95 699.95 999.95 849.95 79.95 99.95 QOH 100 200 150 95 52 75 200 150 == Salesperson No Salesperson Name 101 102 103 104 Salesperson Customer No 1000 1001 1002 1003 1004 1005 1006 1007 John Smith Brenda Kim Julia Berens Joe McGuire Name Customer City Smith Jones Jeffries Gilkey Lankford Zeile Pagnozzi Arocha Chicago Phoenix AZ St. Louis MO GA AZ AZ Atlanta Phoenix Phoenix Chicago Cashier No 201 202 203 IL Salt Lake UT IL Cashier 204 State Credit Limit Scott Brown Stony Lee Jim White Pat Thomas 2500 1500 4000 Name 5000 2000 2000 3000 1000 Invoice_No 101 102 103 104 105 106 107 108 Sales Date Salesperson No Customer_No 4/03/2006 4/05/2006 4/05/2006 4/15/2006 4/15/2006 4/16/2006 5/02/2006 5/03/2006 101 103 103 104 102 102 101 103 1000 1003 1002 1000 1005 1007 1002 1000 Amount 1549.90 299.85 1449.80 799.90 849.95 99.95 2209.70 799.90 Rimittance_No Date 220 278 276 289 Cash Collections Amount Invoice No Cashier_No Customer_No 5/02/2006 1549.90 101 5/10/2006 799.90 108 5/30/2006 2209.70 107 5/30/2006 849.95 105 203 202 202 204 1000 1000 1002 1005 Invoice_No 101 101 102 103 103 103 104 104 105 106 107 107 107 107 108 108 Sales Inventory Item No Quantity Extension 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 2 1 1 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

Answer rating: 100% (QA)

REA Diagram for the Given Tables Entities Economic Agent Customer Salesperson Economic Resource Inve... View the full answer