14.02 Database Structure + 14.03 Data Types + 14.04 Primary Keys

Question 1

What is the most simple sort of database?

Answer 1

A table.
eg:

Name: Phone #: Birthday:
John 07849 225439 June 18th
James 07715 152982 September 4th
Jen 01604 845099 July 4th

Question 2

How does the structure work?

Answer 2

• The rows in the table are called the ‘records’

- The columns are called the ‘fields’

Question 3

What is an ‘alphanumeric’ data type?

Answer 3

Made from any character or symbol on the keyboard. eg:

Hello!

Question 4

What is an ‘integer’ data type?

Answer 4

A whole number that does not have a decimal place. eg:

100

Question 5

What is a ‘real’ data type?

Answer 5

A number that does contain decimal places. eg:

1.11

Question 6

What is a ‘date/time’ data type?

Answer 6

A data type that holds a date and/or time. eg:

05:00 18/06/2017

Question 7

What is a ‘boolean’ data type?

Answer 7

Data that has two possible values. eg:
yes/no
true/false

Question 8

What is a ‘Primary Key’?

Answer 8

Each record in the data table is associated with a number, commonly found in the first field (reading left to right). Often used when the first field would be a name or something that in a larger database is lightly to occur more than once. The number in the first field, giving each record in the line an ID, is called the Primary Key.