Menu
support@authoritypapers.com
+1(805) 568 7317

question 2 rest of questions posted separately as well for chegg answer credit pleas 5131806

QUESTION 2: Rest of questions posted separately as well (for Chegg answer credit)–please help

y uses several database systems to conduct its c omputer hardware and softwareData Type: A compan business operations. The following example is a subset of one of the database systems. Customer table stores all the data related to customers. Prices in Product table reflect the current prices (unit prices) for products. The Transaction table keeps track of each customers purchase and return history by storing product number, quantity, and the ProductlD: Integer, ProductName: Varchar, Quantity: Integer, Price: Decimal gra nd total he/she paid. This database, Chapter 6 &7- db2, is available on T-Square (under Recourses-Slides). Sample data of Customer table CustomerNum CustomerName Job DateOfBirth ZIP Sample data of Transaction Table Tim Duncan Consultant 1966-08-03 30075 222 Deion Sanders SportsPerson 1980-07-07 30080 Steve Young Consultant 1976-07-28 30032 1965-02-05 30050 1978-01-22 30015 TransactionID ProductID CustomerNum TransactionDate TransactionQuantity GrandTotal 3 900.00 111 2000-12-18 222 2000-12-20 222 2001-01-30 3 2001-02-15 222 2001-03-01 111 2001-03-08 222 2001-03-10 444 2001-03-14 44 2001-04-10 111 2001-05-01 111 2001-05-05 333 2001-05-18 333 2002-01-03 444 2003-10-03 34.00 333 44 David Robinson CEO 555 Kobe Bryant 3 222222222 4 333224444 5 222222222 3 102.0 400.00 Waiter 5 170.00 2 -600.00 1 30000 4 2000.00 1 20000 Data Type CustomerNum: Integer, CustomerName: Varchar, Job: Varchar, DateOfBirth: Date, Zip Varchar 8 444444444 25 333224444 37 333224444 Sample data of Product table 200 00 Quantity Price 300.00 300.00 222222222 32MB Kingston Memory 200.00 34.00 200.00 ProductID ProductName 2 600.00 39 222222222 34.00 1 200.00 4 555555555 600.00 333224444 444444444 555555555 10GB Hard Drive 15 Monitor 19 Monitor 50.00 90.00 100.00 500.00 600.00

y uses several database systems to conduct its c omputer hardware and softwareData Type: A compan business operations. The following example is a subset of one of the database systems. Customer table stores all the data related to customers. Prices in Product table reflect the current prices (unit prices) for products. The Transaction table keeps track of each customer's purchase and return history by storing product number, quantity, and the ProductlD: Integer, ProductName: Varchar, Quantity: Integer, Price: Decimal gra nd total he/she paid. This database, Chapter 6 &7- db2, is available on T-Square (under Recourses-Slides). Sample data of Customer table CustomerNum CustomerName Job DateOfBirth ZIP Sample data of Transaction Table Tim Duncan Consultant 1966-08-03 30075 222 Deion Sanders SportsPerson 1980-07-07 30080 Steve Young Consultant 1976-07-28 30032 1965-02-05 30050 1978-01-22 30015 TransactionID ProductID CustomerNum TransactionDate TransactionQuantity GrandTotal 3 900.00 111 2000-12-18 222 2000-12-20 222 2001-01-30 3 2001-02-15 222 2001-03-01 111 2001-03-08 222 2001-03-10 444 2001-03-14 44 2001-04-10 111 2001-05-01 111 2001-05-05 333 2001-05-18 333 2002-01-03 444 2003-10-03 34.00 333 44 David Robinson CEO 555 Kobe Bryant 3 222222222 4 333224444 5 222222222 3 102.0 400.00 Waiter 5 170.00 2 -600.00 1 30000 4 2000.00 1 20000 Data Type CustomerNum: Integer, CustomerName: Varchar, Job: Varchar, DateOfBirth: Date, Zip Varchar 8 444444444 25 333224444 37 333224444 Sample data of Product table 200 00 Quantity Price 300.00 300.00 222222222 32MB Kingston Memory 200.00 34.00 200.00 ProductID ProductName 2 600.00 39 222222222 34.00 1 200.00 4 555555555 600.00 333224444 444444444 555555555 10GB Hard Drive 15″ Monitor 19″ Monitor 50.00 90.00 100.00 500.00 600.00

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"GET15"

Order Now