using entity relationship diagramming template in microsoft visio, develop an erd for the business described above.

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 National Bank has a number of branch offices in several states. Attributes of branch offices include Branch ID and Location.Each branch office has one or more employees. Attributes of employee include Employee ID and Employee Name.While an employee can work for only one branch office at a time, the employee can be transferred to different offices.The bank wants to keep track of all branch offices an employee has worked along with the beginning date and the ending date of each assignment.For each branch office, there is always one employee assigned to manage that office.The managing employee may manage only the branch office to which she is assigned.The bank maintains account records including Account ID, Account Type and Balance.Each account is associated with the branch where the account was created.Each branch office may have any number of accounts.Each account belongs to one or more customers. Attributes of customer are Customer ID and Customer Name.While an account can be associated with multiple customers, one customer must be designated as the primary account holder.[Note] You will develop a database based on your ERD using Microsoft Access in the next assignment.

Don't use plagiarized sources. Get Your Custom Essay on
using entity relationship diagramming template in microsoft visio, develop an erd for the business described above.
Just from $13/Page
Order Essay
superadmin

Recent Posts

Consider the following information, and answer the question below. China and England are internation

Consider the following information, and answer the question below. China and England are international trade…

4 years ago

The CPA is involved in many aspects of accounting and business. Let’s discuss some other tasks, othe

The CPA is involved in many aspects of accounting and business. Let's discuss some other…

4 years ago

For your initial post, share your earliest memory of a laser. Compare and contrast your first percep

For your initial post, share your earliest memory of a laser. Compare and contrast your…

4 years ago

2. The Ajax Co. just decided to save $1,500 a month for the next five years as a safety net for rece

2. The Ajax Co. just decided to save $1,500 a month for the next five…

4 years ago

How to make an insertion sort to sort an array of c strings using the following algorithm: * beg, *

How to make an insertion sort to sort an array of c strings using the…

4 years ago

Assume the following Keynesian income-expenditure two-sector model:

Assume the following Keynesian income-expenditure two-sector model:                                                AD = Cp + Ip                                                Cp = Co…

4 years ago