Back to Scotland Computer Science
Scotland · SQAQ&A
Computer ScienceQ&A by dot point
A short Q&A bank for every Scotland Computer Science syllabus dot point. Each question and answer is drawn directly from our worked dot-point page, so you can scan key concepts before opening the long-form answer.
Database Design and Development
- Analyse data requirements and design a relational database using entities, attributes and relationships, entity-relationship diagrams, a data dictionary, and primary, foreign and composite keys.2Q&A pairs
- Test SQL queries against expected results, maintain referential integrity, and evaluate a database solution for fitness for purpose and data integrity.2Q&A pairs
- Normalise data from unnormalised form to first, second and third normal form, using functional dependency and primary, foreign and composite keys to remove redundancy and anomalies.2Q&A pairs
- Implement and query a relational database in SQL, using data definition (CREATE, ALTER) and data manipulation (SELECT, INSERT, UPDATE, DELETE) with joins, aggregate functions, GROUP BY and HAVING, subqueries, wildcards and computed columns.2Q&A pairs
Software Design and Development
- Describe and implement the data structures used in Advanced Higher: one- and two-dimensional arrays, records, sequential files, linked lists, stacks and queues, including their operations.2Q&A pairs
- Describe and implement object-oriented programming using classes, objects, instantiation, attributes and methods, encapsulation, inheritance, and polymorphism through method overriding.2Q&A pairs
- Describe and compare iterative (agile) and structured (waterfall) development methodologies, and apply the analysis, design, implementation, testing, documentation, evaluation and maintenance stages of the software development process.2Q&A pairs
- Describe and implement the standard searching and sorting algorithms (linear and binary search, bubble, insertion and quicksort), explain recursion, and compare algorithm efficiency.2Q&A pairs
- Plan and carry out testing using normal, extreme and exceptional data and dry runs with trace tables, and evaluate software for fitness for purpose, robustness, efficiency and maintainability.2Q&A pairs
The Project
Web Design and Development
- Implement a web page using HTML5 structural and semantic elements and style it with CSS, using internal and external stylesheets, selectors, classes and IDs, the box model and responsive design.2Q&A pairs
- Implement client-side interactivity with JavaScript, using variables, functions, events, DOM manipulation and form validation.2Q&A pairs
- Implement server-side functionality with PHP, handling form data with GET and POST, using sessions, and connecting to a database to run SQL queries from a web page.2Q&A pairs
- Analyse the requirements of a website and design it using a site structure diagram, wireframes, low-fidelity prototypes and user-centred design principles.2Q&A pairs
- Test a website for functional correctness, and evaluate it for usability, accessibility and fitness for purpose.2Q&A pairs