N5 Database Design & Development

Database Design & Development Notes

Analysis

Design: Tables and Key Fields

Design: Tables and Entity Relationship Diagrams

Design: Fields and Data Dictionaries

Data Validation

General Data Protection Regulation

SQL: Queries & Searching

SQL: Complex Searches

SQL: Sorting

SQL: Multiple Table Queries

SQL: Data Modification

Testing & Evaluation

You can download the complete set of notes below:

Database Design & Development Practical Tasks:

Topic 1 - Database Creation

From Design to Database

Validation Rules

Lookups

Populating a Database

Topic 2 - SQL Queries

You will need to download the fully populated database below before attempting these tasks:

SELECT and FROM

Exact Match Queries

Partial Match Queries

Other Comparison Operators

Complex Queries

Sorting

Queries Using Two Tables

Adding Records to a Database

Deleting Records from a Database

Editing Records in a Database

Topic 3 - Extra Practice and Revision

Extra Practice: SQL

Extra Practice: Database Creation

Extra Practice: Old CWAs