2003/11/01 Exam notes
You will need the following for exams:
From the text book: Chapters 1-6,9 and 14 ( only up until section 14.8). Ch13 ( data warehousing up to 13.4)
Practials: Anything covered in practicals
PostgreSQL User's Guide (see the
link at the bottom of the page).
Chapter 1
Chapter 2 - excluding section 2.7 and above.
Chapter 3
Chapter 4
Chapter 5 - excluding Section 5.7 and above
Chapter 6 - Section 6.1-6.6, 6.14. 6.15 is recommended and offers some ways for constructing more elegant queries
Chapter 8 - Sections 8.1-8.4
Chapter 9 - excluding sections 9.4 and 9.5
2003/09/18 - Final Prac Solutions Available
Solutions to the final practical are available.
2003/09/05 - Course complete
The course is now complete. LAst few slides have been made available. Tests may be collected form the Secretaries..
2003/09/04 - Slides, pracs etc..
Following feedback received all the PDF documents have been re-generated so they work with Acrobat 4. Anyone having problems accessing these should please contact me. The last few course slides, and Test Solutions are also available.
2003/09/04 - Test Results
Tests are marked, and will be available from the lecture tomorrow. The quick breakdown is available below.
2003/09/03 - Evaluation
Please complete the course evaluation which can be found here. Thanks to those people that completed
2003/09/02 - Test
A reminder that the final Module test will be held during the lecture period tomorrow (Wednesday), please ensure you bring a PEN. Material that is covered in the test is as follows:
From the text book: Chapters 1-6,9 and 14 ( only up until section 14.8).
SQL Knowledge: As detailed in the entry below
Practials: Anything covered in practicals up to and including last weeks.
The final Lecture slides for E-Commerce will be made available this afternoon, as will the solutions for practical 2.
2003/08/29 - Module Test
Lecture slides have been made available for the sections covered so far. A reminder about the Test on Wednesday next week in 5th Period (Regular Lecture slot). The test will be 45 minutes long, and counting 45 marks. Test will cover the
Entire course, up until what is covered on Tuesday's lecture. This includes all the SQL related skill and theory. It is suggested that some time is spent reading through the PostgreSQL user guide chapters as indicated below.
2003/08/27 - Exercise
Try this
exercise. Solutions will be released tomorrow. Got an idea for an exercise, drop me an email.
2003/08/27 - Reminder
A reminder to everyone to please read the practical cover sheets carefully. Pay special attention to the fact you are not to work in groups. If you do work with other people in solving problems, you are required to acknowledge this. One solution is develop your answers in point form, and then flesh out the fuller paragraphs on your own.
2003/08/26 - SQL Knowledge
In preparation for the next test and the exam, it is suggested that you read the following sections from the PostgreSQL User's Guide (see the link at the bottom of the page).
Chapter 1
Chapter 2 - excluding section 2.7 and above.
Chapter 3
Chapter 4
Chapter 5 - excluding Section 5.7 and above
Chapter 6 - Section 6.1-6.6, 6.14. 6.15 is recommended and offers some ways for constructing more elegant queries
Chapter 8 - Sections 8.1-8.4
Chapter 9 - excluding sections 9.4 and 9.5
2003/08/25 - Test Results
Tests are marked, and will be available from your tutors on Wednesday. The quick breakdown is available below.
2003/08/22 - Extreme programming
For those of you interested in the Extreme programming methodology the following links contain more detail.
Extreme Programming: A Gentle Introduction.
XProgramming.com - an Extreme Programming Resource
Google Directory of Extreme Programming
2003/08/19 - Test Dates
There will be a short test on Monday 25th August 2003, covering chapters 1-5, and what has been discussed in Lectures. Test format will be a combination of multiple choice and short answer questions totaling 35 Marks. This should give you an idea of the format and style to be used in the Module Test on the 3rd of September, and the Exam.
Some second-hand textbooks are available
New textbooks are available from UPB
) or in Rm 27 Hamilton Building