← Computer Science syllabus

ScotlandComputer Science

Database design and development

2 dot points across 2 inquiry questions. Click any dot point for a focused answer with worked past exam questions where available.

How do we analyse the requirements for a database and design its tables, fields and validation?

Database analysis and design: identifying end-user and functional requirements, designing tables with fields and appropriate field types, and choosing primary and foreign keys and validation.
An SQA National 5 Computing Science answer on database analysis and design, covering how to identify end-user and functional requirements, design tables with fields and suitable field types, choose a primary key and a foreign key to link tables, and add validation such as presence, restricted choice, field length and range checks.
10 min answer →

How do we use SQL to search, sort, add, change and delete data in a database?

SQL implementation: searching and sorting with SELECT, FROM, WHERE and ORDER BY, and changing data with INSERT, UPDATE and DELETE, then testing and evaluating the database.
An SQA National 5 Computing Science answer on implementing a database in SQL, covering how to search and sort records using SELECT, FROM, WHERE and ORDER BY, how to add, change and remove data with INSERT, UPDATE and DELETE, and how to test and evaluate that the database meets its requirements.
11 min answer →