Question: 2. (15 points) Construct an ER diagram for a bank. The bank keeps information about clients accounts, and transactions . Each client, who is either

 2. (15 points) Construct an ER diagram for a bank. The

2. (15 points) Construct an ER diagram for a bank. The bank keeps information about clients accounts, and transactions . Each client, who is either a person or a company, has a unique client number, a name, a credit limit, an address, and one or more phone numberso An address consists of a street number a street name, a city and a state. A client may own several accounts in the bank . Each person has an income. Each company has capital and a tax number. A person may work for at most one company, while a company may have many persons to work for it. . Each account has a unique account number, a balance, and a starting date. Each account must be owned by at least one client. An account may be associated with several transactions 1 Each transaction has a unique transaction number, a type, a date, and an amount. Each transaction must be associated with at least one account. For each association between a transaction and an account, the operations (maybe several, e.g-, read and write the balance) by the transaction on the account need to be recorded

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 Databases Questions!