ICT Coursework Essay Example for Free

ICT Coursework Essay Mellor Village is an area that only has three doctors who all work individually in the same community. I am their ICT system analyst to help them through the process of creating a better organised health centre. This medical centre will be named Mellor Village Health Centre and will have new logo and slogan and I will create a database too. The new medical centre will have a sufficient amount of staff which will include the following: * 3 doctors * 2 medical centre nurses * 2 district nurses * 1 health centre manager * 1 secretary * 3 receptionists * 1 counsellor * 1 health visitor * 1 midwife PROBLEMS * The first problem is that all the patient records are on a paper-based system, there are no computers . This is risky because papers and files can get misplaced. So loads of files in cabinets takes up a lot of space. Also tea could be spilt on it by accident and important patient information would be destroyed. * Another problem is that people make appointments and they dont turn up or forget they had one. This creates confusion and wastes the doctors time. Also minor appointments take up the time which could be needed for emergency appointments. * Staff need to be trained on how to use the computer whilst putting patient records on it and this is a major necessity. * Also there will be more staff so more money will be needed to give out wages to everyone and there wont be enough money to give out. SOLUTION * The solution to the first problem is that by creating a computer system the records of all the patients will be put on the computer and they wont take up any space because everything will be stored on the computer. Also they will stay safe on the computers, this means there will be as revolutionary paper-less office. * Staff will be the only ones to view patient information so this will reduce the risk of hackers hacking in the files. * Another solution is that creating a logo and a slogan will be very easy because it will be done using the computer. Which will be efficient and there will be a variety of choices for my logo and slogan. Plan For Relational Database I will create my relational database by going onto Microsoft access. There I will create one table in design view to store each patients main records of contact. This will be table 1 and it will have records such as; * Title * Surname, * Forename, * Address, * Medical No, * Telephone, * Medical history * Gender The medical number will be the primary key. Further I will put the patients information in and save this as table 1 and close it down. I will then create a second table in design view which will be called table 2. It will have fields such as: * Surname, * Medical number, * Doctors name, * Date of appointment * Time of appointment * Ailment. The medical number is the primary key because it is the unique key field for each record. I will put each individual persons information in detail in this table. I will then save this as table 2 and close it down. There will be two tables because one will just include identity and address of the patients. The second table has to be made because it is more in-depth information into each persons medical services and problems. I will go on tools -relationships and add table 1 and 2 and close it down. Thirdly Ill go on relationships edit relationships and go on create new and press ok. Furthermore, I will click on enforce referential integrity and Ill click create. This will be saved and closed. Furthermore by clicking on + on each record of table 1 that persons appointment time and table 2 information will come up. This is a relational database in which both tables relate to each other. The importance of a relational database is that all the data doesnt have to be stored in one large table and all the data is linked together by the key fields and the database management system. It is more better and beneficial than a flat-file database. Feasibility Study The computerised solution will reduce paperwork because all patient records will be stored on a computer system. All the data will be on a database. This will reduce the amount of files and filing cabinets. The solution speeds up the process considerably, because it takes less time to store data on a computer, and it doesnt waste the doctors time. So if the staff works for less hours they will be paid less wages, which will mean the centre will have to give out less money. It also creates fewer mistakes because the spellchecker corrects and identifies the errors in grammar with validation and verification. It provides better reports for the managers because they are clearer, neater and more presentable. These potential benefits outweigh the costs involved of introducing the new system. This is because the benefits are: * That time is used efficiently and not wasted. * It is also easier to make a back-up copy after typing something up. * There is ultimate accuracy because the spell checker identifies the mistakes. These are then verified and validated.Fewer mistakes are made and this is how the computerised solution will improve and increase accuracy. * The Data Protection Act will keep the patient details and data safe by password protection. This reduces the risks of hackers gaining access to confidential files. The costs are: * that the computer could be hacked in or files could be lost. * The computers take up a lot of space too. * Viruses could delete all the information. * There are more staff so more wages has to be given out. * The staff have to be trained on how to use the computer if they dont know. This will cost money and time. * There are health and safety risks because eyes will be strained and eyesight could get worse. * Also they could have back ache and hand ache with sitting in one position too long and holding the mouse for long periods.