Archive for the ‘BIT’ Category

WDFB Assessment

September 22nd, 2014 No comments

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.

TP1: Assignment

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.

Categories: BIT Tags:

BITS week 10

December 2nd, 2013 No comments

Slides on problems with the relational model, functions and grouping database 5 2011 handouts

Lab exercise SQL Session 5

Categories: BIT Tags:

BITS week 8 and 9

November 18th, 2013 No comments

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

Categories: BIS, BIT, Databases Tags:

BITS week 7

November 11th, 2013 No comments

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

Categories: BIT, Databases Tags:

BITS week 6

November 4th, 2013 No comments

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

Categories: BIT, Databases Tags: ,

BB5104 Web Development for Business Assessment 1

October 15th, 2013 No comments

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

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

Categories: BIT Tags:

BITS week 3

September 30th, 2013 No comments

These are the materials for week 3 of the BITS course

Lecture Materials

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 Materials

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

Categories: BIT Tags:

BITS week 2

September 23rd, 2013 No comments

These are the materials for week 2 of the BITS module

Lecture Materials

lecture 2 handout

Good resource with explanations about using images

Lab Materials

Lab 2

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



Categories: BIT Tags:

Relational Databases – Functions, Grouping and sub-queries

February 20th, 2012 No comments

Lecture materials on Functions, Grouping and sub-queries database 5 2011 handouts

Lab material on Functions, Grouping and sub-queries SQL Session 5

Categories: BIT, Databases Tags:

Relational Databases – other operations and DDL

February 9th, 2012 No comments

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

Categories: BIT, Databases Tags: