Suppose now we are developing a bank system with the following requirements: ABC bank has multiple branches, each branch locates on a city and has its unique name. ABC needs to monitor the assets of each branch. Clients are identified by their ID numbers. Their names, phone numbers, family addresses are also stored. To guarantee the safety of each client’s accounts, ABC also requires clients to provide information of one contact, including name, phone, email, and relationship with this client. Bank staffs are also identified by their ID numbers. They can be managers or clerks. Each manager leads all clerks in the department. Each clerk can only work in one department. Every bank account has a clerk to be responsible for and a clerk can take charge of multiple accounts. Each branch stores the name, phone number, home address, department number and the beginning date of working of every staff. For each department, its number, name and ID number of the manager are also stored. Each department belongs to a specific branch, but a branch can have multiple departments. ABC offers saving accounts. Each account can be owned by multiple clients and one client can have multiple accounts. Every account is identified by the account number, also its balance, open date, opening branch name are stored. Given the information above, please identify all entities and relationships of this ABC bank system, and design an ER diagram to describe them.
Suppose now we are developing a bank system with the following requirements:
ABC bank has multiple branches, each branch locates on a city and has its unique name. ABC needs to monitor the assets of each branch. Clients are identified by their ID numbers. Their names, phone numbers, family addresses are also stored. To guarantee the safety of each client’s accounts, ABC also requires clients to provide information of one contact, including name, phone, email, and relationship with this client. Bank staffs are also identified by their ID numbers. They can be managers or clerks. Each manager leads all clerks in the department. Each clerk can only work in one department. Every bank account has a clerk to be responsible for and a clerk can take charge of multiple accounts. Each branch stores the name, phone number, home address, department number and the beginning date of working of every staff. For each department, its number, name and ID number of the manager are also stored. Each department belongs to a specific branch, but a branch can have multiple departments. ABC offers saving accounts. Each account can be owned by multiple clients and one client can have multiple accounts. Every account is identified by the account number, also its balance, open date, opening branch name are stored.
Given the information above, please identify all entities and relationships of this ABC bank
Step by step
Solved in 2 steps with 1 images
