Pay
ER diagram for Hotel Management System

ER diagram for Hotel Management System

User

User_address

#user_ID

User_name

User_Mobile

User_email

Has

Login

#login_ID

User_password

login_username

login_role_ID

Roles

#role_ID

role_name

role_desc

Permission

#per_ID

per_role_ID

per_module

per_name

Manage

Customer

Cus_pass

#Cus_ID

Cus_name

Cus_Mobile

Cus_email

Cus_add

Hotel

hotl_type

hotl_desc

hotl_name

hotl_rent

#hotl_ID

Has

Booking

#book_ID

Book_type

Book_desc

Payments

pay_cus_ID

#pay_ID

pay_date

pay_amt

pay_desc

ER diagram for Hotel Management System

59
1
4
publish time: 2020-10-12
Charlotte

This ER diagram represents the model of Hotel Management system Entity. It shows the entire visual instrument of database tables and relationship between rooms, payments, hotel, customers etc., It used structure data and to define the relationship between structured data groups of hotel management system functionalities. The main entities of the hotel management system are hotel, rooms, services, payments, booking and customers

See More Related Templates