[F3 CS] Database

Objectives

• Understand what a database is for

• Able to tell the difference between fields, records

• Able to tell what the datatype is for each field

• Understand what is a primary key and able to identify it in a table 

Open Ended

Why do you think a database is needed in programming?

Multiple Choice

What is a record in a database?

• Row

• Column

• A number

• A letter

Multiple Choice

What is a field in a database?

• Row

• Column

• A number

• A letter

Multiple Choice

Entering the same data twice

Is this validation or verification?

• Validation

• Verification

Multiple Choice

Checking if the data is in the correct format

Is this validation or verification?

• Validation

• Verification

Multiple Choice

Checking if the data entered exceeds a certain length

Is this validation or verification?

• Validation

• Verification

Multiple Choice

Visually checking if the the data entered is correct

Is this validation or verification?

• Validation

• Verification

Multiple Choice

What should be the data type for the data below

2020/3/16

• alphanumeric

• integer

• boolean

• date

Multiple Choice

What should be the data type for a field that can only store Yes / No

• alphanumeric

• integer

• boolean

• date

Fill in the Blank

Which field should be the primary key in this database

_