SQL_Task_2

: Data Insertion and Handling Nulls

Task 2: Data Insertion and Handling Nulls

📌 Objective

Practice inserting, updating, and deleting data in a relational database while handling NULL values and ensuring data consistency.

---

🛠️ Tools Used

• MySQL (Compatible with DB Fiddle / SQLiteStudio)
• SQL (Structured Query Language)

---

🧱 Database Schema

This task includes the creation and population of four core tables:

1. customers – Stores customer information
2. products – Stores product details
3. orders – Stores order information
4. order_items – Stores individual items in each order

---

📥 Operations Performed

✅ Insertions

• Added sample customers, products, orders, and order items
• Handled missing values using NULL where applicable
• Used INSERT INTO ... SELECT to duplicate a product entry

🔁 Updates

• Updated product stock after order placement

❌ Deletion

• Deleted a customer (Amit Singh) from the database

---

💡 Learning Highlights

• Use of INSERT, UPDATE, DELETE statements
• Handling NULL values in fields like phone, address, and description
• Understanding of foreign key constraints between tables
• Safe and structured data manipulation with WHERE conditions

---

📄 File Info

• ecommerce_task2.sql – contains all table creation, insertion, update, and delete queries

---

✅ Outcome

A populated and relationally consistent database ready for further queries, reporting, or analysis.

---

📚 Author

Parag Kotkar