Yr 13 - Hw review no 1

The accuracy, reliability and consistency of data

• Data integrity

• Data security

• Data archiving

• Data entry

Hardware/software that protects a network from hostile intrusion that could compromise confidentiality or result in data corruption.

• Blocking app

• firewall

• anti-virus software

• password

The set of data policies that apply to how data is gathered, stored, processed, and disposed of in a company

• Data integrity

• Data governance

• Data archiving

• Data management

Ways of helping maintain data integrity

• Implementing a data dictionary

• having data governance

• increasing the data security

• Using big data

• Database normalisation

What is a data dictionary?

• a type of relational database

• a document describing a database

• a set of rules defining the use of data in a company

• a diagram describing a database

Advantages of using a relational database compared to flat-file database

• Save on storage space

• More secure

• Simpler to implement

• Cheaper

Each row in a table is called...

• Entity

• Data line

• Field

• Record

Issues linked with flat file databases

• Anomalies could occur

• There is data duplication

• More complex to implement

• Takes up more storage space

• Data integrity could be compromised

An example of insertion anomaly:

• when deleting details about a tutor, we would have to delete students info at the same time

• when updating a tutor room we would have to update the data on several records

• when deleting a table all the data about students would be deleted

• Impossible to add the details of a new tutor without details of a student

What is the primary key?

• the link between two tables in a database

• a primary key in another table

• a field in a table which uniquely identifies each record

• a record unique record in the table