Database Management System Project - Hotel Example

This project presents a comprehensive solution for a Hotel Database Management System. It includes business rules, an Entity-Relationship Diagram (ERD) illustrating the relationships between entities such as bookings, rooms, categories, and customers. The project also features Data Manipulation Language (DML) queries demonstrating how to retrieve and manipulate data within the database. The DML queries include examples for selecting booking information based on specific criteria and ordering food items by price. The solution provides a practical application of database design principles and SQL querying techniques within the context of a hotel management system, making it a valuable resource for students studying database management.

Running head: DATABASE MANAGEMENT SYSTEM
Database Management System
Name of the Student
Name of the University
Author Note

1DATABASE MANAGEMENT SYSTEM
Table of Contents
Business Rules.................................................................................................................................2
ERD.................................................................................................................................................2
DML Queries...................................................................................................................................4
References........................................................................................................................................5

2DATABASE MANAGEMENT SYSTEM
Business Rules
A database management system in any kind of information system brings improvement
into the business for which the system is developed. Business rules can be referred as some
aspects of the database that consists specific elements and relationships (von Rosing 2015). The
Business Rule for the Hotel management system can be stated as follows:
a. A customer can be associated with zero or more bookings into the system. However, each
booking belongs to only one customer.
b. Each booking can have one or more booked rooms. One room belongs to only one
booking number.
c. Each room is associated with one category and each category is having multiple rooms.
Categories are having different amenities according the price and room type.
d. Customer can avail zero or multiple food items provided by the hotel and associated with
one booking.
e. One employee is associated with one department and one department can have one or
more employees.
f. Each employee is associated with one or more services in different booked rooms.
g. Each booking generates the payment after checkout. Each payment can only associate
with one and only one booking.
ERD
Entity-Relationship Diagram (ERD) is a process of modelling real-life object as entities
and shows a relationship between them (Thalheim 2013). It also represents types of relationships
and attribute stored which is required for the system development.

3DATABASE MANAGEMENT SYSTEM
Figure 1: ERD of Hotel Database
Source: created by author

4DATABASE MANAGEMENT SYSTEM
DML Queries
1. SELECT b.bnumber, b.type, b.ChekcinTime, b.ChectOutTime FROM booking b, rooms
r, category c WHERE MONTH(b.ChekcinTime) = 10 and YEAR(b.ChekcinTime) =
2018 and c.Type='Junior Suite' and b.Bnumber=r.Bnumber and
r.CategoryID=c.CategoryID;
2. SELECT * FROM fooditems order by price;

5DATABASE MANAGEMENT SYSTEM
References
Thalheim, B., 2013. Entity-relationship modeling: foundations of database technology. Springer
Science & Business Media.
von Rosing, M., White, S., Cummins, F. and de Man, H., 2015. Business Process Model and
Notation-BPMN.