National 5 - Database Design and Development Questions
Answering past paper questions is a great way of gauging how ready you are for the real exam. Below are a collection of all past paper questions from previous years, categorised in line with the course specification.
You should attempt to answer all questions in each section and use the marking instructions to check your own work.
If you find yourself struggling with specific topics, return to the study pages to see where you’re going wrong.
Analysis (databases)
Identify the end-user requirements of a database problem
There are currently no past paper questions for this area of knowledge.
Design (databases)
Describe the implications of GDPR
There are currently no past paper questions for this area of knowledge.
Describe an entity
There are currently no past paper questions for this area of knowledge.
Describe an attribute
There are currently no past paper questions for this area of knowledge.
Describe and use a primary key
There are currently no past paper questions for this area of knowledge.
Describe and use a foreign key
There are currently no past paper questions for this area of knowledge.
Describe attribute types
There are currently no past paper questions for this area of knowledge.
Describe and use attribute size
There are currently no past paper questions for this area of knowledge.
Describe and use presence check validation
There are currently no past paper questions for this area of knowledge.
Describe and use restricted choice validation
There are currently no past paper questions for this area of knowledge.
Describe and use field length validation
There are currently no past paper questions for this area of knowledge.
Describe and use range validation
There are currently no past paper questions for this area of knowledge.
Create an entity-relationship diagram
There are currently no past paper questions for this area of knowledge.
Create a data dictionary
There are currently no past paper questions for this area of knowledge.
Design and implement a solution to a query
There are currently no past paper questions for this area of knowledge.
Implementation (databases)
Link tables in a relational database
There are currently no past paper questions for this area of knowledge.
Enforce referential integrity on linked tables in a relational database
There are currently no past paper questions for this area of knowledge.
Describe and use SQL select operations
There are currently no past paper questions for this area of knowledge.
Describe and use SQL order by operations
There are currently no past paper questions for this area of knowledge.
Describe and use , = in SQL operations
There are currently no past paper questions for this area of knowledge.
Describe and use AND, OR in SQL operations
There are currently no past paper questions for this area of knowledge.
Describe and use SQL insert operations
There are currently no past paper questions for this area of knowledge.
Describe and use SQL update operations
There are currently no past paper questions for this area of knowledge.
Describe and use SQL delete operations
There are currently no past paper questions for this area of knowledge.
Describe and use SQL equi-joins between tables
There are currently no past paper questions for this area of knowledge.
Testing (databases)
Test SQL operations
There are currently no past paper questions for this area of knowledge.
Evaluation (databases)
Evaluate a database solution in terms of fitness for purpose
There are currently no past paper questions for this area of knowledge.
Evaluate a database solution in terms of accuracy of output
There are currently no past paper questions for this area of knowledge.