HITEK Computer Services - Introduction

Overview

The Technical Services Manager of HITEK Computer Services is Pat Miller.  She is expecting the company to grow considerably over the next few years.  Until now records of customers' PCs have been kept on record cards (there is an example below).  She now thinks that it is time to computerise the system and would like you to manage this project for her.

Example of current record-card.

Project Brief

Pat wants the new database system to accomplish the following tasks

• print out up-to-date lists of customer names & addresses with company names in alphabetical order
• make it easy to find computers which do not have a service contract and contact their owners 
• find out which customers only have return to base or next business day (NBD) warranties and persuade them to upgrade
• in preparation for a company meeting produce graphs to quickly show the percentage of customers who have different types of service contracts
• find out which engineers built which computers
• contact customers who do not have addresses in Warrington to offer them telephone support while waiting for an engineer to arrive
• contact customers who have not got much memory installed in their computers to offer them a cut-price upgrade
• contact customers with a service contract whose PC is between 6 and 12 months old to offer them an inspection

NB  Before you go any further you should have completed relational design exercise 4 and had your answers checked by your teacher!