Quelpr
9 marksSystems Analysis and Design

CAPE Computer Science Unit 2 · 2013 · Paper 2 · Question 3(b)

In a hospital scenario: patients are assigned to a single ward and treated by one doctor; a ward can have one or more doctors; doctors can work in one or more wards; healthcare assistants work on wards and care for patients, with many-to-many relationship between assistants and patients; each patient has an ID (primary key), name, address, and emergency contact; each patient receives one or more treatments.

Draw an entity-relationship model for the described hospital scenario, clearly naming relationships and specifying cardinality.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 3(a)(i)Explain what is meant by the term 'prototyping'.[4 marks]
  2. 3(a)(ii)Explain how prototyping can be used during the development of a software product.[4 marks]
  3. 3(a)(iii)State TWO weaknesses of the prototyping approach (evolutionary development).[2 marks]
  4. 3(c)Describe THREE tests that should be part of the test plan to unit test the binarySearch() function.[6 marks]

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