Databases

Question 1

Primary Key

Answer 1

Something that uniquely identifies each record entered

Question 2

Foreign Key

Answer 2

Something that has identical data to that of a primary key, but is located in a different table

Question 3

Table

Answer 3

This is where the fields are set and the data is entered

Question 4

Query

Answer 4

This is the stage where the manipulation and sorting of data occurs

Question 5

Report

Answer 5

This is the end result of the data and is the output of the database

Question 6

Validation Rule

Answer 6

This is a rule put in place to control what is inputed into the table eg. Between 3000 and 3999

Question 7

Input Mask

Answer 7

This allows a person to restrict what can be entered but more specific eg. \0!400 000 000

Question 8

Convention

Answer 8

Something that is usually done

Question 9

Format

Answer 9

The way in which something is arranged or set out

Question 10

Entity Relationship Diagram

Answer 10

This is a diagram which shows entities, attributes and relationships between tables

Question 11

Normalisation

Answer 11

This is the reorganisation of data so that it meets three basic requirements

Question 12

Testing

Answer 12

This is the process of ensuring that the output of data is as expected

Question 13

One-to-Many
One-to-One
Many-to-Many

Answer 13

These are type of relationships and show the connection between two tables

Question 14

Field Type

Answer 14

This describes the attribute and the format in which it takes eg. Short Text, numeric, boolean

Question 15

Attribute

Answer 15

This is a feature of a table eg. Name, Address

Question 16

Entity

Answer 16

This is one of the main features of a solution also referred to as a table