Course syllabus

Course Prescription

Managers and other knowledge workers find that many of their duties revolve around accessing, organising, and presenting organisational and external information. The ability to develop and use computer databases is becoming a critical skill that is required in many disciplines. These skills are developed through an introduction to data modelling, relational theory, database design, and the management of databases

Programme and Course Advice

Prerequisite: INFOSYS 110 or 120, or COMPSCI 105 or 107
Restriction: INFOMGMT 292

Goals of the Course

This course aims to develop the fundamental skills of designing and developing a relational database. All assessments require student to demonstrate their mastery of the practical aspects of the course including data modelling and structured query language (SQL)

Learning Outcomes

By the end of this course it is expected that the student will be able to:
1. understand the fundamental concepts of relational database;
2. design a relational database;
3. implement a relational database;
4. define and manage data from a relational database;
5. understand transaction management in a relational database; and
6. understand the fundamental concepts of a data warehouse

Content Outline

Week Content
01 Introduction
02 Relational model
03 ER modelling
04 Data modelling
05 Data modelling
06 Normalisation
07 SQL
08 SQL
09 SQL
10 DBMS fundamentals
11 Data warehouse
12 Review

Learning and Teaching

Student must attend three 1-hour lectures and one 1.5-hour lab per week. In addition, student should be prepared to spend about another six hours per week on activities related to this course. These activities include reading, practicing, and preparing for assessments

Teaching Staff

Lecturer
Johnny Chan | jh.chan@auckland.ac.nz

Coordinator
Udayangi Muthupoltotage | u.muthupoltotage@auckland.ac.nz

Learning Resources

  • Greenspun. (1998) SQL for Web Nerds. philip.greenspun.com/sql
  • Allen and Owens. (2010) The Definitive Guide to SQLite. New York: Apress. Available from the library

Additional material will be posted in Canvas

Assessment

The detail of each assessment will be provided as the course proceeds

Assessment Weighting Learning Outcome
Assignment 01 15% 1–2
Assignment 02 15% 3–4
Test 20% 1–4
Exam 50% 1–6

This course requires student to pass both the internal and the exam

Inclusive Learning

Student should discuss privately any impairment-related requirements face-to-face and/or in writing with the coordinator

Student Feedback

Student will be asked to complete course and teaching evaluations at certain point of the course

Course summary:

Date Details Due