Case Study: Umbrella Corporation Rental Management System In view of the growing demand for property rentals, the Umbrella Corporation Company is planning to establish a property rental management system. The management system will be able to maintain data that is used and generated to support the property rentals business for their clients and property owners. Your team is assigned the project to design a database system to support the Umbrella Corporation Rental Management System. Scenario: Umbrella Corporation has a branch office in each state throughout Malaysia. Each branch office is allocated employees. The data describing the branch office includes a unique branch number, address (street, city, and postcode), and telephone numbers (up to a maximum of three). Employees with the role of Supervisor are responsible for an allocated group of employees called Assistants (up to a maximum of 3, at any one time). Not all employees are assigned to a Supervisor. The data stored regarding each employee includes employee id, name, address, position, sala the assigned Supervisor (where applicable), and the details of the branch office at which the employee is currently working. The employee number is unique across all branches of Umbrella Corporation. Each branch office offers a range of properties for rent. The data stored for each property includes property id, address (street, city, and postcode), type, number of rooms, monthly rent, and the details of the property owner. The property number is unique across all branch offices. The management of a property is assigned to an employee whenever it is rented out or requires to be rented out. An employee may manage a maximum of 10 properties for rent at any one time. Currently, the Umbrella Corporation Company is managing 30 properties. The details of property owner are also stored. There are two main types of property owner: private owners and business owners. The data stored for private owners includes owner id, name, address, telephone number, email, and password. The data stored on business owners includes name of business, type of business, address, telephone number, email, password, and contact name. The password will allow owners access to parts of the Umbrella Corporation database using the Web. Currently, there are 12 private owners and 13 business owners that have registered with Umbrella Corporation Company. Umbrella Corporation refers to members of the public interested in renting property as clients. To become a client, a person must first register at a branch office of Umbrella Corporation. The data stored on clients includes client id, name, telephone number, email, preferred type of accommodation, and the maximum rent that the client is preferred to pay. Also recorded is the details of the employee who processed the registration, the date the client joined, and some details on the branch office at which the client registered. The client id is unique across all Umbrella Corporation branches. Currently, there are 20 clients that have registered with Umbrella Corporation Company.