DESIGN TABLE FOR MOTEL
Hi, Masters. I want to ask about design tabel. This is like motel. I have this raw file from paper:
Room Type | Room Number | Price |Capacity
_______________________________________________________
VIP-A | 107, 103 | 185/Room-day | 2
VIP-B | 102, 104 | 175/Room-day | 2
VIP-C | 201, 208 | 105/person-day | 2
Standar-1 | 209 | 65/person-day | 2
So I make tbl_room, tbl_room_type structure like this:
_________________________
tbl_room_type
_________________________
room_type_key *
name
price
price_type (Room/person)
_________________________
_________________________
tbl_room
_________________________
room_number *
room_type_key #
capacity
_________________________
And the transaction paper like this:
No | Room | Customer | Person | booking| date-in | date-out | Paid
_____________________________________________________________________________
1 | VIP-A (101)| Mrs. A and C | 2 | - | 16-01-19| 18-01-19 | Paid
2 | VIP-B (103)| Mrs. D and E | 2 | - | 16-01-19| 19-01-19 | Paid
3 | VIP-B (102)| Mrs. F and G | 2 | - | 16-01-19| 19-01-19 | Paid
What design of the transaction table would fit?
Thank you very much.
Subject
Written By
Posted
DESIGN TABLE FOR MOTEL
February 24, 2019 05:27PM
February 24, 2019 08:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.