Summary

Given the requirement of the hotel management system, our team performs the following tasks:

• Created E/R diagrams based on the requirements
• Designed BCNF database schema based on local E/R diagram
• Integrated Oracle JDBC with Java front-end Interface for CRUD and aggregation operation
• Implemented transaction and rollback mechanism to ensure ACID properties

Stage 1

• Analyzed requirement
• Identified user classes main entities
• Defined program APIs
• Created Local E/R diagram and local relational schema

Stage 1 Report

Stage 2

• Created database schema from E/R diagram
• Normalized database into BCNF
• Defined SQL statements for CRUD operations

Stage 2 Report

Stage 3

• Program Implementation with transaction and rollback

Stage 3 Report