Quelpr
12 marksSystems Analysis and Design

CAPE Computer Science Unit 2 · 2016 · Paper 2 · Question 4(e)

The Science College offers pure and applied science courses, employs 20 lecturers, and enrolls several students. Lecturers teach many courses and many students. Each course is completed by many students.

Draw an entity-relationship (ER) diagram representing the described scenario, defining all relationships and cardinalities in both directions using standard ER conventions.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 4(a)Define cardinality in the context of database design and state one example.[2 marks]
  2. 4(b)List three characteristics of a well-engineered software product.[3 marks]
  3. 4(c)Differentiate between functional and nonfunctional requirements, giving one example of each.[4 marks]
  4. 4(d)Explain two types of tests conducted during the software testing phase, other than white-box and black-box testing.[4 marks]

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