This presentation discusses the Sydney Hotel Management System, a database management system that can manage day-to-day activities, payment, and booking systems. It covers the purposes and needs of the database, DBMS selection, HMS ERD, ELP database schema, and X12 SQL statements. The challenges and solutions of designing a payment system that accepts different payment types for different rooms are also discussed.

Individual Project (Assignment 2)

To design and develop a database of your choice for practical experience in database modelling, normalization, and writing SQL statements.

Learn about the purposes and needs of the database, DBMS selection, HMS ERD, ELP database schema, and X12 SQL statements for Sydney Hotel Management System.

Sydney Hotel Management System: Database Management System

This project is about developing a hotel management system for a local hotel in Sydney. The system should be able to manage day to day activities including payment and booking systems. The database schema includes tables for bookings, guests, payments, reservations, rooms, and more. The ERD and ELP database schema are also provided.

Sydney Hotel Management System: Database Management System

Sydney Hotel Management Systemlg...

Sydney Hotel Management System