Primary Grading Artifact: The video demonstration is the main basis for evaluation. All submitted materials must be clearly demonstrated in the video.
Your submission must include all of the following artifacts. Missing any required deliverable will result in loss of marks.
Video Demonstration (maximum 15 minutes). The video must demonstrate the correctness and completeness of the project.
ER Diagram (PDF). The ER model must be presented using Chen notation or UML-like notation.
Relational Schema Diagram (PDF or image). The diagram must show tables, columns, primary keys, and foreign keys.
DDL.sql. A complete SQL file that creates the database schema exactly as designed.
DML.sql. A SQL file that populates the database with sample data sufficient to test all required operations.
Source Code. Complete application source code implementing all required functionality.
Project Report (PDF). A structured report documenting design decisions, schema design, normalization, and implementation.
README.md. Setup instructions, execution steps, and a link to the demonstration video.
The video must clearly demonstrate the following:
– The ER model and its role in the system design – The relational schema and its correspondence to the ER model – The database implementation (tables, constraints, views, triggers, indexes) – All eight required operations, including both correct behavior and error handling – Role-based access control – The application interface and execution flow
The video must be clearly narrated, readable, and accessible without authentication.
The report must document the project in a structured manner. It should describe the ER model, relational schema, normalization to 3NF, implementation approach, and a brief discussion of challenges.
The report must include the link to the demonstration video.
Files must be clearly named and logically organized. Typical structure includes folders such as
docs/, sql/, and app/, with a README.md at the project root.
Submit a single ZIP file via Brightspace containing all required files.
File name format: EGEN5208W_FinalProject_[YourName]_[StudentNumber].zip