Draw a detailed, conceptual design of the E-R model, showing the entities, relationships, cardinalities and integrity constraints of the information listed below:

You are required to design and implement a Rental Management System for HappyRenters Rental Management Inc, which manages rental properties on behalf of the owners. The system to be designed is to assist the rental manager to keep track of rental properties and lease agreements using a relational database for data and transaction management.

HappyRenters has several branches located throughout California.

Each branch is identified by a branch number, phone and address (street, city and zip).

Each branch has several employees one manager and several supervisors. A manager supervises the supervisors, where a supervisor manages a number of rental properties.

Managers and supervisors, in addition to their employee ids, names and phones, have a job designation (manager, supervisor).

A rental property is identified by a number (unique among all branches), property owner, address, number of rooms, monthly rent. A rental property has a status that can be available, or leased. A rental propertys availability is indicated by start date of availability.

A rental property is listed with one property-owner. An owner may own more than one rental property. A property-owners name, permanent address and phone number should be recorded.

When a property is rented, a lease agreement should be created.

1.2 The following constraints should be enforced

There is only one manager per branch.

A lease agreement should be for a minimum of six months and a maximum of one year.

When a lease agreement is created, the status for the property should be changed to leased.

When a rental property is removed from the list of rentals, it should also be removed from its supervisors list.

With every new lease, a 10% increase in rent should be added to the rent from the previous lease.