National 5 Databases

What is the data type of the Event Code Field?

• Number

• Text

• Date

• Time

What is the data type of the Event Date field?

• Number

• Text

• Date

• Time

The Event Code for each race needs to be 7 characters long. What type of validation would be use to ensure this?

• Presence Check

• Range Check

• Length Check

• Restricted Choice

• 
• 
• 
• 

Complete the data dictionary.

• A= Primary Key, B=Foreign Key, C=Boolean, D=True/False

• A= Foreign Key, B=Primary Key, C=Boolean, D=Restricted Choice

• A= Primary Key, B=Foreign Key, C=Text, D=Boolean

• A= Primary Key, B=Foreign Key, C=Boolean, D=Restricted Choice

• 
• 
• 
• 

What information is Nick trying to get from the database?

• Songs by performers that reached number 3 in the charts

• Songs by performers that were in the charts for at least 3 weeks

• Songs by performers with a fan club that reached at least number 3 in the charts

• Songs by performers with a fan club that reached number 3 in the charts

Which of the following SQL ORDER BY clauses would produce the records sorted in the order shown above.

• ORDER BY lastname ASC, schoolname ASC;

• ORDER BY firstname ASC, schoolname ASC;

• ORDER BY schoolname ASC, lastname ASC;

• ORDER BY schoolname ASC, firstname ASC;

Prija wants to get a list of Adult members whose renewal is due in either June or July. Which WHERE clause should she use?

• 
• 
• 
• 

Identify the primary and foreign keys for both entities.

• Teacher: Name (PK) Classroom: Floor (PK), ClassroomID (FK)

• Teacher: Date of Birth (PK), Subject (FK) Classroom: ClassroomID (PK), Department (FK)

• Teacher: Teacher ID(PK) Classroom: ClassroomID (PK), ClassroomID (FK)

• Teacher: Teacher ID(PK), ClassroomID (FK) Classroom: ClassroomID (PK)