Design and Entity Relation Diagram from the above case using crows foot notation.

Draw an ER diagram that captures the entity sets, relationships and attributes of the Heimlers Property database. The cardinality of each relationship must be presented using crow's foot notation. Show all primary and foreign keys. Name the relationships with verb phrases when applicable. List all your assumptions and the design decisions that are not part of the given data semantics. Heimlers Property Case Description The first branch office of Heimlers Property was opened in 1981 in Brisbane. The Company specializes in the management of furnished properties and has been growing steadily since its inception. It now has several branches within the city. The administrative staff are overwhelmed with the ever-increasing amount of paperwork and the communication and sharing of information between branches is not very effective. The Heimlers Property directors feel that a database could help in part to solve these problems. They have requested your help to develop a database system to support the running of Heimlers Property. A brief description of how the company currently operates follows. Heimlers Property takes an intermediate role between owners who wish to rent out their furnished property and clients of Heimlers Property who require to rent furnished property for a fixed period. Each branch office offers a range of properties for rent. To offer property through Heimlers Property, a property owner normally contacts the branch office nearest to the property for rent. Some property owners are private owners while others are corporate owners. The data stored on private owners includes owner number, name (first and last name), address, telephone number, and email. For corporate owners, one person from the organization which owns the property (i.e. contact person) will manage all business dealings with Heimlers Property. For corporate owners the name of business, business type, address, telephone number, email, and contact name are recorded. The owner provides the details of the property and agrees an appropriate weekly rent for the property with the branch Manager. The data required on a property for rent includes property number, address (street, city, and postcode), type, number of rooms, weekly rent, and the details of the property owner. The property number is unique across all branch offices. Most of the properties rented out by Heimlers Property are apartments. The company also deals with the rental of other types of properties such as houses, studios, units etc. The weekly rent for a property is not held at a constant and is reviewed and updated annually. A record of all updates made to weekly rent of each property is stored for the purpose of tracking an analyzing the price changes in the rental property market. All property owners are assigned a login account which can be used to login to the Heimlers Property website and access some specific features of the website. The owners use their email address together with a password to login to the website. The management of each rental property is assigned to a member of staff whenever it is rented out or ready to be rented out. A member of staff may manage a maximum of 100 properties for rent at any one time. The staff member managing a specific property would change in case of staff promotion and termination of employment. Once a property is registered for rental, Heimlers Property provides services to ensure that the property is rented out for maximum return for both the property owner and, of course, Heimlers Property. These services include interviewing prospective renters (called clients), organizing viewings of the property by clients, advertising the property in online and print media (when necessary) and negotiating the lease agreement. Once a registered property is rented, Heimlers Property assumes responsibility for the property including the collection of rent. When a given property is available for rent, the property details will be displayed on the Heimlers Property Web site and, when necessary, as advertisements in other property listing websites as well as local and national newspapers. Members of the public interested in renting out property must first contact their nearest Heimlers Property branch office to register as clients of Heimlers Property. However, before registration is accepted, a prospective client is normally interviewed to record personal details and preferences of the client in terms of property requirements. When a prospective client registers with Heimlers Property, the data stored includes the client number, name (first and last name), residential address, telephone number, email, and some data on the desired property, including the preferred type of accommodation and the maximum rent that the client is prepared to pay. Also stored is a reference to the member of staff who registered the new client. Once registration is complete, clients are emailed weekly reports that list properties currently available for rent. If a client is interested in viewing any of the properties listed as available for rent, they can get in touch with the branch office. A client may request to view one or more available properties and after viewing will normally provide a comment on the suitability of the property. When analyzing details on property viewings Heimlers Property staff members need to know the client number, name and telephone number, property number and address, date the client viewed the property, and any comments made by the client regarding the suitability of the property. A client may view the same property only once on a given date. It is possible for a client to request a viewing for a specific property many times. If a client makes use of this facility, each subsequent viewing of the property is treated as a follow up of its initial viewing by that client. Once a client has identified a suitable property, a member of staff draws up a lease agreement. The information on the lease agreement form includes lease number, client number and name of the main tenant of the property, property number, address, type and number of rooms, weekly rent, method of payment, deposit amount (calculated as twice the weekly rent), whether the deposit is paid, the start and end dates of the rental period, and the duration of the rental period. The lease number is unique across all Heimlers Property branches. A client may hold a lease associated with a given property from a minimum of three months to a maximum of 1 year. At the end of a rental period a client may request that the rental be continued; however, this requires that a new lease be drawn up. Alternatively, a client may request to view alternative properties for the purposes of renting. Heimlers Property currently has about 2000 staff working in 10 branches across various locations. Each branch has an appropriate number and type of staff including a Manager, Supervisors, and Assistants. The Manager is responsible for the day-to-day running of a branch and each Supervisor is responsible for supervising a group of staff called Assistants (up to a maximum of 10 at any one time). Not all members of staff are assigned to a Supervisor. When a member of staff joins the Company, their data including staff number, name (first and last name), start date, position, salary, gender, date of birth (DOB), and staff number of the Supervisor (where appropriate) will be recorded. The staff number is unique across all branches of Heimlers Property. Additional data is held on staff members who are Managers, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three). Properties that prove difficult to rent out are normally advertised periodically in external advertising mediums such as newspapers. The data required to track each advertisement sent out includes the property number, the date advertised, the unique id of the newspaper/website used, and the cost to advertise. The data stored on each advertising medium Heimlers Property uses includes the name, address (physical or website), telephone number, and the name of the contact person managing the Heimlers Property advertising account for that an advertising medium