Information Systems in Organisations
Tuesday 09:30-12:30 TF110 (Yarnfield)
Wednesday 09:30-12:30 TF110 (Yarnfield)
Thursday 13:30-16:30 TF110 (Yarnfield)

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


        1
 
 

ISiO Module Handbook
 
ISiO Module Introduction
 
System Development Environment
 

SDE Exercise
 


        2
 
 

SDLC Introduction
 

Potteries Music Zone Exercise
 


        3
 
 

Structured Systems Analysis
 
System Development Methodologies
 

Music Zone Requirements Exercise
 
Requirement Specification Template
 
corner piece corner piece

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


        4
 
 

Data Flow Techniques
 
Introduction to DFDs
 
Process modelling
 

Music Zone Context Diagram Exercise
 
Payroll System DFDs
 


        5
 
 

Use Case Modelling
 

Music Zone Use Case Exercise
 


        6
 
 

Entity Relationship Diagrams
 

Entity, Attributes, Relationships tutorial
 
corner piece corner piece

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


        7
 
 

ERDs - Cardinality and Optionality
 
ERDs - Introduction
 
ERDs - Key terms
 
ERDs - Relationships
 

ERDs - Relationship Quiz
 
Village Library ERD
 


        8
 
 

ERDs - Many to Many Relationships
 
ERDs - Selecting Attributes
 

Further ERD exercises
 


        9
 
 

Introduction to Normalisation
 

Normalisation exercise 1
 
Normalisation exercise 2
 
Normalisation exercise 3
 
Normalisation exercise 4
 
Normalisation exercise 5
 
corner piece corner piece

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


        10
 
 

QSEE and MySQL
 


        11
 
 

Entering data into MySQL
 


        12
 
 

Simple select queries
 
corner piece corner piece

corner piece Weeks 13-15 corner piece
Week Lecture Tutorial/Exercise


        13
 
 

Calculations and Groupings
 


        14
 
 

Joins and Subqueries
 

Joins and Subqueries (Exercises)
 


        15
 
 

Altering Tables
 

Altering tables (Exercises)
 
corner piece corner piece

corner piece Weeks 16-18 corner piece
Week Lecture Tutorial/Exercise


        16
 
 

Triggers
 


        17
 
 

Database Testing
 
corner piece corner piece


corner piece Links & Addtional Resources corner piece
Links Additional Resouces

An Introduction to Database Normalization

Data flow diagram (Wikipedia)

Data Flow Modelling (explained)

Database normalization

DFD Symbols

Entity Relational Diagrams

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

Generate Data

How to draw Data Flow Diagrams

ISO Module Descriptor

Mockaroo

MySQL 5.5 Reference Manual

MySql Stored Procedure

MySQL Tutorial.org

Normalisation (explained)

Normalisation Demonstration (video)

Primary and Secondary Data Sources

Primary vs Secondary Sources

QSEE ERD Tutorial

QSEE General Tutorial

QSEE Superlite (homepage)

QSEE Superlite (zipped folder)

Rapid Application Development

Requirements analysis (Wikipedia)

SAD Introductory Tutorial

Soft systems methodology

Soft systems methodology (Wikipedia)

SSADM

SSADM (Wikipedia)

System context diagram (Wikipedia)

Systems Development Life Cycle

The Need for Normalisation

W3Schools (Learn SQL)

Wikipedia

XAMPP

XAMPP Lite Setup (YouTube video)

Yourdon's chapter on DFDs

 
 
corner piece corner piece

Acknowlegements to: Janet Fabulous Francis, Phil Rock James & Richard Cool Hancock

< Back to Home Page >

Valid XHTML 1.0 Transitional   Valid CSS!   PHP enabled!