Quelpr
12 marksSystems Analysis and Design

CAPE Computer Science Unit 2 · 2014 · Paper 2 · Question 3(d)

A popular diet drink is sold in many stores. Each store has one or more branches. A branch is supervised by a manager who hires employees to run day-to-day business activities. Employees can be transferred to any branch. The following information is stored on a drink: Barcode Num (primary key), size, and flavour.

Draw an entity-relationship (ER) diagram representing the described scenario.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 3(a)Explain what is meant by a 'deliverable' in the systems development life cycle.[3 marks]
  2. 3(b)Describe TWO factors that can cause an information system to be replaced, explaining why each necessitates developing a new system.[4 marks]
  3. 3(c)Describe THREE main factors that must be evaluated during a feasibility study in the systems development life cycle.[6 marks]

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