Computer Science - AS Level

Database and Data Modelling

9.1 Flat Files and Relational Databases

• Flat Files and Relational Databases Presentation (Bold Links below indicate links provided by CIE which cover topics not covered in my presentation or Quiz)
  • Structured Query Language (SQL) (wikibooks)
  • SQL Tutorials (sqlzoo)
  • Data Definition Language (DDL) (wikibooks)
  • Data Definition Language (DDL) (wikipedia)
  • Data Manipulation Language (DML) (wikipedia)
    • CREATE DATABASE (wikipedia)
    • CREATE TABLE (wikipedia)
    • ALTER TABLE (wikipedia)
    • ADD FOREIGN KEY / PRIMARY KEY (wikipedia)
    • SELECT, FROM, WHERE, ORDER BY, GROUP BY, INNER JOIN (wikibooks)
    • INSERT INTO (wikibooks)
    • DELETE (wikibooks)
    • UPDATE (wikibooks)
  • Definition of Relational Database (howstuffworks)
  • Theory notes on Databases (teach-ict.com)
  • Theory notes on concepts (teach-ict.com)
  • Introductory notes on Databases (wikibooks)
  • Notes on Keys1 (wikibooks)
  • Notes on Keys2 (teach-ict.com)
    • Flat Files and Relational Databases Quiz

9.2 Entity-Relationship (E-R) Diagrams

• Entity-Relationship (E-R) Diagrams Presentation
  • Theory notes on Database Modelling (teach-ict.com)
    • Entity-Relationship (E-R) Diagrams Quiz

9.3 Database Normalization

• Database Normalization Presentation
  • Normalisation (wikibooks)
  • Theory on Normalisation (teach-ict.com)
    • Database Normalization Quiz

9.4 Hierarchical Databases

• Hierarchical Databases Presentation
  • Hierarchical Databases Quiz