Cardinality

What relationship is a pupil to pupil support teacher?

• one to one
• many to many
• one to many

What relationship is a car to a car registration number?

• one to one
• many to many
• one to many

What relationship is a mother to child

• one to one
• many to many
• one to many

What relationship is teacher to pupil

• one to one
• many to many
• one to many

What relationship is an actor to a film

• one to one
• many to many
• one to many

What relationship is a horse to jockey at a racing event?

• one to one
• many to many
• one to many

What relationship is a pupil to an SQA candidate number?

• one to one
• many to many
• one to many

What do we call a field that is a primary key in another table?

• Foreign
• Primary
• Compound
• Candidate

What is not a datatype?

• time/date
• text
• boolean
• number

What do we call a database that consists of more than one table?

• Access
• Datafile
• Flat
• Relational