ER Diagram and Normalization for Hotel Booking Management System

Assignment 2
1

PART A......................................................................................................................................3
1. Draw the ER diagram.........................................................................................................3
PART B......................................................................................................................................4
1. Map the ER diagram to 3 NF.............................................................................................4
2. Normalisation.....................................................................................................................6
REFERENCES...........................................................................................................................7
2

PART A
1. Draw the ER diagram
An entity relationship diagram is based on the ERD model in which consider as
graphical representation that create a strong relation among people, place, concept and
objects within IT system. In this section, it has been created an entity relationship model for
hotel booking systems. It shows all kind of visual in the form of database tables and creating
a strong relationship between themselves.
Figure: 1 Entity Relationship Diagram
In Figure-1, it has been explained the entity relationship diagram of hotel booking
management system. On the basis of evaluation, it can be divided the entities such as
payment, customer, and hotel, staff, booking, Room and service (Al-Fedaghi, 2021). Every
entities are showing a proper attributes in which develop a strong relationship between two
database tables.
 Entities- An entity refers to the real world object which is distinguishable from one
object to another in the real basis.
 Attributes- it is based on the conceptual termed to represent a characteristics of
entities. In the context of DBMS, it refers to the concept of database component like
DB tables. It can be referred to the field and explain the multiple column of database.
3