Data and Databases
Tuesday 13:30-16:30 S205 (Staffs Uni)
Wednesday 13:30-16:30 S205 (Staffs Uni)
Thursday 13:30-16:30 S205 (Staffs Uni)

corner piece Weeks 1-3 corner piece
Week Lecture Tutorial/Exercise


        1
 
 

SDLC Introduction
 
System Development Environment
 

SDE Exercise
 


        2
 
 

Introduction to DFDs
 

Music Zone Context Diagram Exercise
 
Music Zone Exercise
 
Payroll System DFDs
 


        3
 
 

ERDs - Cardinality and Optionality
 
ERDs - Introduction
 
ERDs - Key terms
 
ERDs - Many to Many Relationships
 
ERDs - Relationships
 
ERDs - Selecting Attributes
 

ERDs - Relationship Quiz
 
corner piece corner piece

corner piece Weeks 4-6 corner piece
Week Lecture Tutorial/Exercise


        4
 
 

Introduction to Normalisation
 

Normalisation exercise 1
 
Normalisation exercise 2
 
Normalisation exercise 3
 
Normalisation exercise 4
 
Normalisation exercise 5
 


        5
 
 

Use Case Modelling
 


        6
 
 

Creating ERDs in QSEE Superlite
 
Entering data into MySQL
 
Exporting ERDs from QSEE Superlite into MySQL
 
corner piece corner piece

corner piece Weeks 7-9 corner piece
Week Lecture Tutorial/Exercise


        7
 
 

Calculations and Groupings
 
Simple select queries
 

Calculations and Groupings (Exercises)
 
Simple Select (Exercises)
 


        8
 
 

Altering Tables
 
Joins and Subqueries
 

Altering tables (Exercises)
 
Joins and Subqueries (Exercises)
 


        9
 
 

Introduction to PHP
 
PDO Connection to MySQL
 
PDO Delete and Update Queries
 
PDO Insert Query
 
PDO Select Query
 

Employee-Project database file
 
Employee-Project PHP files (zipped)
 
corner piece corner piece

corner piece Weeks 10-12 corner piece
Week Lecture Tutorial/Exercise


        10
 
 

Database Testing
 

Testing Plan
 
corner piece corner piece


corner piece Links & Addtional Resources corner piece
Links Additional Resouces

DaD module descriptor

Data flow diagram (Wikipedia)

Data Flow Modelling (explained)

DFD Symbols

Entity Life History (Explanation)

Entity Relationship Diagrams (explained)

Entity Relationship Model (Wikipedia)

Entity Relationship Modeling (video)

Example of a Data Flow Diagram (Level 0)

Example of a DFD Context Diagram

How to draw Data Flow Diagrams

Introduction to PHP PDO

Jackson Workbench ELH

Mockaroo

Normalisation Demonstration (video)

Notepad++

Object Sequence Diagram

PDO Connection (Explained)

PHP 5 Forms - Required Fields

PHP Data Objects (PHP.net)

QSEE Superlite (homepage)

QSEE Superlite (zipped folder)

Requirements analysis (Wikipedia)

SSADM

SSADM (Wikipedia)

System context diagram (Wikipedia)

Systems Development Life Cycle

TeacherInfo ELH

TechnologyUK ELH

The (only proper) PRO tutorial

Use Cases (Codemanship)

W3Schools (HTML Forms)

W3Schools (PHP Form Validation)

W3Schools (PHP Forms)

W3Schools (SQL Tutorial)

XAMPP
 
corner piece corner piece

Acknowlegements to: Phil Rock James

< Back to Home Page >

Valid XHTML 1.0 Transitional   Valid CSS!   PHP enabled!