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