Quelpr
16 marksSystems Analysis and Design

CAPE Computer Science Unit 2 · 2006 · Paper 2 · Question 2(a)(iii)

A bank has many customers who may open one or more accounts. Account details include account number and balance. A customer can open multiple accounts, and an account can be owned by more than one customer. Withdrawals and deposits can be performed on each account, recording the transaction amount and date.

Draw an entity-relationship model based on the bank narrative provided.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 2(a)(i)Describe THREE main components of an entity-relationship model.[6 marks]
  2. 2(a)(ii)State TWO sources from which a systems analyst can gather information to create an entity-relationship model.[2 marks]
  3. 2(b)(i)Explain what is meant by a data dictionary.[3 marks]
  4. 2(b)(ii)Describe the contents of an entry made in a data dictionary.[3 marks]

More practice: the rest of this paper · more Systems Analysis and Design questions · all CAPE Computer Science Unit 2 past papers