Database Keywords

Attribute
The characteristics of an entity. (Attributes of a film could be the actors, director, and duration.)
1 of 15
Data
Units of information. In databases, there can be different data types, like integers, strings, and Booleans.
2 of 15
Database
A persistent, organised set of data.
3 of 15
Entity
An object, eg. a person or film. Similar to a record.
4 of 15
Field
One piece of information in a table.
5 of 15
Flat-file Database
A database consisting of a single table.
6 of 15
Integrity
The validity of a database.
7 of 15
Primary Key
A unique identifier for a record in a relational database.
8 of 15
Record
All the data relating to one entity.
9 of 15
Foreign Key
A reference to a primary key in a relational database table.
10 of 15
Query
A search or question performed inside a database.
11 of 15
Relational Database
A database comprising multiple tables joined through key fields.
12 of 15
Table
Contains all the fields and records for one particular collection of entities in a database.
13 of 15
Persistent
A structured store of data such as a database.
14 of 15
DBMS
A database management system that provides an organised tool for managing data.
15 of 15

Other cards in this set

Card 2

Front

Units of information. In databases, there can be different data types, like integers, strings, and Booleans.

Back

Data

Card 3

Front

A persistent, organised set of data.

Back

Preview of the back of card 3

Card 4

Front

An object, eg. a person or film. Similar to a record.

Back

Preview of the back of card 4

Card 5

Front

One piece of information in a table.

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »