Assignment Details Infomation system development
Description
Using Entity Relationship diagramming template in Microsoft Visio, develop an E-R diagram for the business described above. Save and upload your Visio file.
• Trust First National Bank has a number of branch offices in several states. Attributes of branch office include Branch ID and Location. o Each branch office has one or more employees. Attributes of employee include Employee ID, Employee Name and Year Employee (the year in which the employee was first hired). 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. • The bank maintains account records including Account ID, Account Type and Balance. o Each account is associated with the branch where the account was created. Each branch office may have any number of accounts. o Each account belongs to one or more customers. Attributes of customer are Customer ID and Customer Name.
[Note] You will develop a database based on your ERD using Microsoft Access in the next assignment.
Submit Assignment
Dashboard
Calendar To On Notifications Inbox