Databases

Question 1

A database

Answer 1

A database is a (large) collection of data item and link between them, structured in a way that allows it to be accessed by a number of different application programs

Question 2

Table

Answer 2

A table is a flat file where data is converted into rows and columns

Question 3

Record

Answer 3

A record is a collection of data items which may be of different data types, all relating to the individual or object that the record describes. Records are represented by a row in a table.

Question 4

Field

Answer 4

A field is part of a record designed to hold a single data item specified type. Fields are represented by a column in a table

Question 5

Primary key

Answer 5

A primary key is a field that uniquely identifies an individual record in a table

Question 6

Foreign key

Answer 6

When the primary key from one table appears as a field in a second table, it is known as a foreign key of the second table. This forms a connection between tables

Question 7

Composite key

Answer 7

A composite key is a key that consists of 2 or more fields