Bolger's Web - Databases Notes
Unit 13 Database Management Systems - Week by Week Notes and Tutorials

All work set/undertaken in class MUST be completed either in class or during timetabled study periods ready for submission at your next scheduled class 

Week 01 - ( w/b 3rd Sept) Induction Week
 
see induction activities
 
Week 02 - ( w/b 10th Sept) Unit 5 / Course Overview
Lesson Plan: Week 02 - Plan
Lesson Aims: Week 02 - Aims
Class Materials Used: Overview of the Course
  Unit 13 - Syllabus
 

Ice Breaker - Card Trick 01

 

Ice Breaker - Card Trick 02 Part 1

 

Ice Breaker - Card Trick 02 Part 2
  Class Notes - Databases and Fields
  Activity 01 - Simple Database
Recap / Assessment: Week 02 - Lesson Recap Assessment
   
More Background / Reading: Additional Task - Card Trick 03
Week 03 - ( w/b 17th Sept) - Databases Jargon & Concepts
Lesson Plan: Week 03 - Plan
Lesson Aims: Week 03 Aims
Class Materials Used: Class Lecture - What is a Database (ppt)
 

Class Lecture Databases overview (ppt)
 

Class Notes - Database Jargon and Concepts 1
  Class Notes - Database Jargon and Concepts 2
  What we did this week - Databases class week 03 (Doctors Surgery Appointments)
  On-Line Notes - Databases Quiz
  On-Line Notes - Quiz on databases
  On-Line Notes - Data Types  
  On-Line Notes - Relational Databases   
  On-Line Notes - Data Validation   
   On-Line Notes - Databases 
  Class Notes - What is a Relational Database ?
  Class Notes - What are Key Fields ?
  Activity 01 - Creating Databases
  Activity 02 - Database Activities
  Download - Databases needed for Database Activities 01 and 02
Recap / Assessment: Week 03 - Lesson Recap Assessment
More Background / Reading: Additional Tasks - Beginners Access Exercises
  PowerPoint - database 00 database jargon
  PowerPoint -  database 00 Introduction to databases
  Additional Class Notes - Key fields and Relationships
  Powerpoint 'Introduction to Database'
  On-Line Resources - BBC Databases
  On-Line Resources - Databases & Spreadsheets
  Additional Class Notes - Primary and Foreign Keys
Week 04 - ( w/b 24th Sept) - Building a Database Part 1
Lesson Plan: Week 04 - Plan
Lesson Aims: Week 04 Aims
Class Materials Used: what we did week 04 - Databases week 04 
  Micro Teach 01- video rental shop ( tables, forms, command buttons, lookup fields )
  Additional Task - Simple Grading Database (Part 01)
  Additional Task - Simple Grading Database (Part 02)
Recap / Assessment: Week 03 - Lesson Recap Assessment
More Background / Reading: Workbooks - Databases Library or Notes & Exercises
Week 05 - ( w/b 1st Oct)
Lesson Plan: Week 05 - Plan
Lesson Aims: Week 05 - Aims
Class Materials Used: this weeks lesson - week 05 - powerpoint (video rentals database)
  what we did this week - week 05
  micro teach 01 - simple video rental
  micro teach 02 - cornish extremes outdoor
  additional task - football tickets
  download - last weeks database (doctors surgery)
Recap / Assessment: Week 05 - Lesson Recap Assessment
   
 More Background / Reading: Workbooks - Databases Library or Notes & Exercises
   
   
Week 06 - ( w/b 8th Oct)
Lesson Plan: Week 06 - Plan
Lesson Aims: Week 06 - Aims
Class Materials Used: Micro Teach 01 - Airport Booking System ( mini assessment of everything covered so far)
   
Recap / Assessment: Week 06 - Lesson Recap Assessment
   
 More Background / Reading:  
   
Week 07 - ( w/b 15th Oct)
Lesson Plan : Week 07 - Plan
Lesson Aims: Week 07 Aims
Class Materials Used: Issued Assessment 13.1 - Types of Databases ( evidence P1, D2 )
  Powerpoint Show - Types of Database
  Notes & Examples - Types of Database
Recap/Assessment Week 07 - Lesson Recap Assessment
More Background / Reading: Further Notes - 01 -Databases and Models 
  Further Notes - 02 - Types of Data Model
  Further Notes - 04 - Relational Data Model
  Further Notes - 05 -Network Data Model
  Further Notes - 06 - Object Oriented Model
  Further Notes - MORE HELP and IVA related NOTES ( remember to log in to CBCT )
Autumn Half Term
Week 08 - ( w/b 29th Oct) - Introducing SQL - Data Definition Language (DDL)
Lesson Plan: Week 08 - Plan
Lesson Aims: Week 08 Aims
Class Materials Used: Powerpoint - Create Tables
  Notes - DDL Create Tables Exercise
Recap / Assessment: Week 08 - Lesson Recap Assessment
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
  Further Reading Micro Teach 02 - DDL create / drop / views command
  Further Reading PowerPoint -  database 04 sql
  Further Reading PowerPoint -  database 05 sql and visual basic
  Further Reading Notes - SQL overview
  Further Reading Notes - DDL commands
  Further Reading Notes - SQL quick reference
  Further Reading Micro Teach 01 - SQL - DDL - create table command
Week 09 - ( w/b 5th Nov) - Assessment 13.1 Consolidation Week
Lesson Plan: Week 09 - Plan
Lesson Aims: Week 09 -Aims
Class Materials Used: Micro Teach 01 - Complete Finish Assessment 13.1 in class
  Notes -
Recap / Assessment: Week 09 - Lesson Recap Assessment
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
   
Week 10 - ( w/b 12th Nov) - Assessment 13.1 Presentation
Lesson Plan: Week 10 - Plan
Lesson Aims: Week 10 - Aims
Class Materials Used: Recap - Previous Session
 

Deadline - Assessment 13.1- Front Cover Sheet

  Documentation - Tutor Assessment Sheet (Blue) (Green) (Diploma)
  Documentation - Peer Assessment Sheet (Blue) (Green) (Diploma)
  Documentation - Self Assessment Sheet (Blue) (Green) (Diploma)
Recap / Assessment: Week 10 - Lesson Recap
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
Week 11 - ( w/b 19th Nov) - Assessment 13.1 Presentation mop ups / Introducing SQL - Easy DML
Lesson Plan: Week 11 - Plan
Lesson Aims: Week 11 - Aims
Class Materials Used: Recap - Previous Session
  Micro Teach 01 - DML - SELECT statements
  Notes - Reserved Words in SQL
Recap / Assessment: Week 11 - Lesson Recap
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
Week 12 - ( w/b 26th Nov) - Further Data Manipulation Language (DML)
Lesson Plan: Week 12 - Plan
Lesson Aims: Week 12 -Aims
Class Materials Used: Micro Teach 01 - Easy DML - SELECT statements 1 - (computers Easy 1-7)
  Micro Teach 02 - Easy DML - SELECT Statements 2 - (computers Further 9-16)
  Micro Teach 03 - Easy DML - Select Statements 3 - (ships Easy 31-55)
  Download - Database SQL Tables needed for SQL Micro Teach
  Internet - Text Based SQL tutor
  Internet - On-line SQL web tutor ( login name GUEST - password GUEST1)
Recap / Assessment: Week 12 - Lesson Recap Assessment
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
Week 13 - ( w/b 3rd Dec) - Further DML
Lesson Plan: Week 13 - Plan
Lesson Aims: Week 13 - Aims
Class Materials Used: Micro Teach 01 - Further DML - (computers Harder 15-22)
  Micro Teach 02 - Further DML- (ships Harder 36-54)
  Download - Database SQL Tables needed for SQL Micro Teach
Recap / Assessment: Week 13 - Lesson Lesson Recap Assessment
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
   
Week 14 - ( w/b 10th Dec) - SQL Zoo
Lesson Plan: Week 14 - Plan
Lesson Aims: Week 14 - Aims
Class Materials Used: Internet - SQL Zoo - FANTASTIC LEARNING RESOURCE - Use it !
  Micro Teach 01 - SQL Zoo On-Line exercises
Recap / Assessment: Week 14 - Lesson Recap Assessment
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
  Micro Teach 03 - More Difficult DML tasks
  Downloads - Database Tables needed for SQL Micro Teach
  Solution - SQL Zoo On-Line exercises
  Notes - Using multiple tables
  Notes - Advanced SELECT statements
Week 15 - ( w/b 17th Dec) - Really Hard DML
Lesson Plan : Week 15 - Plan
Lesson Aims: Week 15 Aims
Class Materials Used: Micro Teach 01 - Really Hard DML - (computers Harder 15-22)
Recap/Assessment Week 15 - Lesson Recap Assessment
More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
   
Christmas Holiday
Week 16 - ( w/b 7th Jan) - Assessment Task 3 and 5 - SQL ( P4, P5, M3 )
Lesson Plan: Week 16 - Plan
Lesson Aims: Week 16 - Aims
Class Materials Used: Notes - Data Mining
  On-Line Link - Data Mining (Very Useful)
  Notes - Data Mining Definitions from the web
  Presentation - Data Mining Background
  Micro Teach 01 - Simple Class Register
  download - Class register solution
  Assessment 13.3 - SQL presentation - TIPS
IVA Assessment - Consolidation what needs to be done
  IVA - exercise - CASE study for the assessment
Recap / Assessment: Week 16 - Lesson Recap Assessment
   
 More Background / Reading: Why not visit the ACCESS LIBRARY if you get stuck when using Microsoft Access
Week 17 - w/b 14th Jan - Assessment 13.3 tips - Create Tables DDL tutorial
Lesson Plan: Week 17- Plan
Lesson Aims: Week 17 - Aims
Class Materials Used:  Notes - Thought Shower Assessment
  Notes - Tips for DDL part of Assessment
  class work - SQL scripts
  Assessment 13.3 - Cover Sheet
 More Background / Reading: Micro Teach 01 - Create tables / Queries for Assessment
  Notes - Data Types used in Access SQL
  Micro Teach 02 - case study/ tables needed for Assessment
  Micro Teach 03 - Insert Data into tables for Assessment
  IVA - exercise - CASE study for the assessment
Recap / Assessment: Week 17 - Lesson Recap
 More Background / Reading:  
Week 18- w/b 21st Jan - Data Mining / SQL Assessment 13.3 completsubmission
Lesson Plan : Week 18 - Plan
Lesson Aims: Week 18 Aims
Class Materials Used: 
IVA Assessment - Consolidation what needs to be done
  Notes - Suggestions for DDL Write Up
  IVA - exercise - CASE study for the assessment
Recap/Assessment Week 18 - Lesson Recap Assessment
More Background / Reading: 
 Notes - First Normal Form -Job Seeker example
  Notes - First Normal Form - grades example
  Notes - First Normal Form - training centre example
Week 19 - w/b 28th Jan - Normalisation - First Normal Form
Lesson Plan: Week 19 - Lesson Plan
Lesson Aims: Week 19 - Aims
Class Materials Used: PowerPoint - Normalisation Lecture
  PowerPoint - 1st Normal Form
  Group Work Exercise - Sandwich Business 1NF
  Solution - Sandwich Business 1NF
  Micro Teach - Video Rental 1NF
  Solution - Video Rental 1NF
  Micro Teach - Student Card 1NF
  Solution - Student Card 1NF
  Micro Teach - Job Seekers Form 1NF
  Solution - Job Seekers Form 1NF
Recap / Assessment: 1NF - Recap Assessment
More Background/ Reading: Additional Notes - Normalisation
Week 20 - w/b 4th Feb - Normalisation - Second Normal Form
Lesson Plan:  
Lesson Aims:  
Class Materials Used: Assessment Tip - Exisitng System LDM write up
  PowerPoint - Recap 1NF
  Recap - Last Weeks 1NF Lesson
  Solution - Last Weeks 1NF Lesson
  PowerPoint - 2nd Normal Form
  Micro Teach - Job Seeker 2NF
  Solution - Job Seeker 2NF
  Micro Teach - Student Card 2NF
  Solution - Student Card 2NF
Recap / Assessment:  
More Background/ Reading: Additional Notes - Worked Example - Training Centre 2NF
  Additional Notes - Worked Example Grades 2NF
Week 21- w/b 11th Feb - Normalisation 3
Lesson Plan : Week 20 - Plan
Lesson Aims: Week 21 - Aims
Class Materials Used: Powerpoint - Normalisation - 3NF Lesson
  Micro Teach 01 - Third Normal Form - job seekers registration
  Micro Teach 02 - Third Normal Form -
  Micro Teach 02 - case study/ tables needed for Assessment
  Notes - Normalisation class example 2nd & 3rd Normal Form
  Powerpoint - Normalisation - 2NF Lesson
  Powerpoint - Normalisation - 3NF Lesson
  Exercises - Second normal form
  Exercises - Third Normal form
 ASSESSMENT HELP
 Micro Teach 01- IVA Assessment Task 13.2 - Normalisation (evidence criteria P2, P3, M1, M2)
Recap/Assessment Week 21 - Lesson Recap Assessment
Recap/Assessment Week 20 - Lesson Recap Assessment
 More Background / Reading:
 Notes - ThirdNormal Form - grades example
  Notes - ThirdNormal Form - training centre example
  Notes - Full Normalisation Student Record Card
  Notes - Full Normalisation Cast of Characters Example
Winter Half Term
w/b 11th Feb Week 21 - Assessment Task 2 - SQL ( P2, P3, M1, M2)
Lesson Plan : Week 21 - Plan
Lesson Aims: Week 21 Aims
w/b 25th Feb Week 22 - Data Dictionary
Lesson Plan : Week 22 - Plan
Lesson Aims: Week 22 Aims
Class Materials Used: Notes - What is a Data Dictionary
  Internet Link - Data Dependency Diagrams
Recap/Assessment Week 22 - Lesson Recap Assessment
   
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
  Notes - MORE HELP and IVA related NOTES ( remember to log in to CBCT )
w/b 3rd March Week 23 - Integrity Constraints
Lesson Plan : Week 23 - Plan
Lesson Aims: Week 23 Aims
   
Class Materials Used:  
   
Recap/Assessment Week 23 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 10th March Week 24 - Database Integrity (M2)
Lesson Plan : Week 24 - Plan
Lesson Aims: Week 24 Aims
Class Materials Used: Activity 01 - Thought Shower - predicting fields and validation
  Activity 02 - Update tables to include validation
  Activity 03 - Exercise - Data Integrity
  PowerPoint - Integrity
  Activity 04 - applying integrity
 ASSESSMENT HELP
 Micro Teach 01- IVA Assessment Task 2 - Normalisation (evidence criteria P2, P3, M1, M2)
Recap/Assessment Week 24 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 17th March Week 25 -
Lesson Plan : Week 25 - Plan
Lesson Aims: Week 25 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 25 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
Easter Holiday
w/b 7th April Week 26 -
Lesson Plan : Week 26 - Plan
Lesson Aims: Week 26 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 26 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
Easter Holiday Break
w/b 14th April Week 27 -
Lesson Plan : Week 27 - Plan
Lesson Aims: Week 27 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 27 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 21st April Week 28 -
Lesson Plan : Week 28 - Plan
Lesson Aims: Week 28 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 28 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 28th April Week 29 -
Lesson Plan : Week 29 - Plan
Lesson Aims: Week 29 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 29 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 5th May Week 30 -
Lesson Plan : Week 30 - Plan
Lesson Aims: Week 30 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 30 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 12th May Week 31 -
Lesson Plan : Week 31 - Plan
Lesson Aims: Week 31 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 31 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 19th May Week 32 -
Lesson Plan : Week 32 - Plan
Lesson Aims: Week 32 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 32 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
Spring Bank Holiday Week W
w/b 2nd June Week 33 -
Lesson Plan : Week 33 - Plan
Lesson Aims: Week 33 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 33 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 9th June Week 34 -
Lesson Plan : Week 34 - Plan
Lesson Aims: Week 34 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 34 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
w/b 16th June Week 35 -
Lesson Plan : Week 35 - Plan
Lesson Aims: Week 35 Aims
Class Materials Used: Notes - 01 -Databases and Models
   
   
Recap/Assessment Week 35 - Lesson Recap Assessment
 More Background / Reading: Resource - ACCESS LIBRARY more places to go if you get stuck
Additional Resources Useful Notes & Tutorials
 
 PowerPoint -  database 08 the web and databases
 
 PowerPoint -  database 09 asp
 
 PowerPoint -  database 10 advanced asp
   PowerPoint -  database 11 security
   Activity -  How to make a Pop Up Calendar
   Activity - Pop Up Calendar Example
   Activity - How to Build a Date Combo Box 1
   Activity - How to Build a Date Combo Box 2
   Activity - Combo Box Date Example
   Activity - How work out Age from the DOB
   Notes - Logical Data Modelling 1
   Notes - Logical Data Modelling 2
 
   Notes - Logical Data Modelling 4