Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described above. Save and upload your Visio file.

• Denton Realtor is a real estate company with several sales offices in and around Denton.
• Each sales office (Attributes office number, location) and has one or more employees:
  • Required attributes for a sales 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 must 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.
• A property is listed with one office:
  • Required attributes for a property include Property ID and Address
  • A sales office may have any number (including 0) of properties listed.
• Each property has one or more owners
  • Required attributes for an owner of the property include Owner ID and Name
  • When a property is owned by more than one owner, percentage of the property owned by each owner must be recorded.