• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Database Review of Document

Extracts from this document...

Introduction

Database Review of Document CONTENT * Task 1 (P3) Designing 4 Queries * Task 2 (M1) A brief report on Data Integrity * Task 3 (P1) Pros and Cons of Computerisation of Databases Task 4 (D1) Task 4 The Closing Report Other possible improvements Designing 4 Queries Task 1 Query 1 Query 2 Query 3 Query 4 A brief report on Data Integrity Task 2 Integrity: "the quality of being honest and morally upright. 2 the state of being whole or unified. 3 soundness of construction." ORIGIN Latin integritas, from integer 'intact, whole'. From AskOxford.com Data integrity means that data shown in a database is up to date and correct and accurately shows the information, e.g. referring to the database we have just completed for the Gymnastics Club, John Smith was shown to be perfect in both events and consequently, got gold in both events, when in fact, the perfect score went to another John Smith from Hyde Gymnastics Club and not Manchester Gymnastics Club. This could have been avoided if the data integrity had been kept to a high standard and people had thought about what they are doing and have proof readers to pick up mistakes. This would have avoided the wrong person winning. It is important to prove the validity of any data, especially personal data, so that, for instance, if the personal data of one of the gymnasts was left on a train, all the information could get into the wrong hands and then this could cause havoc. ...read more.

Middle

There most probably are more pros which I haven't seen. In conclusion for the pros, computers are designed to increase productivity, IF you know what you are doing. You can unlock a world of wonders. Cons I believe the cons to be that you can accidentally delete stuff on the computer and lose it also. You can mess things up easily on computers and software for computers is expensive and computers themselves are expensive. Computers are expensive to fix. It is expensive to train whereas people know how to use pen and paper. There is nothing too wrong with paper. You can have Spyware on your computer which will tell people what is on your computer, compromising your security. You can get a virus on the day of your event and your system can go down. You can be an unwitting victim of cyber crime ("zombie machines") resulting in slow computers. You can have judges with them looking at 70% of the internet which they shouldn't be looking at. There are several other distractions on computers which may mean that the judges' attention is drawn away from the competitors. If you have a powercut, all the scores will be lost because they haven't been saved. You need to take into consideration, health and safety, eg., computer screens messing up judges' eyes. There is unnecessary stress when computers go wrong. ...read more.

Conclusion

It is not user friendly. For new users and for the judges, it is very confusing seeing everything down one side, the tables, queries and reports. It is very hard for the judges to find out what they want easily. I would improve this by adding a navigational system, e.g. what you need is a form with buttons on to easily press to open up all the things you want Other possible improvements I think it would be helpful to write a user guide on how to use the gymnastics database and explain it in plain, non-IT jargon. If any jargon is used, it needs to be explained fully, but with the aim of using no jargon. To assist the judges on the usability of the gymnastics database, I would spend my time writing a comprehensive user guide and only covering what they need to know. It would be necessary to have step-by-step instructions with a bit of humour to act as a learning aide. I would choose names for files, queries and reports that the judges will be able to understand with their limited knowledge of IT, e.g., no abbreviations. I would achieve this by thinking carefully about what I would call my files and queries and reports for the judges' benefit so they can take advantage of the full use of the database without having to spend 10 minutes thinking about what file they need to open. ?? ?? ?? ?? Joe Alt Saturday, 30 October 2010 Database Review of Document Page 1 of 5 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. The aim of my project is to make the task of the allocation of ...

    The user can then repeat the above operation to protect the sheet again. Data Validation In my sheet there will be a dropdown menu for the selection of the show, and whether it will be amateur or professional. This will prevent the user from putting in an incorrect statement, and causing an error.

  2. Formal Report for Task3

    Intended Audience The intended audience for the Memos is for internal Staff within the Company, as is the Agenda and Minutes of a meeting. Invoices are intended for people who owe the Company money for goods or services.

  1. Unit 4 Multimedia -Review for Product 1 KS3 Strategy Presentation

    There are a few obvious mistakes that could actually be spotted by teachers and which could lead them to confusion. A few of the major mistakes are that: the contents page is found on slide 12, 2 slides before the end, when it should have been found slide 2 after the title page.

  2. What is a computer registry?

    Back up the registry Before you edit the registry, export the keys in the registry that you plan to edit, or back up the whole registry. If a problem occurs, you can then follow the steps in the "Restore the registry" section to restore the registry to its previous state.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Furthermore, I decided I wanted to add a merit system, which adds up all the merits the child has received depending on whether they have exceeded, met and not met their target, in each specific area, and totals them up on the annual report and says what gift voucher they will receive.

  2. bookings database

    Ideas for improvement would be to add the 'Make a booking' command button so after seeing the details, you can make a booking. Also, there should also be the 'Modify Guest details' command button so after checking whether the details are missing from one form, you can modify this. 3.

  1. AQA GCSE ICT Specification B

    Address3 Table 1 - Yes - - - Address4 Table 1 - Yes - - - Postcode Table 1 - Yes - - - PhoneHome Table 1 - Yes - - - PhoneMobile Table 1 - Yes - -

  2. Graphics Review - Unit 21 OCR

    People who want to navigate through all of Microsoft Window's range of products. People who want to navigate through Comet's 'Kitchen and Homes' product areas in one place. Suitability to Purpose Suitable because the nav. Bar is located in the home-page, hence guiding novices from the start.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work