Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Programming Languages 12th International Symposium Dbpl 2009 Lyon France August 2009 Proceedings Lncs 5708

Authors: Philippa Gardner ,Floris Geerts

2009th Edition

3642037925, 978-3642037924

More Books

Students also viewed these Databases questions

Question

=+ d. a professor deciding how much to prepare for class

Answered: 1 week ago