Lesson 1 - Database

Question 1

what is a database?

Answer 1

a file containing organised categories of data about
different objects

Question 2

tables and databases

Answer 2

databases need at least 1 table - this is called flat file database

Question 3

what with more than one table called?

Answer 3

relational databases

Question 4

what does each table consist of?

Answer 4

fields to hold each individual categories of data e.g. name, surname, postcode

Question 5

naming conventions

Answer 5

tbl - table
fld - field
(no spaces, no caps)

Question 6

what is the primary key field?

Answer 6

the unique ID field used to identify each record - usually
autonumber

Question 7

what does a field type do?

Answer 7

defines the type of data to be stored. e.g. text, numeric, boolean, binary, date