Project 1: School Student Database

• Create a database for student records including name, class, marks, and attendance.

Project 2: Library Management System (Mini Version)

• Design tables for books, authors, and issued books.
• Use SQL queries to find overdue books and students who issued them.

Project 3: Online Shopping Inventory

• Create tables for products, categories, and sales.
• Retrieve product information and apply filters based on user input.

Project 4: Mini Banking Database

• Simulate customer accounts and transactions.
• Use queries to display balance history, last 5 transactions, etc.

Week 1–2:

• Week 1:
  • Define 10 real-world examples of database use
  • Write SQL queries to create a basic student table
• Week 2:
  • Insert, update, and delete records from a sample table
  • Create a table for a school event registration

Week 3–4:

• Week 3:
  • Write queries using WHERE, ORDER BY, and LIKE
  • Create and query a mini product table for a store
• Week 4:
  • Perform JOINS on two related tables (students and marks)
  • Group data using GROUP BY and show class-wise average marks

Week 5–6: