Question: 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

Using Entity Relationship diagramming template in

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. o 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: o 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 o 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. 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. o 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: o 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 o 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

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!