Uncategorized

Check The QUEEN ANNE CURIOSITY SHOP from page 263 in the textbook. Work on MySQL to complete the following. Create a new database named QueenAnneCuriosityShop and attach the screenshot in your report. (1 mark) Write CREATE TABLE statements for each of the six tables as well as foreign key constraints, namely steps A and B on page 263. You also want to justify your assumptions in your report. Save the statements as QueenAnneCuriosityShop-Create-Tables.sql. (5 marks)

succurely June 23, 2022

Required Reads

USE MySQL Workbench and answers the following questions. I have a favor to ask of you Please listen to this As I said before, please make sure to use MySQL Workbench, pay attention to making 5 tables, and pay attention to making SALE_ITEM tables.

Check The QUEEN ANNE CURIOSITY SHOP from page 263 in the textbook. Work on MySQL to complete the following.

Create a new database named QueenAnneCuriosityShop and attach the screenshot in your report. (1 mark)
Write CREATE TABLE statements for each of the six tables as well as foreign key constraints, namely steps A and B on page 263. You also want to justify your assumptions in your report. Save the statements as QueenAnneCuriosityShop-Create-Tables.sql. (5 marks)
Write SQL statements to insert the data into each table based on the figures. Save the statements as QueenAnneCuriosityShop-Insert-Data.sql. (5 marks)
Write the SQL query to display ItemID and ItemDescription for all the items that cost $1000 or more and were purchased from a vendor whose CompanyName starts with the letter New. Attach the screenshot of the result in your report. (2 marks)
Write the SQL query to display LastName, FirstName, and Phone of the customers who made the purchase with SaleID 1. Use a subquery. Attach the screenshot of the result in your report. (2 marks)
Write the SQL query to display LastName, FirstName, and Phone of the customers who made the purchase with SaleID 1, 2, and 3. Use a subquery. Attach the screenshot of the result in your report. (2 marks)