CT233 Information Systems, 2004

Lecturer: Josephine Griffith

Lecture Times:

Thursday 3 - 5 Room IT204, IT Building

Lab Times:

Tuesday, 11-1 in Corrib Suite

Lab tutor is Seamus Hill

Course Outline:

• Data, Information & Database Systems
• DBMS: architectures, independence, models
• Storage
• Relational Model
• Design and ER Modelling
• Relational Algebra
• SQL
• File Organisations
• Query Processing and Optimisation
• MS Access
• Web Technologies
• Information Retrieval

Lab Work:

• Lab Assignment 1 Due: 12-02-2004 in lecture.
• Lab Assignment 2 Due: 02-03-2004 at lab.
• Lab Assignment 3 Due: 16-03-2004 at lab. See also MS Access Forms and Reports Information.
• Lab Assignment 4 Due: 01-04-2004 . Please leave in my mail slot.

Recommended Books:

• John Carter Database Design and Programming with Access, SQL and Visual Basic
• Elmasari and Navathe Fundamentals of Database Systems
• Ramakrishnan and Gehrke Database Management Systems

Exam Information:

CT233 is a 2 hour paper, with 5 questions, to answer any 3 questions. Results of CT232 (from semester 1) are combined with the results of CT233.

Some Previous Exam Papers CT233 corresponds to Section B from paper CS206 in the year 2000 and Section B cs201 paper 2 in the year 1999.

• CT233, Summer Exam Paper, 2003 (pdf Format).
• CT233, Summer Exam Paper, 2001 (Word Format).
• CS206, Summer 2000 (MS Word format)
• CS201, Paper 2, Summer 1999 (MS Word format)