DATABASE THEORY

Question 1

Databases?

Answer 1

• A database is a collection of data

Question 2

What is a set of data stored in?

Answer 2

• ## Stored in a TABLE for example information about all of the learners in a school

Question 3

What is a single item of data stored in?

Answer 3

• Stored in a RECORD, for e.g. information about one learner

Question 4

What do the columns in a table store?

Answer 4

Store data in table store categories called FIELDS, for e.g. Name, Address, Gender, Date of birth

Question 5

PRIMARY KEY?

Answer 5

• Each table in a databse should have a primary key
• This is a unique piece of data which identifes one record

Question 6

FOREIGN KEY?

Answer 6

• This is the primary key in a different table and creates a RELATIONSHIP

Question 7

Data types used in databases?

Answer 7

Text - Characters (letters, numbers, and symbols)
Number - numerical value
Date/times - Dates and times
Boolean - Yes/no also known as true/false