SWEN304 (2020) - Database System Engineering

Prescription

The course addresses fundamental principles underlying databases and database management systems. It covers the structure and principles of the relational data model, including SQL, and the principled design of the relational database schema. It also addresses issues in database transaction procession, concurrency control, recovery, and the complexity of query processing.

Course learning objectives

Students who pass this course will be able to:

  1. Demonstrate understanding of the principles of database systems generally and the relational database model specifically;
  2. Set up, query, and update a relational database using interactive SQL;
  3. Set up, query, and update a relational database using a transaction program written in Java;
  4. Explain the basic principles and common trade-offs in designing a relational database, and to design it;
  5. Explain the basic principles and common trade-offs in relational database query optimization;
  6. Explain the basic principles of database concurrency control and recovery, and implement them within a transaction program.

Withdrawal from Course

Withdrawal dates and process:
https://www.wgtn.ac.nz/students/study/course-additions-withdrawals

Lecturers

Hui Ma (Coordinator)

Teaching Format

During the trimester there will be three lectures per week. Some lecture times will be used for tutorials.

Student feedback

Student feedback on University courses may be found at:  www.cad.vuw.ac.nz/feedback/feedback_display.php

Dates (trimester, teaching & break dates)

  • Teaching: 02 March 2020 - 07 June 2020
  • Break: 13 April 2020 - 27 April 2020
  • Study period: 08 June 2020 - 11 June 2020
  • Exam period: 12 June 2020 - 27 June 2020

Class Times and Room Numbers

02 March 2020 - 22 March 2020

  • Monday 16:10 - 17:00 – LT323, Hunter, Kelburn
  • Tuesday 16:10 - 17:00 – LT323, Hunter, Kelburn
  • Thursday 16:10 - 17:00 – LT323, Hunter, Kelburn
27 April 2020 - 28 June 2020

  • Monday 16:10 - 17:00 – , , Kelburn
  • Tuesday 16:10 - 17:00 – , , Kelburn
  • Thursday 16:10 - 17:00 – , , Kelburn

Other Classes

There will be helpdesk sessions starting in week 3 in one of the school labs - details to be announced.

Required

The textbook for SWEN 304 is:

  • R. Elmasri and S. Navathe, Fundamentals of Database Systems; 6th/7th edition, Pearson/Addison Wesley, 2014/2015.

Mandatory Course Requirements

In addition to achieving an overall pass mark of at least 50%, students must:

  • achieve at least 40% of the overall marks for projects and assignments (i.e. 40%*45 marks), to demonstrate achievement of all the CLOs of the course.
  • achieve at least a D grade for the final examination.

If you believe that exceptional circumstances may prevent you from meeting the mandatory course requirements, contact the Course Coordinator for advice as soon as possible.

Assessment

This course will be assessed through assignments, projects and final examination.

Assessment ItemDue Date or Test DateCLO(s)Percentage
Assignment 1Week 5CLO: 110%
Assignment 2Week 8CLO: 55%
Assignment 3Week 11CLO: 45%
Project 1Week 7CLO: 215%
Project 2Week 12CLO: 3,610%
Final Examination (2 hours)CLO: 1,2,3,4,5,655%

Penalties

Any assignment or project submitted after the due date will be penalized at the rate of 5% per day. Assignments that are more than one week late will not be marked.

Extensions

Approval to submit assignments and projects late without penalty will only be granted in exceptional circumstances whenever possible arranged prior to the due date. Medical and other excuses may be accompanied by a doctor's certificate.

Submission & Return

Unless otherwise instructed, assignments may be submitted via the SWEN 304 assignment box on level 2 of the Cotton Building or the School's electronic submission system, and projects should be submitted via the electronic submission system. Marks and comments will be returned through the ECS marking system or via the course web pages.

Workload

In order to maintain satisfactory progress in SWEN 304, you should plan to spend an average of 10 hours per week on this paper, which includes attending lectures, solving homework assignments, doing practical work, additional reading, and reviewing lecture material.

Teaching Plan

See: https://ecs.wgtn.ac.nz/Courses/SWEN304_20120T1/LectureSchedule

Communication of Additional Information

The main means of communication outside of lectures will be the SWEN 304 web area at https://ecs.wgtn.ac.nz/Courses/SWEN304_2020T1/. There you will find, among other things, this document, the lecture schedule and assignment handouts, and the SWEN 304 Forum. The forum is a web-based bulletin board system. Questions and comments can be posted to the forum, and staff will read these posts and frequently respond to them.

Offering CRN: 17186

Points: 15
Prerequisites: COMP 261 or SWEN 221; ENGR 123 or MATH 161
Duration: 02 March 2020 - 28 June 2020
Starts: Trimester 1
Campus: Kelburn