S4 Databases

A File is...

• An entire database
• All the information about one object in a database
• One specific piece of information stored for each record
• Something for shaping your fingernails

A Record is...

• An entire database
• All the information about one object in a database
• One specific piece of information stored for each record
• Something for shaping your fingernails

A Field is...

• An entire database
• All the information about one object in a database
• One specific piece of information stored for each record
• Something for shaping your fingernails

Which of the following is not a field type?

• Text
• Date
• Boolean
• Query

A Primary Key is...

• How Santa gets into houses without chimneys
• A field used to link tables
• A field which uniquely identifies each record

A Foreign Key is...

• How Santa gets into houses without chimneys
• A field used to link tables
• A field which uniquely identifies each record

Which type of validation check could be used for a text field containing a month of the year, e.g June?

• Range Check
• Length Check
• Restricted Choice Check
• Presence Check

Which type of validation check could be used to ensure a contact email address has been entered?

• Range Check
• Length Check
• Restricted Choice Check
• Presence Check

Which type of validation check could be used to check is a phone number is valid?

• Range Check
• Length Check
• Restricted Choice Check
• Presence Check

Which type of validation check could be used to check a hotel check-out date is later than the associated check-in date

• Range Check
• Length Check
• Restricted Choice Check
• Presence Check