Assignment description:

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. Motel

ABC 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 pay slips are also kept on file. Each payslip has a date and salary amount. There is only one payslip for a given employee for agiven date.Customer details such as their name, contact information (phone number, email, homeaddress) are also kept on file.As this is a motel, it provides rooms to customers. Each room is uniquely identifiedthroughout the motel chain and is associated with a branch. For each room, the type of roomand price are stored.A booking occurs when a customer requests a booking for a particular room and theemployee confirms the booking. A customer may book several rooms. The total bookingamount will also be stored.