This material is used on the GIT course (BB2001).
Lecture slides (lock and unlock)
lock handouts in colour, lock handouts in black & white
unlock handouts in colour, unlock handouts in black and white
Lab handouts (used in the subsequent week)
but not necessarily in the correct order
This material is used on the GIT course (BB2001).
Lecture slides (lock and unlock)
lock handouts in colour, lock handouts in black & white
unlock handouts in colour, unlock handouts in black and white
Lab handouts (used in the subsequent week)
Full details of the assessment can be seen in Assignment (PDF)
Hints and tips about structuring the report can be seen in this post/document
This work should be done in pairs and submitted as a single word document, with all code, diagrams and data examples included in the document.
The hand-in date/time is 2nd May 2011 at 6:00pm. Electronic submission (only) is required – either through the digital drop box or using the email address barryavery65@gmail.com
You submit one document per group. If you submit by email I will email you back so you know its arrived (probably the next day in the morning).
Here are the slides on Database Design Methodology which are very heavily based on the Chapters from the Database book by Connolly & Begg.
This is really only a summary – you need to read the chapters on Conceptual, Logical and Physical design in the book.
Database Design slides
This zipped text file contains three SQL blocks which should create and populate the EMP, DEPT and GRADE tables in SQL compliant databases
It contains three blocks that look like this
// create table SQL
create table emp (
empno int,
… etc.
);
// Lines to insert tuples into the table created above
insert into emp values (405,”MARCH”,”ADMIN”,938,”13/06/1997″,18000,null,2);
insert into emp values (535,”BYRNE”,”SALES”,734,”15/08/1997″,26000,300,3);
etc..
Results for ITB test 2 (Spreadsheets and database test) are shown on the following PDF file.
Test 1 was the HTML test (worth 10%), Test 2 is the spreadsheet and database test from last week. Both columns are percentages. Note that results are subject to moderation and final checking
BB1753 ITB 1213 (PDF file)
All the previous exam paper questions are available in a Web Scripting for Applications Revision Pack.
Remember that this is the first year this module has run, so the paper has a different structure to any previous second year module (details in the document above).
A solution for one of the questions is in this web scripting solution (was covered in the micro revision sessions that took place in each lecture before christmas)
Slides for today: lecture 10 php 5
Sample code used in lab: lab10 code (zip file)
Completed (working code) for morning completedlab10
Class employee example class.Employee.php
lecture notes on MVC
MVC Code examples used in the lecture notes
This session covers Open Source and Free Software and talks about the similarities and differences between them. Notes are here
The second part finishes the database material and covers problem with the relational model, functions, grouping and subqueries, notes are here
Additional notes about the assignment are here – all the other material about the assignment are here
For those that missed the discussion or the link last week, information about the second test is here
This document explains the tips and techniques that can be used to structure and format a Word document so that it looks appropriate. It is expected that assignment work for Information Technology for Business (Level 4) and Web Scripting for Applications (Level 5), will use these techniques.
Correctly structuring and presenting a document
Referencing (which is mentioned on Page 7 of the handout), should use the appropriate referencing style, which for Kingston University is discussed in Harvard Referencing for Business students. This is a locally stored version – check the link for the latest version (login required).
PHP lab exercises for this week along with code needed for exercise
Class code examples used in the Lecture