Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started