Database: Feasibility Report
The purpose of the system is to replace and establish a system for my client that can be automated as far as possible, where information can flow easily and saves time and space for the client. This will replace or upgrade any old system the client may be using with a much more fast and efficient system. The Project The reason to behind this project is to build a database for my client that can be easily assessed and configured as far as possible. Where information can be saved and backed up.
To make sure the information will be or be more easily accessible, easy to follow, much easier to use and analyse and most of all a database that can save time efficiently. Background of Clients System The client is a technician, who owns his own company sharing it with another person. There are only two people working within the company, which is him and his partner. The company deals with technical work on computers and networks, involving things such as upgrading and replacing systems.
The current system of my client is a normal appointment book, sketching out the appointment times of its customers. The clients have their own computer, which is used to store records and files about the customers. Both clients have explained they have limited knowledge on databases, and they only know the technical side of computers. The clients have explained that they would like the current database specifications updated or changed. I recommended they would start from scratch, and set up a new database.
Both clients explained what requirements they would like to have, which are below: Client’s requirements Below I have written down the requirements the clients have wished for. To find out what the clients wished and expected in their new database I wrote letters personally to the clients enclosed with questionnaires, which the clients selected the areas they wanted and returned it to me as soon as possible. The main feature of the current system is the information about the customer, their name, address, telephone number etc.
What I will need to do is to set up a database where all the information about each section, is separate from each other making it easier for the client to follow and understand. Major tasks The major tasks that I will undertake is to develop a new database from scratch. I will first collect all the relevant information from the client to put in the database. Then I will have to do the designing phase, where I will decide what goes where and what needs to be added, how am I going to set out the information and details so the client can easily follow it and understand it.
What kind of the security the client will have to use, e. g. password, protection etc. What backup, will I recommend to the client etc. Hardware and Software used by clients I have asked the clients, what current computer they have and are using. They have given me detailed descriptions of the hardware and software they are using. They said they have one personal computer in their office, which they share, and a laptop each. Personal computer The personal computer in the office has windows 200 NT Operating System, 64 MB Ram, 7 GB Hard-drive and a 450 MHz Processor.
The recommended system is Windows 2000 Professional on a computer with a Pentium III processor and 128MB of RAM. Pentium 133 MHz or higher processor required. Memory RAM requirements for Microsoft Access depend upon the operating system used. Plus an additional 8-MB of RAM for each Office application running simultaneously for Windows 98 and Windows 98 Second Edition. 24 MB of RAM for the operating system; for Windows Me, Windows NT Workstation or Server 4.0, 32 MB of RAM for the operating system; for Windows 2000 Professional, 64 MB of RAM for the operating system.
Hard Disk Hard-disk space requirements will vary depending on configuration. 170 MB of available hard-disk space is required for the default configuration of Microsoft Access with 115 MB on the hard disk where the operating system is installed. The client without Windows 2000, Windows Me or Office 2000 SR1 will require an extra 50 MB of hard-disk space for the System Files Update. Custom installation choices may require more or less hard-disk space.