Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Samsung Galaxy S23 Ultra Comprehensive User Manual

Authors: Leo Scott

1st Edition

B0BVPBJK5Q, 979-8377286455

Students also viewed these Databases questions

Question

Is it easier to adjust goals upward or downward? Explain.

Answered: 1 week ago

Question

7. Identify four antecedents that influence intercultural contact.

Answered: 1 week ago

Question

5. Describe the relationship between history and identity.

Answered: 1 week ago