A database is a structured, persistent collection of related data held in one place so that it can be searched, updated and shared by more than one application.

What is a table in a relational database?

A table is a set of records about one kind of thing, such as pupils or orders, with the same fields defined for every record.

What does one row of a database table represent?

One row is a record, holding all the field values for a single instance of the thing that table describes.

What does one column of a database table hold?

One column is a field, holding the same attribute for every record in the table, such as surname or date of birth.

Define the term attribute as used in database design.

An attribute is a named property of an entity, and it becomes a field of the table that stores that entity.

WJEC A-Level Computer Science 601-5345-3

Hardware: Architecture, Memory and Storage

Topic overview Components of a computer system and how they connect Von Neumann architecture and the CPU The fetch-execute cycle Memory and caching Parallel processing Input and output devices and their uses Secondary storage, fragmentation and defragmentation

Networks and Data Transmission

Topic overview Serial and parallel transmission Simplex, half duplex and full duplex Multiplexing and switching Packets and the TCP/IP protocol stack Networks, standards and protocols Collisions and shared media Routing, addressing and the internet

Logic Gates and Boolean Algebra

Topic overview Logic gates and their truth tables Boolean notation and expressions Building and reading truth tables Boolean identities and rules Simplifying Boolean expressions De Morgan's laws Masking and clearing registers

Data Representation and Data Types

Topic overview Bits, bytes and words The binary number system Hexadecimal notation Character sets and storing characters Primitive data types and storage requirements Binary arithmetic and negative numbers Real numbers, truncation and rounding

Data Structures

Topic overview Data structures and data types One-dimensional arrays Two-dimensional arrays Manipulating arrays Records and fields Arrays of records Choosing a data structure

Organisation of Data: Files and Records

Topic overview Files, records and fields Fixed and variable length records Master and transaction files File access and organisation methods Sequential file access and update algorithms File security, backup and archiving Data validation and verification

Database Systems

Topic overview Flat files and the relational model Relational and other contemporary database systems Primary, foreign, composite and candidate keys Indexes and links between tables Entity relationship modelling Normalisation to third normal form The database management system, queries and user views

The Operating System

Topic overview The need for an operating system The kernel and process management Memory protection and the backing store The user interface between user and hardware Directory structures and file attributes Utility software Batch, real time control and transaction processing

Algorithms and Programs

Topic overview Defining and designing algorithms Variables, constants and identifiers Scope, subprograms and parameter passing Sequence, selection and repetition Mathematical and logical operations Standard algorithms: sorting, searching and compression Dry running, trace tables and test data

Principles of Programming

Topic overview Procedural programming Event-driven and visual programming Mark-up languages Object-oriented programming: objects, classes and methods High-level languages Low-level languages Choosing a language for a problem

Systems Analysis

Topic overview The systems life cycle and the feasibility study Methods of investigation Analysis, abstraction and decomposition Design and data flow diagrams Testing and changeover Maintenance Backup, recovery and documentation

Software Engineering and Program Construction

Topic overview Integrated development environments and their purpose Editors, syntax highlighting and code entry tools Debugging tools: breakpoints, stepping and watches Translation, source code and object code Lexical analysis and the symbol table Syntax and semantic analysis Code generation and optimisation

Types of Software System

Topic overview Off-the-shelf, bespoke and custom software Open source and proprietary software Computers in weather forecasting Computer aided design and manufacture Robotics in industry Computer generated graphics and animation Expert systems

Practical Programming

Topic overview Designing data structures: fields, records and data types Key fields and methods of access Validation of input data Designing routines with pseudocode Tracing code and test data Prototyping and evaluating a solution Annotated listings and readable code

Data Security and Integrity

Topic overview Dangers of holding files of personal data Levels of permitted access and access control Passwords and authentication Clerical procedures and write-protection Threats to computer systems Malicious and accidental damage to data Contingency planning and disaster recovery

Computing, Society and the Law

Topic overview Social and economic change from computing Computers and the nature of employment The digital divide and cultural change Environmental cost of computing Data protection and freedom of information law The Computer Misuse Act 1990 and computer crime Copyright, surveillance and professional codes

Advanced Data Structures and Logic

Topic overview Arrays in three dimensions Stacks and queues using pointers and arrays Linked lists using pointers and arrays Binary trees using pointers and arrays Hash tables and collision resolution NAND, NOR and Boolean simplification Masking, clearing registers and encryption

Recursion, Sorting and Searching

Topic overview Recursion Quicksort and merge sort Comparing sorting algorithms Big O notation and algorithm complexity Searching and shortest-path algorithms Traversal of data structures Data compression and its efficiency

Programming Paradigms and Translators

Topic overview Functional, declarative and imperative paradigms Classes, methods and object-oriented design Standardisation of computer languages Ambiguity in natural language and unambiguous notation Backus-Naur form and syntax diagrams Compilers, interpreters and assemblers Translation and execution errors

System Design and Human-Computer Interaction

Topic overview The waterfall approach Agile approaches Documentation and when it is produced Contemporary approaches to communicating with computers Natural language interfaces and spoken ambiguity Design review and validation Evaluating a computer based solution

Software Engineering Tools and Professional Practice

Topic overview Software tools for the software engineering process Software packages in systems analysis and specification Software packages in systems design Testing tools and testing strategies Program version management Program libraries and project management tools Codes of conduct and professional behaviour

Advanced Architecture and Assembly Language

Topic overview Components of contemporary architecture Von Neumann and Harvard architectures The fetch-execute cycle in detail Parallel processing and its limits Assembly language and instruction formats Voice input, command and recognition Mobile and wireless networking

Communication Networks and File Organisation

Topic overview Calculating data transfer rates Lowest-cost routing The internet as a global infrastructure Creating, organising and processing files Hashing algorithms Overflow and file reorganisation Choosing an organisation and a route

Number Representation and Floating Point

Topic overview Binary arithmetic Sign and magnitude representation Two's complement Floating point representation Converting between real numbers and floating point Truncation, rounding and accuracy Shifts, overflow and underflow

Databases and Distributed Systems

Topic overview Consistency, redundancy and data independence Relational organisation and normalisation Restructuring data into third normal form Entity relationship modelling Query languages and SQL Validation, verification and the DBMS Big Data, data warehousing and mining Distributed systems and distributed databases

Operating System Management

Topic overview Types of operating system Interrupts and interrupt handling Memory management and partitioning Buffering and data transfer Scheduling and process states Scheduling policies and priorities Evaluating operating system design

Software Systems and Applications

Topic overview The range of software system types Safety related and safety critical systems Computer control and automation The scope of automation in practice Expert systems The internet, intranets and search Selecting and evaluating a software system

Data Security, Cryptography and Attack

Topic overview Integrity problems in online updating The need for cryptography Symmetric and asymmetric techniques Classical ciphers and cryptographic algorithms Comparing cryptographic strength Biometric technologies Malicious software and its vectors Attacks, defence and penetration testing

Database Systems

7 subtopics
21 things to know
AS Unit 1

What Database Systems covers

Database Systems is examined in AS Unit 1, Fundamentals of Computer Science. It covers flat files and the relational model, relational and other contemporary database systems, primary, foreign, composite and candidate keys, indexes and links between tables, entity relationship modelling, normalisation to third normal form and the database management system, queries and user views.

Where it is assessed

AS Unit 1

Fundamentals of Computer Science, examined again at A2 at a more demanding level.

Check the WJEC specification ↗

The 7 subtopics

Each one has its own page.

What you need to know

Answer each one before you reveal it.

Your recallNot started

Key term

What is a database?

Key term

Why does holding a customer's full address inside every one of their order records cause problems?

Key term

State two benefits of a relational database system.

Key term

Define the term primary key.

Key term

What is an index in a database?

Key term

What is an entity relationship diagram used for?

Key term

What is normalisation?

Key term

What is a query?

Key term

Give two drawbacks of a relational database system.

Key term

Why must the value of a primary key never repeat?

Key term

Give one drawback of adding an index to a field.

Key term

How is an entity shown in an entity relationship diagram?

Key term

State the condition a table must meet to be in first normal form.

Key term

Which keyword in a Structured Query Language statement lists the fields to be returned?

Key term

Describe how a flat file database stores its data.

Key term

What is a NoSQL database?

Key term

How is a primary key chosen from among the candidate keys?

Key term

Which fields are worth indexing?

Key term

Name the three degrees of relationship an entity relationship model can show.

Key term

State the condition a table must meet to be in second normal form.

Key term

What does the FROM clause of a query specify?

Take Database Systems further

The same content, four other ways.

Questions from this topic

Each one with the model answer underneath.

1
What is a database?
Model answer
A database is a structured, persistent collection of related data held in one place so that it can be searched, updated and shared by more than one application.
2
Describe how a flat file database stores its data.
Model answer
A flat file database holds everything in one single table, so every record repeats every attribute it needs, including facts that really belong to something else.
3
What is a table in a relational database?
Model answer
A table is a set of records about one kind of thing, such as pupils or orders, with the same fields defined for every record.
4
What does one row of a database table represent?
Model answer
One row is a record, holding all the field values for a single instance of the thing that table describes.
5
What does one column of a database table hold?
Model answer
One column is a field, holding the same attribute for every record in the table, such as surname or date of birth.
6
Define the term attribute as used in database design.
Model answer
An attribute is a named property of an entity, and it becomes a field of the table that stores that entity.

See the rest and revise

What is inside Levo

Six ways to work the same material.

1Closed book

2Open book

3Closed book

The 3-step method, run for you

Answer cold, learn it, then prove it stuck. Levo tracks the jump between your first attempt and your last.

Hardware: Architecture, Memory and Storage

Networks and Data Transmission

Logic Gates and Boolean Algebra

Data Representation and Data Types

Cram a whole paper in one sitting

Sort every topic into what you know and what you do not, then drill only the weak ones.

Fetch, , execute.

decodecompilestore

Blank Blitz makes facts automatic

Rapid timed gap-fills on the terms and numbers you need to recall without thinking.

AEncryption is reversible.

BThe stored form could be decrypted.

CA hash cannot be reversed.

Build It gets the exam shape right

Assemble a full-mark answer from its marking points, in the order an examiner wants them.

A bit is a single binary digit.

TrueFalse

Test It catches misconceptions

Spot the fault in a statement. The traps are the mistakes students actually make.

721941163128510

Brain Breaks between sessions

Short focus games to reset attention, so the next set lands better than the last.

Database Systems revision questions

What does Database Systems cover in WJEC A-Level Computer Science?: 7 subtopics: flat files and the relational model, relational and other contemporary database systems, primary, foreign, composite and candidate keys, indexes and links between tables, entity relationship modelling, normalisation to third normal form and the database management system, queries and user views. Each one has its own page with questions and model answers.
How is Database Systems organised?: By the WJEC 601-5345-3 specification, subtopic by subtopic, so it matches the order you are taught it in.

Every question in Database Systems, on a schedule.

Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.

Start revising, £5 a month See how the method works

Or £46 a year, about £3.83 a month. Cancel anytime.