Question: Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described below. South LA Inc. (SLA) is a company that
Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described below.
South LA Inc. (SLA) is a company that provide maintenance services for commercial properties around LA area. SLA has several offices in and around LA.
- 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.
- However, SLA 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.
- Each property that SLA provides service is registered with one office:
- Required attributes for a property include Property ID and Address
- An office may have any number (including 0) of properties managed by the office.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
