SOFTENG351

https://www.se.auckland.ac.nz/courses/SOFTENG351/

Fundamentals of Database Systems

Assessment

Assignments 20%, Test 10%, Exam 70%. You must pass both theory and practical.

Organisation

Gill will lecture the first 6 weeks:

• Lectures Mon, Tues, Wed 9-10,
• Tutorial Thurs 9-10,
• Lab Fri 3-5.

Gerald will lecture the second 6 weeks.

Description

This course is about database management systems. It covers data organisation, query processing, transactions and advanced database concepts.

Contents

Relational model, Relational Algebra, Relational Calculus, SQL, SQL and Programming Languages, Entity Relationship Model, Normalization, Query Processing and Query Optimization, Transaction Management, Distributed Databases, Persistent Messaging, Enterprise Computing, Data Warehouses, Information Retrieval Coursework

• Assignment 1 due date Mon 3 April 10%,
• Assignment 2 due date Mon 15 May 5%,
• Assignment 3 due date Mon 29 May 5%,
• Test Tues 9 May 9-10am (in lecture) 10%.

Recommended Textbook

• Database Management Systems, 3ed, Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 2003.
• Foundations of Database Systems, 4th, Elmasri and Navathe, Addison Wesley, 2004.
• Data on the Web: From Relations to Semistructured Data and XML, Serge Abiteboul, Peter Buneman, and Dan Suciu, Morgan Kaufmann, 2000.

Related Reading

Library and web resources will be indicated, along with some handouts in lectures.

Lecturers

Associate Professor Gill Dobbie(Course Coordinator) Dr Gerald Weber