The system I am designing for MR Cork can be done by using many :: Computer Science

The system I am designing for MR Cork can be done by using many different solutions. The different solutions and both their good and bad points are mentioned below. Possible Solutions Solution for current system After reviewing the way in which the current system operates in the analysis section, I believe that by organising the current diary system and making it more organised would be a major benefit to Mr Cork. A folder of customer details can be implemented into the system and would store such information customer details, including phone numbers, addresses and any other relevant information required by Mr Cork. Information on bookings made by customers can also be stored in these files and the cost of the jobs as well in order for bills and receipts to be produced more efficiently and accurately. Advantages - · The system and the process of customer detail storage is more organised leading to it being more efficient. - · End user will not need to learn any special computer skills or go through any computer training in order to benefit form this solution. - · This solution would add minimal additional costs to the end user as no specific machinery is needed for it to be implemented. Disadvantages  · As documents are being stored in manual files and in the form of paper work and not stored on a computer database or spreadsheet then the end user may have an overload of paper documents especially if Mr. Cork holds many customer's details.  · This approach does not really modernise MR Corks approach to doing things more efficiently.  · Talking in terms of speed and organisation is still not as efficient as a computerised system.  · Computer system would give the company a better image. Solution using Microsoft Access Microsoft access is a form of relational database management system. A database can be defined as a collection of data which can be shared amongst different applications. As a result of this electronic data store relationships between data entities can be formed. When two different entities can be related to one another a link can be made. As a result of this data redundancy is minimalised, which involves repeating data. By using Microsoft access the user is able to produce reports forms and tables as well. Advantages . Developing or modifying the data stored in Microsoft Access can be done much easier than if database was conducted manually. - Reports can be also be added, modified, or new ones created based on already existing data. - The way in which data is added to the database is reasonably easy