ABC Company is a special online retail company that sells certain products to its customers. Products belong to three categories (technology, office supply and furniture). A customer can order multiple products from these categories. When a customer places an order, a company sales representative will be assigned to process the order. Customer name, date of order, product(s) and the price(s) must be recorded. The following are the data for a two-month period that need to be stored in the database: Customers: Last Name Smith Boden Price Burton Wang Products: Product Name 3D Printer X-Chair Design Box SonfiTalk Contour Desk ArtBox Contour chair Recorded Orders: Last Name Smith Price Wang Wang Burton Employees: Last Name Cuban Gonzalez Gonzalez LU Davis First Name Alex Paul Mary Jane Jeff First Name Alex Mary Jeff Jeff Jane First Name Mark Roger Dave April Sandy Address 2 South ST Supply Furniture 21 North St Apt 3, 11th Ave 7 Maple Ave 20 Northern BLVD Category Technology Furniture Supply Technology Furniture Item 3D Printer ArtBox Design Box Contour Chair SonTour Desk SonTour Chair Hire Date 2018-11-20 2015-02-19 2017-06-30 2017-08-20 2019-02-12 Price 765.78 234.59 23.12 235.99 278.89 16.67 189.89 Quantity 1 2 3 1 1 1 City Newark Bergen NY Tampa LA Current Y N Y Y Y State NJ NJ NY FL CA Price 765.78 16.67 19.99 189.89 278.89 189.89 Salary 54555.78 45000.56 65332.77 58784.34 50020.45 Quantity 12 17 200 27 45 123 29 ZIP 07104 07047 10074 33605 90006 Age 27 38 45 37 34 Sale Time 2022-02-22 2022-03-17 2022-03-25 2022-03-21 2022-02-27 Tel 9174251243 9083421987 2128137658 8132341956 2134314356 Received 2020-01-23 2020-01-20 2020-02-12 2020-03-01 2020-03-12 2020-03-18 2020-02-15 Sale Rep Mark Sandy Sandy Mark April Manager April April Dave April
ABC Company is a special online retail company that sells certain products to its customers. Products belong to three categories (technology, office supply and furniture). A customer can order multiple products from these categories. When a customer places an order, a company sales representative will be assigned to process the order. Customer name, date of order, product(s) and the price(s) must be recorded. The following are the data for a two-month period that need to be stored in the database: Customers: Last Name Smith Boden Price Burton Wang Products: Product Name 3D Printer X-Chair Design Box SonfiTalk Contour Desk ArtBox Contour chair Recorded Orders: Last Name Smith Price Wang Wang Burton Employees: Last Name Cuban Gonzalez Gonzalez LU Davis First Name Alex Paul Mary Jane Jeff First Name Alex Mary Jeff Jeff Jane First Name Mark Roger Dave April Sandy Address 2 South ST Supply Furniture 21 North St Apt 3, 11th Ave 7 Maple Ave 20 Northern BLVD Category Technology Furniture Supply Technology Furniture Item 3D Printer ArtBox Design Box Contour Chair SonTour Desk SonTour Chair Hire Date 2018-11-20 2015-02-19 2017-06-30 2017-08-20 2019-02-12 Price 765.78 234.59 23.12 235.99 278.89 16.67 189.89 Quantity 1 2 3 1 1 1 City Newark Bergen NY Tampa LA Current Y N Y Y Y State NJ NJ NY FL CA Price 765.78 16.67 19.99 189.89 278.89 189.89 Salary 54555.78 45000.56 65332.77 58784.34 50020.45 Quantity 12 17 200 27 45 123 29 ZIP 07104 07047 10074 33605 90006 Age 27 38 45 37 34 Sale Time 2022-02-22 2022-03-17 2022-03-25 2022-03-21 2022-02-27 Tel 9174251243 9083421987 2128137658 8132341956 2134314356 Received 2020-01-23 2020-01-20 2020-02-12 2020-03-01 2020-03-12 2020-03-18 2020-02-15 Sale Rep Mark Sandy Sandy Mark April Manager April April Dave April
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter12: Database Queries With Sql
Section: Chapter Questions
Problem 3E
Related questions
Question
Write the data into sql
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage