(Solved) : Refer Critical Thinking Assignment Option 2 Module 2 Tasks Begin Generating Executing Sql Q44033180 . . .
Refer to Critical Thinking Assignment – Option 2 in Module 2.Your tasks begin by generating and executing the SQL statements tocreate the Sales and Purchased Items tables. Next, you will developand execute the SQL statements to populate the 2 database tablesfrom the data in their respective tables in the Critical ThinkingAssignment. Finally, you will write and execute queries todisplay all attributes (columns) and tuples (rows) in the 2database tables.
Important reminder, refer to the instructions from Module 1 forcreating database. This step must be completed before you cancreate 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 thisassignment.
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
Expert Answer
Answer to Refer to Critical Thinking Assignment – Option 2 in Module 2. Your tasks begin by generating and executing the SQL sta…
OR