Scribd
Upload
9 views2 pages

HMS Erd

The document outlines a database schema for a hotel management system, detailing relationships between various entities such as bed types, room types, room pricing, room amenities, reservations, and payments. Each entity includes attributes like IDs, descriptions, pricing details, and guest information. The schema supports functionalities for managing room reservations, pricing, and payment processing.

Uploaded by

isdbdddr65
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views2 pages

HMS Erd

The document outlines a database schema for a hotel management system, detailing relationships between various entities such as bed types, room types, room pricing, room amenities, reservations, and payments. Each entity includes attributes like IDs, descriptions, pricing details, and guest information. The schema supports functionalities for managing room reservations, pricing, and payment processing.

Uploaded by

isdbdddr65
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

bed_type room_type room_pricing

0..1 0..1
bed_type_id integer room_type_id integer room_pricing_id integer
*
bed_type varchar2(50) room_type varchar2(50) room_type_id integer
*
description varchar(100) bed_type_id integer base_price integer

number_of_adults integer season varchar2(50)

number_of_childs integer occupancy_level varchar2(20)


*
room_amenities_id integer day_of_week varchar2(10)

with_ac char(1) min_stay_days NUMBER


room_amenities
image blob discount_rate NUMBER(5,2)
0..1
room_amenities_id integer
surcharge_rate NUMBER(5,2)
room_amenities varchar2(50)
room_details effective_date DATE
description varchar(100)
room_details_id integer expiry_date DATE
*
reservation_id integer
*
room_type_id integer
reservations 0..1 rooms
room_id integer
0..1 1
reservation_id integer room_id integer
no_of_adults integer
check_in_date datetime floor_no integer
no_of_childs integer
check_out_date datetime room_no integer
rate NUMBER(5,2)
no_of_nights integer status varchar2(10)
*
staff_id integer room_type_id integer
payments

guest_id integer dial_number varchar2(16)


paymnet_id integer

status varchar2(10) * description varchar(100)


reservation_id integer

payment_date date

room_tarif NUMBER(5,2)

tax_amount NUMBER(5,2)

total_amount NUMBER(5,2)

advance_amount NUMBER(5,2)

status varchar2(10)
bed_type room_type room_pricing
0..1 0..1
bed_type_id integer room_type_id integer room_pricing_id integer
room_pricing
room_type *
bed_type varchar2(50) room_type varchar2(50) room_type_id integer
*
description varchar(100) bed_type_id integer base_price integer

number_of_adults integer season varchar2(50)

number_of_childs integer occupancy_level varchar2(20)


*
room_amenities_id integer day_of_week varchar2(10)

with_ac room_details
char(1) min_stay_days NUMBER
room_type
room_amenities
image blob discount_rate NUMBER(5,2)
0..1
room_amenities_id integer
surcharge_rate NUMBER(5,2)
room_amenities varchar2(50) rooms
room_details effective_date DATE
description varchar(100)
room_details_id integer expiry_date DATE
*
reservation_id integer
*
room_type_id integer
room_details
reservations 0..1 rooms
room_id integer room_details
0..1 1
reservation_id integer room_id integer
no_of_adults integer
check_in_date datetime floor_no integer
no_of_childs integer
check_out_date datetime room_no integer
rate NUMBER(5,2)
no_of_nights integer paymnets status varchar2(10)
*
staff_id integer room_type_id integer
payments

guest_id integer dial_number varchar2(16)


paymnet_id integer

status varchar2(10) * description varchar(100)


reservation_id integer

payment_date date

room_tarif NUMBER(5,2)

tax_amount NUMBER(5,2)

total_amount NUMBER(5,2)

advance_amount NUMBER(5,2)

status varchar2(10)

You might also like