A hotel is a hive of numerous operations such as front office, booking, and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, and more. The hotel has some rooms and these rooms are of different categories (studio, junior suite, king suite). By room category, each room has different price and in-room amenities. A hotel has some employees to manage the services provided to customers. The customer can book the room either credit card or by cash payment at the hotel. The customer record is stored in the hotel database which contains customer identity, his/her address, check in time, check out time, etc. The hotel provides food and beverages to their customers and generates the bill for this at the time of their check out. Given the scenario, you must complete the following: -

-write out all of the pertinent business rules and relationships needed

-translate business rules into a relational diagram showing the connectivities and cardinalities.

- use one of the ER Model notations to create entity relationship model.

o where appropriate specify the primary and foreign keys for each entity

o show the relationships for entity supertypes and subtypes

- write the SQL used to Create the database, its tables and attributes with constraints (make sure you include primary keys and foreign keys)