The company I have chosen to design database software for is called :: Computer Science

The company I have chosen to design database software for is called Multi-installations. They are a private limited company that specializes in the manufacture and installation of high tech security doors and screens. 1.1 Introduction The company I have chosen to design database software for is called Multi-installations. They are a private limited company that specializes in the manufacture and installation of high tech security doors and screens. They do many mail shots per month and send up to four brochures to any company/client within a specified department. The company have often made mistakes as to when they do a mail shot many companies receive the same brochure twice or receive a brochure that they do not require. 1.2 Investigation At the moment there is not a current computer based system in place. Although every time a mail shot is done the company logs this manually in a book and record what brochure was sent to which company. The current problem is that every time a mail shot is done someone must look through the books previous records to see if a particular brochure has been sent to that particular company. This is proving to be a long method as often the person checking the book misses out a company that has already been sent that particular brochure, and this results in the company loosing out as more brochure are used up, and the company receiving the brochure will simply be annoyed with the amount of brochure s receives from Multi-installations and simply throws them away. I asked the company the following questions: 1. What sort of manual system is there in place at the moment? 2. How is the data recorded when a new company needs to be sent a brochure? 3. How is the data stored and can it be accessed easily? 4. Is there a backup copy of your manual system? 5. What problems are you having with the current system? 6. What functions would you like the new database to perform? 7. Will the information in the database need to be protected that only specific people have access to it? 8. Do you think the new computerised system will save time and money? The main problem with the current manual system is that every time a new company is sent a brochure it must be logged in a book. This book contains lists of companies that have already been sent that specific brochure. The current user must look through all the lists to see if that company has been sent that specific brochure. 1.3 Requirements of the New System