Product Management Database Using SQL

Project Overview

This project demonstrates the design, creation, and querying of a Products Database using SQL.
It focuses on fundamental Data Definition Language (DDL) and Data Manipulation Language (DML) operations such as creating tables, inserting records, updating data, and retrieving insights using SQL queries.

The project is designed to help beginners understand how to build and manage a relational database for product management scenarios.

---

Table of Contents

1. Project Overview
2. Database Design
3. Sample Data
4. SQL Queries Implemented
5. How to Run
6. Learning Outcomes
7. Recommendations
8. Files in Repository
9. Tools and Technologies
10. Contact
11. Acknowledgement

---

Database Design

Database Name: group2_db
Table Name: products

Table Structure

Column Name	Data Type	Description
product_id	INT	Primary key, unique identifier for each product
product_name	VARCHAR	Name of the product
category	VARCHAR	Product category (e.g., Electronics, Furniture)
price	DECIMAL	Product price
quantity	INT	Quantity available in stock
supplier	VARCHAR	Supplier or vendor name

---

Sample Data

The dataset contains 22 sample product records across categories such as:

• Electronics (e.g., TVs, Phones)
• Furniture (e.g., Chairs, Tables)
• Appliances (e.g., Blenders, Microwaves)
• Stationery (e.g., Pens, Notebooks)
• Home Products (e.g., Lamps, Curtains)

Each record includes product details such as name, category, price, stock quantity, and supplier.

Example entry:

product_id	product_name	category	price	quantity	supplier
1	Office Chair	Furniture	150.00	12	Alpha Furnishings

---

SQL Queries Implemented

1. List all product names ordered by price

   SELECT product_name, price FROM products ORDER BY price ASC;