Question

Develop ER Diagram for the below description ( Cover all entities properly please)

Texas Property Management, Inc. (TPM) is a company that provides property maintenance service with several offices in Texas.

1) Each office has one or more employees:

Required attributes for an office include Office Number and Location

Required attributes for an employee include Employee ID and Name.

An employee works for only one office at a time.

The company wants to maintain employment records of all employees working for different offices with the beginning date and the ending date for each assignment

Each office has a manager responsible for all office business.

2) A property that the company provide maintenance service is listed with one office:

Required attributes for a property include Property ID and Address

An office may have any number (including 0) of properties it serves.

3) Each property has one or more owners

Required attributes for an owner of the property include Owner ID and Name

Answer 1

To create an ER Diagram for Texas Property Management, Inc., we outline entities such as Office, Employee, Property, and Owner with their attributes. Relationships include employees being employed at offices, offices maintaining properties, properties being owned by owners, and an office having a managing employee.

Step-by-step explanation:

To develop an ER Diagram for Texas Property Management, Inc. (TPM), we need to identify all the relevant entities and their relationships based on the given description. The entities identified are Office, Employee, Property, and Owner.

Entities and Attributes:

• Office: Attributes include Office Number (primary key) and Location.
• Employee: Attributes include Employee ID (primary key) and Name. Each employee is linked to one office with a relationship indicating the employment duration, which includes attributes such as beginning date and ending date.
• Property: Attributes include Property ID (primary key) and Address. Properties are maintained by an office, implying a relationship between Office and Property.
• Owner: Attributes include Owner ID (primary key) and Name. Each property has a relationship with one or more owners.

Relationships:

• An Employee works for an Office and is managed by a Manager (also an Employee), who is responsible for the office.
• An Office maintains zero or more Properties, and each Property is linked to an Office.
• Each Property is owned by one or more Owners, thus establishing a relationship between Property and Owner.

In summary, we have a many-to-one relationship between Employee and Office to indicate employment, a one-to-many relationship from Office to Property for maintenance, and a many-to-many relationship between Property and Owner since a property can have multiple owners and an owner can own multiple properties. We also have a one-to-one relationship between an Office and a Manager (Employee) to reflect the management structure.