Database Review of Document

Authors Avatar

Joe Alt        Saturday, 30 October 2010        904358.doc

Database Review of Document

content

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. If the database was not backed up and the only copy was on a lap top and this was then stolen or lost, the gymnasts would never receive their medals and may have to compete again,  resulting in some very annoyed gymnasts.

To ensure the “integrity of data”, it would be important to ensure no unauthorised person is able to access the database.  The ways of doing this would be

  • Have strong and secure passwords (not 1,2,3,4,5,6 or “Password”)
  • Have someone always at the PC when the gymnastics data base is open
  • Training the judges in data security
  • Having a security screen over your monitor (a bit like LCD screen in the way that it goes grey and shadowy when viewed at an angle)
  • To encrypt data
  • No unnecessary connections to the internet.
  • If connected to the internet, make sure all the proper precautions are in place, e.g. antispyware, firewalls, encrypted connections
  • Make sure the internet connection is wired
  • Make sure only judges who need access to relevant scores are able to get that access. Eg Floor judges only able to access floor event scores and not the vault scores.
Join now!

Other ways to ensure “integrity of data” would be to back up the database and to make sure that the memory stick, laptops and other memory devices and other ways of storing data are not left lying around where just anybody could get their hands on it.  If this was to happen on the day of the competition, Joe Bailey’s brother could get his hands on the database, and change Joe’s scores to allow him to win.  To ensure this doesn’t happen, no unnecessary copies should be made and all copies that are made should be kept securely and ...

This is a preview of the whole essay