table in SQL

السلام عليكم



عندى entity type وابي اسوي جداول لهم وابي الكود لهمل هذه الجداول في sql
Entity type:


Hotel: hotel name.

Reservation: Reservation date, arrival date expected, arrival time expected, departure date expected, departure time expected, reservation status.
Personal information (Title, First name, last name, address city, zip/postal code, country, telephone, state/province, E-mail).
Credit card information (credit card, card number, Expires).
Star wood preferred guest information (spg number, star choice number).
Optional information (Flight arrival information, Arrival time, Airline, flight number).

Guest: first name, last name, address, city, state/province, zip/postal code, country, telephone, E-mail.

Final Invoice: Invoice Number, Invoice date, Total amount, pay method.

Purpose Of Visit: Purpose of Visit description.

Allocate Room: Room number, Floor number, Daily rent amount, Room status.

Room category: bed type (Queen, single bed) smoking, non-smoking, classic room, deluxe room.

Hotel Department: Department Description.

Department Bill: Bill Number, Bill Date, Bill Amount, Bill Remark.

Check In: Check In Number, Check In Date, arrival time, arrival date, Departure date, departure time, Check In status.

New Bill: Bill Number, Bill date, Room allocate Room, Room Category.









باى