Question: Question 3 (20 marks) This question is based on Sections 2, 3 and 4 of Block 2. It assesses your ability to understand and represent

Question 3 (20 marks) 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. (4 marks) (b) A member of staff can only be a manager if of grade 3, 4 or 5. (6 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. (4 marks) Question 3 (20 marks) 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. (4 marks) (b) A member of staff can only be a manager if of grade 3, 4 or 5. (6 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. (4 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
