The Scotland College of Technology is currently offering a two-year diploma programme which will lead
into a set number of credits for a degree programme at most universities in Scotland within the field of
Computer Science. A sandwich diploma is so-called because it sandwiches a 6 month period of industrial
experience in between one and a half year of teaching.
The college co-ordinator for Computing Science requires the setting up a database to store details of
students on their industrial placement period and students currently undergoing interviews with companies
for relevant placement. The details of the students including their academic performance to date are kept on
the system so the co-ordinator can assess whether the student is a right fit for the position.
Each employer will also send a job description concerning the role (e.g. network administrator, system
admin, programmer, etc.) and these details need to be captured by the new system. Along with typical
employer details like location, telephone, company-email, company house business ID, etc.
The co-ordinator 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
will be given a line manager for their industrial period at the company of employment. A small apprentice
level payment will be made to each student, this will be remitted to their nominated account at the end of
every month – typical of any employee in the UK, also deductions like national insurance, and tax – will be
deducted. So this needs to also be able to handle these payroll requirement.
A college tutor is appointed to visit the student and interview him/her along with their line manager at the
company. The transcript along with date and progress details are recorded in the database. Details held
about each line manager are: name, room number email address, telephone extension along with other
relevant contact details is also recorded. Naturally the details of the college assigned tutor are also kept –
these pretty much mirror the details as per the line manager.
Page 3 of 9
Details of students currently undergoing interviews for placement are quite complex. Currently, curriculum
vitae’s have to be prepared by each student and these have to be stored on the system for quick dispatch to
the relevant prospective employer by email, and employer responses will need to be logged – this would
include an invite for an interview, time/date of interview, contact person at interview etc.
At some point a list of possible placements is produced by the co-ordinator, and these are then allocated to
the student. 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 organisation. Students are obliged to accept the first offer of a place they receiveTask 1A. Explain why a relational database would be suitable information system for the organisation
such as the one provided in the case study and provide (3) three reasons to support your
recommendation (300 words).
Task 1B. Explain (3) three distinct advantages concerning what a database management system
provides to any organisation. Note: Make these relevant to the organisation in the case study (300