Relational Databases (Leaving Cert Computer Science): Quizzes
📚Quizzes
Practise the questions
12 questions from this quiz
ShowHide
Practise the questions
12 questions from this quiz
What does a relational database store and provide access to?
What does a relational database store and provide access to?
Data points related to one another
What is a primary key in a database table?
What is a primary key in a database table?
A unique identifier for each record
Can two rows in a table have the same primary key value?
Can two rows in a table have the same primary key value?
No, primary key values must be unique
Can a primary key column contain null values?
Can a primary key column contain null values?
No, it cannot contain null values
Should a primary key value change over time?
Should a primary key value change over time?
No, it should not change
What is a composite primary key?
What is a composite primary key?
A primary key with multiple columns
In the Student Table, which column is the primary key?
In the Student Table, which column is the primary key?
ID column
Why is full name unsuitable as a primary key?
Why is full name unsuitable as a primary key?
Multiple people may have the same name
What does a foreign key do in a database?
What does a foreign key do in a database?
Creates a link between two tables
What does a foreign key refer to in another table?
What does a foreign key refer to in another table?
The primary key
In the Student Table, what is Exam ID?
In the Student Table, what is Exam ID?
A foreign key referencing Grade Table
Can a primary key also be a foreign key?
Can a primary key also be a foreign key?
Yes, it can be both