Archive

Archive for November, 2010

ITB week 9

November 30th, 2010 No comments

Database notes (lecture and lab material) here

Spreadsheet material here

Note on the Second ITB test are here

Database Systems Week 9

November 29th, 2010 No comments

First part demonstrated the problems inherent in flattening trees into relational table

Followed by the definite DB approach – the log file of the demonstration is available (text file)

Closed World Assumption (CWA) and Negation as Failure (NAF) were covered next.

Categories: Databases Tags:

Database Systems Week 8

November 29th, 2010 No comments

Material this week:

Query resolution (SLD resolution) on definite databases – building query trees / evaluating

The Datalog Educational System can be downloaded for most platforms – the Windows executable can use the ODBC interconnectivity layer to connect to Access database files.

Some of the query resolution material (in a different form) can be seen in Elmasri, R., Navathe, S., Database Systems, 6th Ed.: Chapter 24 pp. 906-920

Categories: Databases Tags:

Web Scripting for Applications Week 9

November 25th, 2010 No comments

Lecture slides used during the class lecture 9

Working code for lab/lecture and exercises Working versions lab9

Exercises for this week PHP exercises 9

Categories: Programming Tags:

ITB week 8

November 23rd, 2010 No comments

HTTP clients and servers lecture slides

Database materials on Cartesian Product

Spreadsheet materials on importing different types of data, grouping and subgroups

This article is about the early (pre netscape) browsers that became available and promoted the WWW.

Database Systems Week 7

November 22nd, 2010 No comments

Covered the following subjects

Using logic to model the RDB

The Model Theoretic approach

The Proof Theoretic approach

Recasting RDBs into First Order Logic, and why the full expressiveness isn’t really required

Clausal Form: clauses, definite clauses, assertions, goal clauses and Horn clauses

Harland article: An Introduction to Deductive Database Language and Systems

The Datalog Educational System can be downloaded for most platforms – the Windows executable can use the ODBC interconnectivity layer to connect to Access database files.

There is a good introduction to this material in Elmasri, R., Navathe, S., Database Systems, 6th Ed.: Chapter 24 pp. 906-920

Categories: Databases Tags:

Web Scripting for Applications Week 7

November 18th, 2010 No comments

In the lab

This lab is all about developing a CRUD system for the EMP database table set up in week 6 – the initial code required is in this zip file. Extract the file, ensuring that you maintain the directory structures given.

You will be shown how to wire this code up in class

Exercises

The exercises take you through setting up a small web site using folders, CSS and other techniques

Exercises: PHP exercises

Code for exercises: code

Categories: Programming, Web Tags:

ITB week 7

November 16th, 2010 No comments

Materials on Databases, including lecture notes and lab exercise on selection

Spreadsheet materials on building larger spreadsheet models, and more complex formulas / functionality

Web Scripting for Applications Week 6

November 11th, 2010 No comments

Materials for first week back ..

Lecture 6 on mysql and php/phpmyadmin

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

empform code empform.php

Here are some SQL insert statements that may be useful:

insert into emp (empno,ename,sal) values (120, “SMITH”, 22000);
insert into emp (empno,ename,sal) values (121, “JONES”, 23000);
insert into emp (empno,ename,sal) values (122, “AVERY”, 22500);
insert into emp (empno,ename,sal) values (124, “MITCHELL”, 26000);
insert into emp (empno,ename,sal) values (127, “WEBB”, 22000);
insert into emp (empno,ename,sal) values (129, “TENNENT”, 22000);
insert into emp (empno,ename,sal) values (130, “RUSSELL”, 25000);

Exercise for lab: PHP exercise

Code for lab: codeforlab1

Categories: Programming, Web Tags: ,

ITB week 6

November 9th, 2010 No comments

ITB switches to material about spreadsheets and databases from week 6, along with lectures about Internet standards.

Database materials for this week include the lecture slides and the lab exercises

Spreadsheet materials for this week include the lecture slides and the lab exercise