Databases Flashcards

0
Q

Data integrity

A

Means that the data reflects realit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
1
Q

Database

A

Persistent organised store of data on a computer system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is validation

A

Is the process of checking data when it is input.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is verification

A

Is checking that the data entered is correct

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

List standard operations on databases

A

Create
Read
Update
Delete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Data matching

A

Compares different databases to look for relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data mining

A

Is a process that looks in many different unrelated databasrs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Flat file database

A

Rows and columns, row is called a Record and each column a field. Flat file databases are very limited

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Relational database

A

Store data in separate tables, which are linked together so that related data can be easily extracted. Each table contains data about an entity (something in real life about which we store data).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a DBMS

A

Database management system. It:
Connects data and applications
Protects data integrity
Uses record locking to prevent errors in transactions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are transactions

A

When a change takes place in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Tables

A

Structures where data is stored. Each table contains data about only one entity. It has a primary key which is the unique identifier. Each column is a particular data type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Relational databases

A

Databases where tableware linked together

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Different data types:

A
Number
Currency
Text
Date/time
Boolean
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Forms

A

Provide a friendly UI to input data more easily

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Reports

A

These are output from a database. They can summarise, group and select data

16
Q

Queries

A

These are used to extract a subset of data in a database

17
Q

Module

A

A unit of software that takes care of some particular functionality of the database