This exercise is purely a theoretical exercise. You won't have to go near a computer to complete it.

 

However, as an optional extra, you might want to see if you can implement the design you come up with as your answer to exercise 8.

 

Amend the student record system that is shown in figure 8.5 to allow us to store details of the course tutors. Assume the following data is required:-

(i) Tutor's Name

(ii) Tutor's specialist subject

(iii) Tutor's highest Qualification

(iv) University where Qual. gained

(v) Date Qual. gained

You should provide as your answer:-

(i) An amended version of the entity relationship diagram (Figure 139). Assume that team teaching is common, i.e. more than one tutor may teach on a course. One tutor may teach on many courses. Your design should resolve any many to many relations that may crop up.

 

(ii) Show how you would relate the tables so that you can obtain a list of all tutors and the courses they teach on. Your answer should be in the form given in figure 141.

 

(iii) Provide a brief wriiten account of how you arrived at your design (guide length 300 - 400 words).