For the given problem statement, you are expected to:

1. Create an entity-relationship ( ER) model of the given problem. In this stepto draw the diagram, you need to identify entities, relationships as well asinferring primary keys and foreign keys for entities.). A description of your solutionshould accompany the ER diagram

.2. Create a relational model based on ER model. You need to convert the ERmodel into tables. Show connections between tables.

3. Have a working database environment on your laptop (MySQL as adefault), but you can try other solutions if you want.

4. Create a database based on the relational model using SQL. You need toconvert the designed tables into SQL statements so that you can create thereal tables in your DBMS.)Problem: ABC Inc. MotelABC Inc. is a motel chain that has decided to go digital and is considering using a RDBMS tostore the motel data.

The motel has several branches across the country and each of these branches has aname, location and rating.

Each branch has staff and each staff members details such as name and current salary arekept on record.

Each branch has a manager who is a staff member in charge of the branch.

Each employee only works at one branch and has a unique identifier throughout thecompany.

Also, for each current staff member, their payslips are also kept on file. Each payslip has a date and salary amount.

There is only one payslip for a given employee for a given date.

Customer details such as their name, contact information (phone number, email, home address) are also kept on file.

As this is a motel, it provides rooms to customers. Each room is unique identified throughout the motel chain and is associated with a branch. For each room, the type of room and price are stored. A booking occurs when a customer requests a booking for a particular room and the employee confirms the booking. A customer may book several rooms. The total booking amount will also be stored.