Northern Virginia Community College Microsoft Visio & Access Project Homework Part 1: Using Entity Relationship diagramming template in Microsoft Visio, d

Northern Virginia Community College Microsoft Visio & Access Project Homework Part 1:

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.

[Note] You will develop a database based on your ERD using Microsoft Access in the next assignment.

Part 2:

Design a database using Microsoft Access from the data model (ERD) you created in the previous assignment. Create all necessary tables and relationships among the tables. Populate each table with at least five records. Make up your own records. Print (save as PDF) the Relationship diagram by opening the Relationship window (Tools – Relationships …) and printing the relationship diagram (File – Print Relationships …). Submit your files — one Access file and one PDF file.