Introduction to information systems T. Cornford, M. Shaikh is1 060 2013

marks to any student who submits a database project that is 
just based on the customer-order model.
Example 1
A database for the Human Resources department of a company to hold 
information on employees and the department they work for. Data to be held 
include the employee’s:
• family and first names
• age
• sex
• address of residence
• date of joining the company
• department (administration, distribution, manufacturing)
• job title (assistant, technician, specialist, consultant, manager) 
• head of their department (another employee)
• line manager to whom they report
• qualifications held
• training courses attended.
The system should have an input screen to allow new employees to be added 
to the database and a screen to allow employees who leave to be deleted. 
Similarly it should be possible to add or delete departments (this is an 
organisation that likes to reorganise itself) and to record when an employee 
moves from one department to another or from one job title to another (for 
example, a move or a promotion).
The system should produce the following reports on screen and on paper:
• A report that lists all female employees with an MSc. 
• A report that shows, for each department, the employees sorted by family 
name.
• A report that shows all employees who joined the company before a given 
date in date order.
• A query to show an employee’s line manager.

---

Chapter 2: Preparing for the project work
25
Example 2
A database is to hold information on students, the courses they take and the 
teachers who teach them. Data to be held will include a student’s: 
• name 
• sex
• age
• address
• courses taken. 
Each course has a name and meets up to three times during the week (for 
example, Tuesday 10–11, Wednesday 4–6). A course can have one or more 
teachers. The details of the teachers to be stored are:
• name
• telephone number
• qualification. 
The system will allow a teacher to record homework marks for students.
The system should have input screens to allow new students to be added to the 
database and a screen to allow students who leave to be deleted. Similarly, it 
should be possible to add or delete courses and teachers as well as to record a 
change in who is teaching or taking which courses.
The system must produce, on screen and on paper, a report that shows:
• a query of all the people who teach a certain student
• a report of all students who have done 60 per cent or less of their 
homework assignments
• a report, by course, of the students enrolled sorted by
family name (for example, a register)
• a query as to all teachers who are teaching more than two courses
• a list of all students who should be in class at a given time (say, Friday 
between 9.00 am and 2.00 pm).