Supermarket Q1

A supermarket has a SQL database which stores information about products and the stock they hold, and in which location.

The schema for the supermarket’s database is shown below.

Schema

Product(ProductID, Name, PricePence)

Stock(StockID, Location)

ProductStock(ProductID, StockID, Quantity)

Question

A new shipment of 1000 eggs has been delivered to Warehouse A. Each egg is priced at 25p.

Write some INSERT queries to do the following:

• Add an ‘Egg’ into the Product table with the price of 25p, and ProductID 50
• Add an entry to the ProductStock table to match 1000 eggs to Warehouse A

Do not modify the database in any other way.

Hint: Use SELECT queries to get the StockID of Warehouse A