Question: Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described below. Save and upload your Visio file. North Texas
Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described below. Save and upload your Visio file.
- North Texas Service, Inc. (NTS) is a company that provide maintenance services for commercial properties around DFW area. NTS has several offices in and around DFW.
- 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, NTS 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 NTS 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.
[Note] You will develop a database based on your ERD using Microsoft Access in the next assignment.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
