The current management issues occur between the front and back houses due to the inconsistent data problem. Different departments in the hotel need to communicate with various departments repeatedly when conveying information, which directly impacts hotel efficiency; moreover, it is also possible for employees to make mistakes when delivering information to a different department. For example, the housekeeping department forgot to report to the maintenance staff to fix the air conditioner, but the hotel's sales department wasnt notified. Thus hotel reputation and revenue will be impacted by the unsatisfied guest.

The online transaction processing system allows users to perform operations like read, write, and delete data quickly. It responds to its user actions immediately as it can process queries very quickly. It is shareable and securable, and recoverable. More importantly, it allows data to be received synchronously by different departments at the same time.

By installing a centralized OLTP database, all hotel departments will work together more effectively. Meanwhile, Problems and issues in the hotel can also be notified to the relevant departments to solve immediately.

Use SQL model

Logical Model and Relational model. Please least all business rules that you have considered for your database design.

Data Dictionary [Listing of Tables, Attributes, Data Type and Size, Mandatory/Optional, PK/FK and Comments for each attribute]