Case Study: Rental Professionals Introduction: You have been asked to develop a database for a rental company called RentalProfessionals. In e-portfolio assignment 1, you will investigate the design...

Case Study: Rental Professionals
Introduction:
You have been asked to develop a database for a rental company called RentalProfessionals.
In e-portfolio assignment 1, you will investigate the design details required and develop an information/logical model for the case study. What you need to submit in this assignment is specified in item B above.
Using the feedback, you will receive for assignment 1, you may modify your design. In e-portfolio assignment 2, you will create a physical design using DBMS software, either using Access or LibreOffice dbase. The details of assignment 2 will be provided later.
Case study description:
The company, RentalProfessionals, arranges rentals of properties owned by both private and business owners. Every property owner is assigned a unique owner number for identification. The owner’s address (consisting of a street, street number and city), the owner’s name (consisting of first and last name), the owner’s email address and the owner phone number are recorded. The owner can have more than one property.
Each property is identified by a unique property number. The address and type of the property are recorded.
The company is organized into branches and every staff member is allocated to exactly one branch. Each branch has one manager who is a member of the staff. In the database, the staff member is identified by a unique staff number. For each staff member, the address, name, email address, phone numbers, sex, position, and salary are recorded. Each property is in care of one of the branches. Each property is overseen by a unique staff member. Each branch has an address, phone number, and a unique branch number.