The table shows terms used in database design.... | Information and Communication Technology 0417 | Paper 1 Mock 01 | Theory

Question 1 Report

The table shows terms used in database design.

(a) Complete the table by giving a definition for each term. [4]

(b) State two data types that could be used for fields in a database. [2]

Answer

Answer Details

(a) The completed table of database terms:

Term	Definition
Table	A structured collection of related data organised into rows and columns within a database. Each table stores data about one type of entity (such as customers or products). [1]
Record	A single row in a table that contains all the data about one particular item or entity (for example, all the information about one student). [1]
Field	A single column in a table that stores one specific piece of information for each record, such as surname, date of birth or telephone number. [1]
Primary key	A field that uniquely identifies each record in a table, ensuring no two records have the same value in that field (for example, StudentID). [1]

(b) Two data types for database fields:

The table shows terms used in database design. Term Definition Table Record Field Primary key (a) Complete the table by giving a definition for each term. [...