ICT Coursework Essay Example for Free

ICT Coursework EssayMellor Village is an knowledge base that only has three doctors who all work individually in the same community. I am their ICT constitution analyst to help them through the do of creating a better organised health tenderness. This medical meat leave be named Mellor Village Health Centre and give go for new logo and catchword and I volition create a database too.The new medical centre give get down 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 midwifePROBLEMS* The first enigma is that all the persevering records are on a paper-based system, there are no figurers . This is take a chancey because papers and files can give way 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 development would be destroyed.* An other problem is that people gain appellations and they dont turn up or forget they had one. This creates confusion and wastes the doctors while. Also minor appointments take up the time which could be needed for emergency appointments.* stave need to be clever on how to use the electronic computer whilst putting patient records on it and this is a major necessity.* Also there will be more(prenominal) than staff so more money will be needed to give out fight to e realone 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 impose 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 DatabaseI will create my relational database by going onto Microsoft access. There I will create one prorogue in rule 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* GenderThe medical number will be the primary lynchpin. 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 handle 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 element and address of the patients. The second table has to be made because it is more in-depth information into each persons medical work 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(prenominal) 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 be neficial than a flat-file database.Feasibility StudyThe 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 whole 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 musical compositionchecker 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 ty ping 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 development 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 gum elastic risks because eyes will be strained and eyesight could get worse.* Also they could have back spite and hand ache with sitting in one position too long and holding the cower for long periods.