Database for Chain of Hotels
Branch(id, street, city, general_manager, main_phone)
Employee(id, first_name, last_name, position, date_of_join, date of release, salary, branch)
Shifts(id, position, slot, floor)
Rooms(branch_id, number, floor, status, booked, serviced, basic_cost)
Stay(transaction_id, customer_id,to,from,extra_cost)
Invoice(bill_id, date, price, transaction_id, customer_id)
Food(item, price, sold)
Customer(id, first, last, email, aadhar_number, passport_number)
Booking(booking_id, date, room_number, branch_id, status, customer_id)
Accounts(date, kitchen, taxes, bills, other)
Contains(bill_id, food_item)
In(transaction_id, room_number, branch)
Allotment(emp_id, shift_id, date)