N5 SQL Recap

Match the following SQL commands with their definitions

• FROM

• The fields to display

• SELECT

• The table used

• WHERE

• The order used to sort

• ORDER BY

• The criteria which must be met

Put these SQL commands in the correct order

• FROM

• 4

• ORDER BY

• 1

• SELECT

• 2

• WHERE

• 3

SQL stands for Structured Q (a)   Language

Identify the primary keys in the diagram.

a

b

email

breed

kennel_id

dog_id

Giving the users a drop down menu of options

• Length check

• Range check

• Restricted choice

• Presence check

What type of validation ensures that a user must enter a value in a form field?

• Length check

• Presence check

• Range check

• Restricted choice

Which validation method checks if the age is >0 and <100

• Presence check

• Restricted choice

• Range check

• Length check

What type of validation is used to ensure the input is of a specific length?

• Range check

• Presence check

• Length check

• Restricted choice

An e (a)   is the name given to a table in a database

Organize these options into the right categories

Groups:

(a) Suitable Primary Keys

,

(b) Attributes

• StudentID

• LastName
• Email
• Gender
• PhoneNumber
• CourseID
• EnrollmentID
• DepartmentID
• FirstName
• DateOfBirth
• InstructorID
• Address
• ClassroomID
• EnrollmentDate