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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!