COMP4150
Advanced & Practical Database Systems
Fall 2025
SCHOOL OF COMPUTER SCIENCE
TEAM PROJECT GUIDELINE
This team project is a core practical component of the course. Students will work in teams
of 3–4 to design and implement a full database application, including requirement
specification, design, implementation, and a GUI.
The project mimics real-world database development and will be evaluated at each stage.
Team Formation
• Teams of 3–4 students.
• Aim for diverse skills (coding, design, documentation).
• Each team must select or be assigned a project idea.
Project Workflow & Deliverables
Step 1 – Project Proposal (September 15)
Deliverable: One to two pages proposal including:
• Project Title + Team Members
• Problem Domain & Motivation
• Target Users
• Brief System Description
Evaluation: Clarity of Idea, Feasibility, Team Role Distribution
Step 2 – Requirement Specification (September 24)
Deliverable: Requirement Analysis Document including:
• Functional Requirements (use cases)
• Non-functional Requirements (Performance, Security, Usability)
• Example Usage Scenarios
Evaluation: Completeness, Mapping to Real-world Needs
Step 3 – Conceptual & Logical Design (October 22)
Deliverable: Database Design Document including:
• ER/EER Diagrams
• Relational Schema (with Primary/Foreign Keys)
• Normalization Steps (up to 3NF/BCNF)
Evaluation: Correctness of Design, Consistency with Requirements
Page 1 of 4
Step 4 – Implementation (October 29)
Deliverable: Working Database + Backend Code including:
• Create Schema in MySQL/ PostgreSQL/NoSQL
• Populate with Sample/Test Data
• Implement Key Queries, Stored Procedures, Triggers
Evaluation: Efficiency, Correctness, Meaningful Queries
Step 5 – GUI Development (November 12)
Deliverable: Functional User Interface (desktop or web) including:
• Create, Read, Update, and Delete (CRUD) Operations
• Support for at least 2–3 User Roles (e.g., Admin, Normal User)
• Tools: Python, Java, C#/.NET, or similar
Evaluation: Usability, Completeness, Integration with Database
Step 6 – Final Report & Presentation (November 17 & 24)
Deliverable:
• Report (10–15 pages): Requirements, Design, Implementation, Screenshots
• Demo Presentation (12 minutes per team)
Evaluation: Report quality, presentation clarity, working demo
Example Project Ideas
• University Course Registration System
o Students register/drop courses
o Instructors manage class lists
o Admins manage courses & schedules.
• Online Bookstore / Library System
o Users search, borrow, or purchase books
o Reviews, ratings, and recommendations
o Inventory management for staff
• Hospital Management System
o Patients, doctors, appointments, billing
o Medical records with access control
• Event Ticketing System
o Users browse & book event tickets
o Seat allocation, payment, and cancellations
• Restaurant Ordering System
o Customers order online / via kiosk
Page 2 of 4
o Staff manage menu & orders
o Analytics dashboard for sales
• Fitness Club Membership System
o Users register, book sessions/classes
o Trainers manage schedules
o Payment and attendance tracking
• Ride-Sharing / Carpooling App
o Users book rides
o Drivers accept/reject
o Ratings and trip history
• Inventory & Supply Chain Management System
o Track stock levels, suppliers, and re-orders
o Generate alerts for low inventory
• Hotel Reservation System
o Manage rooms, bookings, cancellations, and customer info
• E-commerce Shopping Cart System
o Products, customers, orders, and payment records
• Real Estate Listing Platform
o Agents post listings, users search by filters, favorites
• Social Media Mini-Platform
o Users post, like, comment; simple friend/follow model
• Blood Donation Management System
o Donors, blood groups, requests, hospital connections
• Sports League Management System
o Teams, matches, stats, leaderboards.
Evaluation Breakdown
• Proposal: 10%
• Requirements: 10%
• Design: 20%
• Implementation (DB + Queries): 20%
• GUI: 20%
• Final Report & Presentation: 20%
Page 3 of 4
Project Grading Rubric
This rubric is structured according to the six project steps. Each step specifies deliverables,
evaluation criteria, and points. The total project grade is 100 points.
Step 1 – Project Proposal (Sept 15) – 10 points
Evaluation Criteria Points
Clarity of Idea 4
Feasibility 3
Team Role Distribution 3
Step 2 – Requirement Specification (Sept 24) – 10 points
Evaluation Criteria Points
Completeness of Functional Requirements 4
Coverage of Non-functional Requirements 4
Example Usage Scenarios 2
Step 3 – Conceptual & Logical Design (Oct 22) – 20 points
Evaluation Criteria Points
ER/EER Diagram Accuracy & Completeness 8
Relational Schema with Keys 6
Normalization up to 3NF/BCNF 6
Step 4 – Implementation (Oct 29) – 20 points
Evaluation Criteria Points
Schema Implementation 5
Data Population & Integrity 5
Queries, Stored Procedures, Triggers 10
Step 5 – GUI Development (Nov 12) – 20 points
Evaluation Criteria Points
CRUD Operations 8
Support for User Roles 5
Integration & Usability 7
Step 6 – Final Report & Presentation (Nov 17 & 24) – 20 points
Evaluation Criteria Points
Report Quality 10
Presentation Clarity 5
Demo Functionality 5
Page 4 of 4