Data that reflects reality and it implies that the data is correct and fit for purpose
2 of 15
What is validation and why is it needed?
It is the process of checking data when it is input and it checks that data conforms to certain rules
3 of 15
What is verification and why is it needed?
It is checking that the data entered is correct and it flags up inconsistencies
4 of 15
What is a DBMS?
It is a Database Management System. This is software that looks after a database at a fundamental level; connecting applications to underlying data
5 of 15
What do DBMS' allow database administrators to do?
Create database applications, protect data, run queries to extract data, keep data consistent, keep data accurate
6 of 15
Why is important to separate the applications from the data in a database?
So that programmers do not have to worry that their applications might damage data structures, new applications can be written without restructuring data, data can be shared easily between applications and data remains consistent
7 of 15
What is the relationship between a table and an entity?
Each table in a relational database contains data about an entity
8 of 15
What are tables?
These are structures where data is stored and the DBMS provides tools for creating and modifying tables
9 of 15
What does each table have?
A primary key which uniquely identifies a record
10 of 15
How are relational databases linked together?
The primary key of one table can be linked to the foreign key of another table
11 of 15
What does the linking of databases do?
It allows data to only be stored once so it avoids data redundancy
12 of 15
What are forms?
They provide a friendly user interface so data can be input into tables or drop-down lists
13 of 15
What are reports?
Outputs from a database
14 of 15
How are quieres used?
To extract a subset of data in a database
15 of 15
Other cards in this set
Card 2
Front
What is data integrity?
Back
Data that reflects reality and it implies that the data is correct and fit for purpose
Comments
No comments have yet been made