Databases Flashcards Preview

OCR Computing > Databases > Flashcards

Flashcards in Databases Deck (38)
Loading flashcards...
1

A persistent, organised store of data in electronic form

Database

2

Database

A persistent, organised store of data in electronic form

3

Software application that handles the data directly and provides an interface to the database

DBMS

4

DBMS

Software application that handles the data directly and provides an interface to the database

5

Type of database which contains only one table

Flat File

6

Flat File

Type of database which contains only one table

7

Type of database in which two or more tables are linked to each other

Relational

8

Relational

Type of database in which two or more tables are linked to each other

9

A set of data elements organised in fields and records

Table

10

Table

A set of data elements organised in fields and records

11

An object or thing of importance about which data is captured

Entity

12

Entity

An object or thing of importance about which data is captured

13

User interface tool which allows a user to enter or change data in a table

Form

14

Form

User interface tool which allows a user to enter or change data in a table

15

Database management tool used to retrieve information based on specified criteria

Query

16

Query

Database management tool used to retrieve information based on specified criteria

17

Database management tool used to present information to the user

Report

18

Report

Database management tool used to present information to the user

19

A field in a table which uniquely identifies each record in that table

Primary Key

20

Primary Key

A field in a table which uniquely identifies each record in that table

21

A field used in one table to represent the value of a primary key in a related table

Foreign Key

22

Foreign Key

A field used in one table to represent the value of a primary key in a related table

23

Name given to the undesirable effect of having duplicate data in a database

Redundancy

24

Redundancy

Name given to the undesirable effect of having duplicate data in a database

25

The automatic checking of inputted data by a computer system to ensure it is sensible

Validation

26

Validation

The automatic checking of inputted data by a computer system to ensure it is sensible

27

All data about one item in a database

Record

28

Record

All data about one item in a database

29

A property of something stored in a database

Field

30

Field

A property of something stored in a database