Q3

This question is based on Sections 2, 3 and 4 of Block 2. It assesses your ability to understand and represent constraints. The relational representation in Figure 2 does not include all of the constraints required to model this part of the engineering company. Show how the following constraints can be represented in the model: (a) The estimated finish date for a project has to be later than the start date. (2 marks) (b) A member of staff can only be a manager if of grade 3, 4 or 5. (4 marks) (c) Each member of staff must be either a member of a project team or a manager of a team. (6 marks) (d) No members of staff can be both a manager of any project team and a member of any project team. (2 marks)