DATABASES YR 11

A database with only one table is called a:

• Flat file

• Relational database

• Single file

• Solo dataabse

A database with 2 tables is called a __________ database.

When we connect tables in a database that are related, what is this called?

R__________P

In what type of database do we use relationships?

• Flat File

• Relational Database

Headings at the top of a database can also be knowns as f____s.

Short text holds data up to ___ characters.

To store a list of options in a dropdown list, we would use a ______ list.

A checkbox datatype is known as:

• Yes/No

• Lookup

• Boolean

• Short Text

To carry out a presence check, what field do we change to "Yes"

• Validation text

• Validation rule

• Input Mask

• Required

What type of relationship can you see here?

• One to One

• One to Many

• Many to Many