Assessment in this module is by two in-class tests and two assignments. This page will be updated with full tips and hints for the tests, along with more details about the assessments closer to the dates given.
Teaching Period One
Assessment in TP1 is by an in-class test and an assignment.
TP1: In-class test
Test One will be on Thursday October 20th 2016. A guidance sheet about the test is here: PHP test student guidance.
This will be discussed in detail in class the weeks leading up to the test.
Details for the first assignment are as follows – You will collate the in-class activities and online exercises into a single Word document, which you submit using the digital dropbox in studyspace.
The course work is described fully here: bb5104-assignment
The hand in date is Wednesday 11th January @ 9:00. Work will submitted to the dropbox in studentspace.
You should hand in a single word document, structured into weeks which represent each part. There should be a cover sheet, a table of contents and the solutions.
Teaching Period Two
Assessment in TP2 is by an in-class test and an assignment. Dan will place details on the in-class test and the assignment in studyspace.
Test Two will be on Thursday, 2 February 2017.
The teaching period two assessment consists of an essay and has a hand in date of Monday, 27 March 2017.
Slides on problems with the relational model, functions and grouping database 5 2011 handouts
Lab exercise SQL Session 5
Lecture slides on Cartesian Product and Join – database 3 2011 handouts
Lab exercise on CP and Join – SQL Session 3
More advanced Joins –database 3 join extra 2007 3 slides handouts
Lab exercises on more advanced Joins –SQL SESSION OUTER
Lecture slides on writing queries for dummies – database 4 2007 handouts
Lab exercises on DDL/DML – SQL Session 4
Material for BITS week 7
Slides on TCP/IP
Slides on selection in RA and SQL database 2 2007 handouts 3 slides
Lab notes and exercises SQL Session 2
This weeks materials are an introduction to database systems and the relational model
The lecture slides used for the first session on databases relational database handout slides
SQL file required to set up the EMP database in mySQL empDB
SQL notes on using mySQL and the projection statement SQL Session 1
Notes on setting up your own version of MAMP (mac) Installing and using MAMP
Notes on setting up your own version of XAMPP (Windows 7) Installing and using XAMPP
The first assessment for this module is presented in four parts and involves creating a PHP/MYSQL solution for a module evaluation questionnaire system.
Part One is about creating the initial user form and response page – detailed Assignment part 1
Part Two is all about creating a table to store the results from the form in part one – Assignment part 2
Part Three asks you to create the relevant parts of CRUD for the assignment – Assignment part 3
Part Four asks you to create an authentication system and a summary statistics page – Assignment part 4
You will submit this work through a drop box in blackboard, as a SINGLE word document, which should include explanations of your design, screenshots and code. For instructions on how to write a correctly structured report, use the techniques in this post
The SINGLE word document is to be submitted through a dropbox on studyspace on Thursday 22nd January 2015 @ 9:00 AM GMT.
Erasmus students who are only here for the first teaching period (i.e they leave before Christmas) have a slightly different process – they only have to do parts 1 – 3 above and should submit their work on Monday 15th December, into the special Erasmus dropbox in studyspace
These are the materials for week 3 of the BITS course
lecture 3 handouts in colour with 3 slides per page
files for lecture contains the examples from the slides (in a zip file – you will need to extract the contents to use these files)
css cribsheet from Phil Molyneux
Lab 3 exercise sheet
The compressed zip file lab3 is available for the lab activity
About the first assessment
XHTML assign student guidance contains information about the first lab test
These are the materials for week 2 of the BITS module
lecture 2 handout
Good resource with explanations about using images
Word document 1: campus
Word document 2: about
The compressed zip file wordHTML is available for the third activity
Images – use a right mouse click to download these
Lecture materials on Functions, Grouping and sub-queries database 5 2011 handouts
Lab material on Functions, Grouping and sub-queries SQL Session 5
Slides for this sesssion database 4 2011 handouts
Lab exercise on the DDL and DML SQL Session 4
Slides on different type of Join Slides on Outer, Left, Right Join
Lab Notes on the Outer Join SQL SESSION OUTER