Question 1
Consider a company called ABC Consolidated which contains many banks under it.
Each bank contains a code, name and a registration number. The code and name are unique.
The bank has many branches which contain a branch number, branch name and an address.
The branch number is unique for each bank.
Each bank contains many accounts. An account contains an account number, balance, a
customer and an account type.
Each account type contains a name, a code and a description. Account code is unique each
account type.
Account type may be Savings or Current. The Savings account type contains an interestrate.
The Current account type has max-cheques which pertains to maximum cheques that can be
written per month.
Each customer has a customer number, NIC number, name, address, phone and PIN. Both
NIC and customer number are unique.
There are many transactions processed in a bank. Each transaction has a transaction id, date
& time of transaction, amount and responsible party or application for the transaction (i.e.
bank, ATM, teller, cheque, etc.) and description (interest calculation, fund transfer, cheque
number etc.)
Each transaction has one or many accounts that it affects and the type of affect that the
transaction (either a credit/debit) has on the account.
Draw an E-ER diagram for the above-mentioned requirements and answer the following questions.
1. How many entities are there in the ER diagram? What are they?....................................
......................................................................................................................................................
......................................................................................................................................................
-1-
