1. Create a database named inventory_system.
2. Inside the inventory_system database, create a table named products
with the following structure:
Column
Data Type Description
Name
INT (Primary
ProductID A unique identifier for each product.
Key)
ProductName VARCHAR(100) The name of the product.
The category to which the product
Category VARCHAR(50)
belongs.
QuantityAvail
INT The quantity of the product in stock.
able
Price DECIMAL(10,2) The price of the product.
3. Insert at least 5 products into the table. Include values for
ProductName, Category, QuantityAvailable, and Price. Here is an
example:
Produc QuantityAvai
ProductName Category Price
tID lable
1 Wireless Mouse Electronics 50 19.99
2 Yoga Mat Fitness 30 25.5
3 Coffee Maker Appliances 20 75
4 Running Shoes Footwear 15 60
5 Office Chair Furniture 10 120
4. Use the ALTER command to:
● Add a new column named SupplierEmail with the data type
VARCHAR(100).
● Rename the column Price to UnitPrice.
5. Add email addresses for the suppliers in the SupplierEmail column for
all products.
6. Update the UnitPrice of one product to reflect a price change.
7. List all products sorted by QuantityAvailable in descending order.
8. Save your SQL commands in a .sql file and submit it.
