Relational Databases (Leaving Cert Computer Science): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What is a relational database?
What is a relational database?
A database storing related data points
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 be stable and permanent
What is a composite primary key?
What is a composite primary key?
A primary key with multiple columns
Why is full name unsuitable as a primary key?
Why is full name unsuitable as a primary key?
Multiple people may have same name
What is a foreign key?
What is a foreign key?
A column linking data in 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
Can a primary key also be a foreign key?
Can a primary key also be a foreign key?
Yes, it can be both