ERD Question–2008/2009 Exam

“Suppose a bank which has planned to automate its data processing facility,which is currently operated manually. The bank may have several customers who will maintain one or more accounts. In case of joint accounts, a maximum of 2 customers will have shared access to a single account. A customer may have different types of accounts like savings accounts, current accounts or fixed deposits. A customer is identified by the national identity card (NIC) number. Other information about a customer such as name, address and phone number is also held. An account is held information such as account number, account type, balance and interest rate. An account is created by a staff member of the bank who has the privilege to create accounts. Such staff member may create several accounts and several staff members may be involved in creating a single account like in case where authorization is required by the senior staff members. Information about staff members like user ID, name, verification status, remarks is also stored. An account may participate in many transactions like deposits and withdrawals. A transaction ID uniquely identifies a transaction. Information like the date and the time the transaction happened, the amount which was deposited or withdrawn and the type of the transaction (whether it is a deposit or a withdrawal) is also held for each transaction. Every transaction is recorded on a ledger in the end of the day. The bank may have several such ledgers which will be identified by a unique ledger code. the date and the time when the transaction was entered into the ledger will be stored in the ledger.”

The ERD would be like this..

image

Note:

It is said that an account may be accessed only by 2 customers at max. But we cannot illustrate it in the ERD. So just can show it as M:N and have to control it when inserting data.

Account type is not considered as an attribute, because we can simply find the account no in those separate relations and figure it out.

Same case with the Transaction. We don’t have to mention the type of the it from it’s sub class relations.

Assumptions

Only one senior staff member will be participating on creating an account to authenticate.

04 comments on “ERD Question–2008/2009 Exam

  • Ayyoob Hamza , Direct link to comment

    hey bro i dont think v need to use inheritance on the staff coz as in the question it says there r junior,senior staff… but there isnt any unique characteristics to divide them so i think v can just use staff entity

    and also on transaction to identify if it is withdrawal or deposit … i think v can get it 4m the attribute (type) ….. so i think v might not need the inheritance on it …

    • Gnomez Grave , Direct link to comment

      In the case of staff, there is a problem. Cz we are suppose to store the person who authenticate it and it is said that it will be done by a senior staff member.So only can be connected to a senior staff member. That’s why I took inheritance for that.
      In the case of transaction, you seems right. This is another way of mapping. This was drawn after a serious discussion with Madhura. So this should be possible. But dude, your logic is also valid. It is possible.

Leave a Reply