Question
Refer to Critical Thinking Assignment Option 2 in Module 2. Your tasks begin by generating and executing the SQL statements to create the Sales and
Refer to Critical Thinking Assignment Option 2 in Module 2. Your tasks begin by generating and executing the SQL statements to create the Sales and Purchased Items tables. Next, you will develop and execute the SQL statements to populate the 2 database tables from the data in their respective tables in the Critical Thinking Assignment. Finally, you will write and execute queries to display all attributes (columns) and tuples (rows) in the 2 database tables.
Important reminder, refer to the instructions from Module 1 for creating database. This step must be completed before you can create and populate tables within the database.
The deliverables for this assignment are:
- Screenprint after the database is created.
- Screenprint after the 2 database tables are created.
- Screenprint of the query results for each table.
- A brief description of your key learnings from this assignment.
Sales Table
| LastName | FirstName | Phone | InvoiceDate | InvoiceItem | Price | Tax | Total |
| Shire | Robert | 206-524-2422 | 12/14/2017 | Antique Desk | 3000.00 | 249.00 | 3249.00 |
| Shire | Robert | 206-524-2422 | 12/14/2017 | Antique Desk Chair | 500.00 | 41.50 | 541.50 |
| Goodyear | Katherine | 206-524-3544 | 12/15/2017 | Dining Table Linens | 1000.00 | 83.00 | 1083.00 |
| Bancroft | Chris | 426-635-9788 | 12/15/2017 | Candles | 50.00 | 4.16 | 54.16 |
| Griffith | John | 206-524-4656 | 12/23/2017 | Candles | 45.00 | 3.74 | 48.74 |
| Shire | Robert | 206-524-2422 | 1/5/2018 | Desk Lamp | 250.00 | 20.75 | 270.75 |
| Tierney | Doris | 425-635-8677 | 1/10/2018 | Dining Table Linens | 750.00 | 62.25 | 812.25 |
| Anderson | Donna | 360-538-3544 | 1/12/2018 | Book Shelf | 250.00 | 20.75 | 270.75 |
| Goodyear | Katherine | 206-524-3544 | 1/15/2018 | Antique Chair | 1250.00 | 103.75 | 1353.75 |
| Goodyear | Katherine | 206-524-3544 | 1/15/2018 | Antique Chair | 1750.00 | 145.25 | 1895.25 |
| Tierney | Doris | 425-635-8677 | 1/25/2018 | Antique Candle Holders | 350.00 | 29.05 | 379.05 |
Purchased Items Table
| PurchaseItem | PurchasePrice | Purchase Date | Vendor | Phone |
| Antique Desk | 1800.00 | 11/7/2017 | European Specialties | 206-325-7868 |
| Antique Desk | 1750.00 | 11/7/2017 | European Specialties | 206-325-7868 |
| Antique Candle Holders | 210.00 | 11/7/2017 | European Specialties | 206-325-7868 |
| Antique Candle Holders | 200.00 | 11/7/2017 | European Specialties | 206-325-7868 |
| Dining Table Linens | 600.00 | 11/14/2017 | Linen and Things | 206-325-6755 |
| Candles | 30.00 | 11/14/2017 | Linen and Things | 206-325-6755 |
| Desk Lamp | 150.00 | 11/14/2017 | Lamps and Lighting | 206-325-8977 |
| Floor Lamp | 300.00 | 11/14/2017 | Lamps and Lighting | 206-325-8977 |
| Dining Table Linens | 450.00 | 11/21/2017 | Linen and Things | 206-325-6755 |
| Candles | 27.00 | 11/21/2017 | Linen and Things | 206-325-6755 |
| Book Shelf | 150.00 | 11/21/2017 | Harrison, Denise | 425-746-4332 |
| Antique Desk | 1000.00 | 11/28/2017 | Lee, Andrew | 425-746-5433 |
| Antique Desk Chair | 300.00 | 11/28/2017 | Lee, Andrew | 425-746-5433 |
| Antique Chair | 750.00 | 11/28/2017 | New York Brokerage | 206-325-9088 |
| Antique Chair | 1050.00 | 11/28/2017 | New York Brokerage | 206-325-9088 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
MySQL Crash Course A Hands On Introduction To Database Development
Authors: Rick Silva
1st Edition
1718503008, 978-1718503007
