Data - 3.4 Encryption

Question 1

Databases:

Answer 1

an organised store of data.

Question 2

Entity:

Answer 2

something that is recognised as being capable of an independent existence, is uniquely identified and about which data is stored.

Question 3

Attribute:

Answer 3

an item of data stored about an entity.

Question 4

Table:

Answer 4

a collection of cells organised in rows and columns used to store data in databases.

Question 5

File:

Answer 5

all of the records in a table or a group of linked tables.

Question 6

Primary key:

Answer 6

a unique identifier for each record in the table. It is usually a field that is guaranteed to hold unique information for each record.

Question 7

Foreign key:

Answer 7

a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key in the first table.

Question 8

Relational databases:

Answer 8

a database that allows data elements in one table to be related to any piece if data in another table as long as both tables have a common element.

Question 9

Compound key:

Answer 9

a key that consists of 2 or more fields used tpo identify a record uniquely.