Question
Task 1: Designing an Entity-Relationship Model The House Transact Mate (HTM) Case Study House Transact Mate (HTM) is a real-estate agency that has offices throughout
Task 1: Designing an Entity-Relationship Model The House Transact Mate (HTM) Case Study House Transact Mate (HTM) is a real-estate agency that has offices throughout Melbourne. The following are the requirements for managing data about staff, offices, and properties for HTM. Offices HTM has branch offices throughout Melbourne. Each branch office is allocated several staff members, including a manager who manages the operations of the office. The data describing a branch office includes a unique branch number, address (i.e., street, suburb, and postcode), up to 3 telephone numbers, and the name of the staff member who currently manages the office. Additional data about managers includes the date that the manager started the position at the current branch office and a monthly bonus payment based on performance. Staff Staff members with the role of supervisor are responsible for the day-to-day activities of a team of staff called agents. Each supervisor is responsible for up to a maximum of 10 agents at any one time. Not all staff members are assigned to a supervisor. The data for each staff member includes a unique staff number, name, address, position, salary, name of supervisor (where applicable), and the details of the branch office where a staff member is working. Properties Each branch office offers a range of properties for rent. The data stored for each property includes a unique property number, address (i.e., street, suburb, postcode), type, number of rooms, and weekly rent. The management of a property is assigned to an agent, and an agent manages a maximum of 100 properties at any one time. When a property is available for rent, the property details will be displayed on the HTM website and, when necessary, as advertisement on other websites. Based on the given description, model the business rules of HTM, and present your model as an Entity-Relationship (ER) diagram.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started