Some British universities offer four-year sandwich degrees in particular subjects. A sandwich degree is so-called because it sandwiches one year of industrial experience between three years of teaching. The industrial placement officer of your university department wishes to set up a database to store details of students on their industrial placement year and students currently undergoing interviews with companies and organisations for placement. The officer currently records the following details about students currently on placement: student’s name, gender, address and date of birth as well as details of the student’s current employer.
Each student is also given a supervisor for the year. Each supervisor is required to make three trips to an employer during the placement year to visit a student. Details held about each supervisor are: name, room number email address and telephone extension. Details of students currently undergoing interviews for placement are quite complex. Currently, curriculum vitae have to be prepared by each student. A list of possible placements is produced by the placement officer. Students have to select three possible placements for which they are prepared to be interviewed. Details of each interview needs to be held on the database, particularly the result as to whether the student is offered a place with the company or organisation. Students are obliged to accept the first offer of a place they receive.