3.7

Question 1

Define Database.

Answer 1

A database is a way of holding data in an organised way so that it is quick and easy to find a particular item.
A database will contain one or more tables.

Question 2

Define a Relational Database.(3)

Answer 2

In a relational database each entity has its own table, and the tables are linked by a common field.
By doing this each item of data is held only once, there is no possibility of inconsistency in the spelling of a name, or a difference in two phone numbers recorded for the same person.
Data inconsistency and data redundancy have been eliminated.

Question 3

What does SQL stand for?(2)

Answer 3

Structured Query Language.
It is used for querying and updating database tables in a relational database.

Question 4

Define record.

Answer 4

A record within a database is the combined entities on a single row.

Question 5

Define field.

Answer 5

Each field is a different column in a database.

Question 6

Define entity.

Answer 6

Each individual person or thing within any database.

Question 7

What is the foreign key?

Answer 7

The foreign key is the field which is the Primary Key of one table, and a field in another.

Question 8

What is the primary key?

Answer 8

The Primary Key is the unique identifier in a database table. No two entities in the table in the field of the Primary Key can be the same.