Reference no: EM132270161

Data Modeling and Database Design using Visio and Microsoft Access

Carefully study the following scenario and develop a database as instructed

*A 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 for each branch office.

* For each branch office, there is always one employee assigned to manage that office. An 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.

Develop an E-R diagram for the business described above