National 5 Databases

Number

Text

Date

Time

Number

Text

Date

Time

Presence Check

Range Check

Length Check

Restricted Choice

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

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

ORDER BY lastname ASC, schoolname ASC;

ORDER BY firstname ASC, schoolname ASC;

ORDER BY schoolname ASC, lastname ASC;

ORDER BY schoolname ASC, firstname ASC;

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)