Each group should choose a project a do it, no two groups should have the same

projects. Draw an E-R diagram and identify relationships among the entitie

1. Student Information System

 Objective: Build a database to store and manage information about students, including
their personal details, course enrollment, grades, and attendance records.
 Questions:
o How can we structure the database to store student data, courses, and grades?
o What relationships are required between students, courses, and grades?
o How can we generate reports to track student performance over time?
 Tasks:
o Design tables for students, courses, enrollment, and grades.
o Develop functions for adding, updating, and deleting student records.
o Write queries to calculate the GPA of each student and produce a report based on
grades.
o Implement query filters to track attendance and course completion.

2. Library Management System

 Objective: Design a system to track books, borrowers, and library transactions such as
book checkouts and returns.
 Questions:
o How will you design the database to track books, authors, and borrowers?
o What information do you need to store for each transaction?
o How can the system handle overdue books and fines?
 Tasks:
o Create tables for books, borrowers, transactions, and authors.
o Implement features for borrowing and returning books.
o Write queries to check overdue books, generate book availability reports, and
track fines.
o Provide a report showing the most popular books based on borrow frequency.

3. Inventory Management System

 Objective: Build a system to manage products, stock levels, sales, and supplier details.
 Questions:
o How should inventory data be structured, considering stock levels, pricing, and
suppliers?
o What queries can help identify low stock products?
o How can we track and report on sales performance?
  Tasks:
o Create tables for products, suppliers, sales, and stock.
o Implement CRUD operations for adding new products, updating stock levels, and
processing sales.
o Develop queries to show products that are low in stock and generate sales reports.
o Implement stock reorder functionality and generate reports for inventory status.

4. Employee Management System

 Objective: Manage employee details, including personal information, job positions,

departments, and salaries.
 Questions:
o How should the database be structured to store employee records, departments,
and payroll?
o How do we handle salary changes, promotions, and job role changes over time?
o What is the best way to calculate and generate payroll reports for employees?
 Tasks:
o Create tables for employees, departments, payroll, and job_history.
o Implement employee onboarding and role assignment functionalities.
o Write queries to calculate payroll, manage salary updates, and track bonuses and
deductions.
o Generate reports that summarize payroll expenses by department.

5. Online Shopping Cart

 Objective: Create a database to handle online shopping carts, customer data, and order
processing.
 Questions:
o How will we structure the database to store customer details, products, and order
history?
o How can we track the status of an order and payment progress?
o How do we handle cart operations like adding/removing items, and updating
quantities?
 Tasks:
o Design tables for customers, products, orders, order_items, and payments.
o Implement features for customer registration, adding items to the shopping cart,
and placing orders.
o Write queries to display order history, track order statuses, and generate payment
reports.
o Create functions for updating the cart and calculating total prices with tax and
discounts.

6. Hotel Reservation System

  Objective: Design a system to manage hotel room bookings, customer details, and
payment records.
 Questions:
o What information is necessary to track customer bookings and room availability?
o How should the database handle multiple room types and pricing structures?
o How can we generate reports on booked, available, and canceled reservations?
 Tasks:
o Create tables for customers, rooms, bookings, and payments.
o Implement room reservation and cancellation features.
o Write queries to check room availability, calculate bill amounts, and generate
booking history reports.
o Track payment status and generate reports on revenue.

7. Student Grades Database

 Objective: Build a system to track student grades for multiple subjects over several
semesters.
 Questions:
o How can we structure the data to store subjects, grades, and student progress?
o How can we calculate and display a student's GPA over multiple semesters?
o What reports are needed to assess student performance, such as grade
distributions or subject-specific performance?
 Tasks:
o Create tables for students, subjects, grades, and semesters.
o Implement CRUD functionality for entering grades and managing student records.
o Write queries to calculate GPA and produce performance reports.
o Create a dashboard for teachers to track individual and class-wide performance
over time.

8. Social Media System

 Objective: Create a database to manage user profiles, posts, comments, and friendships
within a social media platform.
 Questions:
o How should we model relationships between users, posts, and comments?
o How do we track friendships or followers and user interactions with posts (likes,
comments)?
o What queries can we use to display a user's feed and most popular posts?
 Tasks:
o Design tables for users, posts, comments, friends, and likes.
o Implement features for creating profiles, posting content, liking, and commenting.
o Develop a query to generate a user's feed by displaying recent posts from their
friends or followers.
o Generate reports to show trending posts based on likes and comments.
9. Movie Rental System

 Objective: Build a database to manage movie rentals, customers, and movie availability.
 Questions:
o How should we structure the database to store movie details, customer records,
and rental transactions?
o How can we track overdue rentals and apply fines?
o How can we report on frequently rented movies or customer rental history?
 Tasks:
o Create tables for movies, customers, rentals, and payments.
o Implement rental and return functionalities.
o Write queries to check overdue rentals, calculate fines, and generate rental history
reports.
o Create a report showing the most rented movies and frequently renting customers.

10. Task Management System

 Objective: Design a system to manage tasks and deadlines for team projects.
 Questions:
o How can we structure the database to store tasks, deadlines, and assignees?
o How do we track task statuses (pending, in progress, completed)?
o What reports can help monitor team performance and task completion?
 Tasks:
o Create tables for tasks, employees, projects, and task_assignments.
o Implement features to create, update, and delete tasks, and assign them to team
members.
o Write queries to monitor task completion status and generate reports on project
progress.
o Implement a feature to display overdue tasks and upcoming deadlines.

11. Bank Management System

 Objective: Create a system for managing bank customer accounts, transactions, and
balances.
 Questions:
o How do we structure accounts to store customer information, account balance,
and transaction history?
o How can we handle deposits, withdrawals, and account transfers?
o How can we generate statements for customers and track transactions over time?
 Tasks:
o Design tables for customers, accounts, transactions, and branches.
o Implement deposit, withdrawal, and transfer functionalities.
o Write queries to show transaction history, account balances, and generate monthly
account statements.
o Generate reports on the bank’s overall balance and customer activity.
12. Product Feedback System

 Objective: Create a system for customers to provide feedback on products.

 Questions:
o How do we structure the database to store product feedback, ratings, and customer
reviews?
o How can we track feedback for each product and respond to customer concerns?
o How do we calculate and report on average product ratings?
 Tasks:
o Create tables for products, feedback, and customers.
o Implement features for submitting and viewing feedback and reviews.
o Write queries to calculate the average product rating and generate reports for
customer feedback.
o Track feedback responses from customer service and generate reports on product
satisfaction.

13. Healthcare Management System

 Objective: Build a system to manage patient appointments, doctor schedules, and

medical records.
 Questions:
o How should the database be structured to manage patients, doctors, and
appointments?
o How can we track medical prescriptions, diagnoses, and patient histories?
o What queries will help track patient visits, upcoming appointments, and medical
prescriptions?
 Tasks:
o Create tables for patients, doctors, appointments, and prescriptions.
o Implement appointment scheduling, cancellation, and medical record
management.
o Write queries to track upcoming appointments, medical history, and prescription
details.
o Generate reports on patient visits, doctor availability, and prescriptions.

14. E-Learning Platform Database

 Objective: Design a database to manage students, courses, assignments, and course

progress.
 Questions:
o How will we structure data to manage course enrollment and student progress?
o How do we handle course assignments, grades, and instructor feedback?
o What reports can help monitor student engagement and course completion?
 Tasks:
o Create tables for students, courses, assignments, and grades.
 o Implement course registration, assignment submission, and grade entry
functionalities.
o Write queries to monitor student progress and display reports on assignment
completion.
o Develop a dashboard for instructors to track student performance in courses.

15. Event Management System

 Objective: Design a system to manage events, participants, venues, and schedules.

 Detailed Questions:
o How should we organize data for events, participants, and venues?
o How do we manage participant registrations and event scheduling?
o How do we track attendance and allow event organizers to send invitations?
o What queries will help monitor event participation and generate attendance
reports?
 Tasks:
o Create tables for events, participants, venues, and schedules.
o Implement event registration, attendee tracking, and event scheduling
functionalities.
o Write SQL queries to show participant lists, attendance records, and event
schedules.
o Generate reports for upcoming events, participant count, and venue capacity
usage.

16. Online Banking System

 Objective: Develop a system to manage online bank accounts, transfers, and transactions.
 Detailed Questions:
o How do we store and manage data for accounts, users, transactions, and transfers?
o How can we securely handle login details, account balance updates, and transfer
operations?
o How do we handle failed transactions, refunds, and fraud monitoring?
o What queries will help track account balances, transaction history, and transfer
statuses?
 Tasks:
o Create tables for accounts, users, transactions, and transfers.
o Implement functionality for transferring money, updating account balances, and
logging transactions.
o Write SQL queries to track transaction history, detect failed transactions, and
generate bank statement reports.
o Generate reports on account balances, transaction frequency, and high-value
transfers.
17. Restaurant Reservation System

 Objective: Create a system for restaurant reservations, managing customer details, table
availability, and booking history.
 Detailed Questions:
o How do we structure the database to track restaurant tables, reservations, and
customer details?
o How can we manage different types of reservations, such as online bookings and
walk-ins?
o How do we handle reservation cancellations, no-shows, and time-slot availability?
o What queries will help track booking trends and identify peak reservation times?
 Tasks:
o Create tables for customers, reservations, tables, and
reservation_history.
o Implement features for making reservations, canceling, and checking table
availability.
o Write SQL queries to show available tables, track reservation times, and generate
booking reports.
o Generate reports on reservation patterns and customer no-shows.

18. Customer Support System

 Objective: Design a database to manage customer service tickets, staff assignments, and
response times.
 Detailed Questions:
o How can we structure the database to store customer queries, staff responses, and
ticket status?
o How do we track ticket priority, progress, and time-to-resolution?
o How can we assign tickets to different support staff and monitor their workload?
o What reports can we generate to evaluate support performance and ticket
resolution rates?
 Tasks:
o Create tables for tickets, customers, support_staff, and ticket_status.
o Implement features to submit tickets, assign them to staff, and monitor ticket
status.
o Write SQL queries to track ticket statuses, calculate response times, and generate
performance reports.
o Develop a dashboard for support staff to view their open tickets and progress.

19. Travel Booking System

  Objective: Develop a system to manage flight bookings, customer profiles, and travel
itineraries.
 Detailed Questions:
o How do we structure the database to track flights, customers, bookings, and
payments?
o How can we handle booking modifications, cancellations, and refunds?
o How do we manage customer preferences, loyalty points, and travel history?
o What queries will help track bookings, available flights, and generate payment
histories?
 Tasks:
o Create tables for flights, customers, bookings, payments, and
loyalty_points.
o Implement features for booking flights, modifying reservations, and processing
payments.
o Write SQL queries to show available flights, customer booking history, and
loyalty rewards.
o Generate reports on the number of bookings, payment statuses, and popular
destinations.

20. E-Commerce Order Management System

 Objective: Design a database to manage product orders, customer information, and

shipping details.
 Detailed Questions:
o How do we structure tables to track orders, products, customers, and shipping
statuses?
o How can we track the order lifecycle, including order placement, shipping, and
delivery?
o How do we handle order cancellations, returns, and refunds?
o What queries will help track product stock, order fulfillment, and customer
feedback?
 Tasks:
o Create tables for orders, customers, products, shipping, and returns.
o Implement features for placing orders, tracking shipments, and handling returns.
o Write SQL queries to track order statuses, stock levels, and generate order history
reports.
o Create reports on shipping times, returns, and popular products.

21. Real Estate Management System

 Objective: Build a system to manage property listings, client information, and real estate
transactions.
  Detailed Questions:
o How do we design tables to track properties, clients, agents, and transactions?
o How can we manage property listings, including details about price, location, and
availability?
o How do we handle contract negotiations, offers, and closings?
o What queries can generate reports on property sales, rental income, and agent
commissions?
 Tasks:
o Create tables for properties, clients, agents, transactions, and offers.
o Implement features to list properties, track offers, and record transactions.
o Write SQL queries to show available properties, sales data, and track
commissions for agents.
o Generate reports on monthly property sales, rental income, and agent
performance.

22. Sports League Management System

 Objective: Create a database to manage sports leagues, teams, matches, and player
statistics.
 Detailed Questions:
o How do we structure tables to store teams, matches, players, and league
standings?
o How can we track match results, player statistics, and team rankings?
o How do we manage league schedules, match cancellations, and team
performance?
o What reports will track player performance, team standings, and match results?
 Tasks:
o Create tables for teams, matches, players, player_stats, and
league_standings.
o Implement features for scheduling matches, recording results, and tracking player
statistics.
o Write SQL queries to track team performance, player stats, and generate match
reports.
o Generate reports on team standings, player performance, and match results.

23. Ticketing System for Events

 Objective: Design a system to handle ticket sales, event schedules, and customer
information for various events.
 Detailed Questions:
o How do we track ticket sales, seating arrangements, and customer purchases?
 o How can we handle multiple event categories, prices, and discounts?
o How do we track ticket availability, cancellations, and refunds?
o What queries will generate reports on ticket sales, revenue, and event popularity?
 Tasks:
o Create tables for events, customers, tickets, and payments.
o Implement features for purchasing tickets, issuing refunds, and updating seating
availability.
o Write SQL queries to check ticket availability, track customer purchases, and
calculate revenue.
o Generate reports on ticket sales, revenue, and event demand.

24. Product Warranty System

 Objective: Build a system to manage product warranties, customer claims, and repair
requests.
 Detailed Questions:
o How do we structure the database to track product warranty details, claims, and
repair requests?
o How can we monitor warranty periods, claim statuses, and repair timelines?
o How do we handle warranty extensions, claims denials, and approval processes?
o What queries will help track warranty claims, repair status, and product defects?
 Tasks:
o Create tables for products, warranties, claims, and repairs.
o Implement features for submitting warranty claims, tracking repair requests, and
updating product status.
o Write SQL queries to monitor warranty expiration dates, claim history, and repair
progress.
o Generate reports on warranty claim rates, repair times, and product defect trends.

25. News Article Management System

 Objective: Design a system to store, edit, and publish news articles, along with author
details and article categories.
 Detailed Questions:
o How do we structure the database to store news articles, authors, and categories?
o How can we track article publication dates, editing history, and approval statuses?
o How do we handle comments and feedback on published articles?
o What queries will help identify the most read articles, authors, and categories?
 Tasks:
o Create tables for articles, authors, categories, and comments.
o Implement features for creating, editing, and publishing articles.
 o Write SQL queries to track articles by category, generate article view counts, and
monitor comment sections.
o Generate reports on the most popular articles and author performance.

26. Subscription Management System

 Objective: Build a system to manage user subscriptions for services or products.

 Detailed Questions:
o How do we track user subscriptions, including start dates, end dates, and
subscription types?
o How can we handle subscription renewals, cancellations, and payment histories?
o How do we offer discounts, free trials, and promotional codes for subscriptions?
o What queries will help track active subscriptions, payment failures, and user
retention?
 Tasks:
o Create tables for users, subscriptions, payments, and promotions.
o Implement subscription renewal, cancellation, and discount functionality.
o Write SQL queries to track active subscriptions, payment failures, and renewal
rates.
o Generate reports on user retention, revenue from subscriptions, and subscription
cancellations.

27. Parking Management System

 Objective: Create a system to manage parking lot occupancy, parking space reservations,
and payment records.
 Detailed Questions:
o How do we track parking spaces, vehicle registrations, and payment transactions?
o How can we handle hourly, daily, and monthly parking reservations?
o How do we monitor parking space availability and handle overstay penalties?
o What queries will help us track parking lot usage, income from parking fees, and
reservations?
 Tasks:
o Create tables for parking_spaces, vehicles, reservations, and payments.
o Implement features for reserving parking spaces, tracking parking times, and
processing payments.
o Write SQL queries to monitor parking space occupancy, generate payment
history, and track overstay penalties.
o Generate reports on parking lot usage, income, and reservation trends.
28. Feedback and Survey System

 Objective: Build a system to collect feedback and survey responses from users on
various topics.
 Detailed Questions:
o How do we structure the database to track survey questions, responses, and user
feedback?
o How can we categorize surveys, track response rates, and analyze results?
o How do we handle anonymous responses and prevent duplicates?
o What queries will help evaluate survey results and participant demographics?
 Tasks:
o Create tables for surveys, questions, responses, and participants.
o Implement features for creating surveys, submitting responses, and categorizing
feedback.
o Write SQL queries to track survey response rates, analyze feedback, and generate
summary reports.
o Generate reports on response trends, question popularity, and user satisfaction.

29. Supplier Management System

 Objective: Design a system to manage supplier relationships, orders, and delivery

schedules.
 Detailed Questions:
o How do we track suppliers, products, order history, and delivery schedules?
o How can we manage product inventories, pricing updates, and supplier
performance?
o How do we monitor delayed deliveries, returned products, and order fulfillment
statuses?
o What queries will help track supplier orders, performance metrics, and payment
status?
 Tasks:
o Create tables for suppliers, products, orders, and deliveries.
o Implement features for placing orders with suppliers, tracking delivery statuses,
and managing inventories.
o Write SQL queries to monitor supplier performance, delivery schedules, and
product availability.
o Generate reports on supplier delivery timeliness, product quality, and order
history.

30. Job Portal System

 Objective: Build a system for job seekers and employers to post job listings, apply for
jobs, and track applications.
 Detailed Questions:
o How do we structure the database to store job listings, applicant information, and
application statuses?
o How can we handle multiple job applications for a single job listing?
o How do we track the interview process, job offers, and rejections?
o What queries will help monitor the number of applications per job listing, and
generate reports on hiring trends?
 Tasks:
o Create tables for job_listings, employers, job_seekers, and applications.
o Implement features for job seekers to apply for jobs, employers to review
applications, and interview scheduling.
o Write SQL queries to track application statuses, show job seeker profiles, and
report on application trends.
o Generate reports on job listing popularity, application success rates, and hiring
trends.