PLEASE CREATE A DIAGRAM

Creating an entity relationship model

Learning outcomes

Upon successful completion of this workshop, you will have demonstrated the abilities to use ER notation to construct an Entity Relationship model using draw.io.

Instructions

Using the Crows Foot notations, create an ERD that can be implemented for conference presentations using the following business case:

Create an ER diagram for a real estate firm. The firm has multiple offices. The office is identified by a unique business number, address, and description. Each office offers house listings, a house can only be listed in one office but an office can have multiple house listings. The house has an address, area, number of rooms and number of bathrooms. Each office has an agent working for it. a sales agent can work for multiple offices (of the firm) and an office can contain multiple sales agents. An agent can be assigned to sell multiple houses but a house can be sold by only one agent. Agents are identified by employee id and their attributes are name and salary.

Requirements

1. Label the primary key for each entity
2. Add and label the foreign keys based on the relationship type between entities.
3. Label with text the relationship between entities.

Submission

Use draw.io and save your ERD as PNG or PDF, then submit it on BB.