COSC265-23S2 (C) Semester Two 2023

Relational Database Systems

15 points

Details:
Start Date: Monday, 17 July 2023
End Date: Sunday, 12 November 2023
Withdrawal Dates
Last Day to withdraw from this course:
  • Without financial penalty (full fee refund): Sunday, 30 July 2023
  • Without academic penalty (including no fee refund): Sunday, 1 October 2023

Description

An introduction to database systems, database design, relational databases and database management systems.

2022 Covid-19 Update: Please refer to the course page on AKO | Learn for all information about your course, including lectures, labs, tutorials and assessments.

The course deals with data models and database systems and has been designed to enable you to understand the theoretical basis of databases and be able to apply that knowledge in developing and using relational databases. The lectures are organized around the database design lifecycle, while in the labs students go through the process of developing small databases from given requirements. This course is a prerequisite for SENG365 (Web Computing Architectures).

Learning Outcomes

  • Students who achieve a good grade in the course should be able to:
  • Understand the role of database systems in software applications
  • Understand the database design lifecycle
  • Design conceptual database schemas starting from requirements
  • Use SQL to implement, query, populate, update and manage databases
  • Normalize relational databases
  • Design physical schemas to achieve good performance
  • Understand and use a DBMS.

Prerequisites

Timetable 2023

Students must attend one activity from each section.

Lecture A
Activity Day Time Location Weeks
01 Monday 09:00 - 10:00 C2 Lecture Theatre 17 Jul - 27 Aug
11 Sep - 22 Oct
Lecture B
Activity Day Time Location Weeks
01 Tuesday 10:00 - 11:00 C3 Lecture Theatre 17 Jul - 27 Aug
11 Sep - 22 Oct
Lecture C
Activity Day Time Location Weeks
01 Wednesday 12:00 - 13:00 C2 Lecture Theatre 17 Jul - 27 Aug
11 Sep - 22 Oct
Computer Lab A
Activity Day Time Location Weeks
01 Friday 11:00 - 13:00 Jack Erskine 133, 134 17 Jul - 23 Jul
31 Jul - 6 Aug
14 Aug - 27 Aug
11 Sep - 8 Oct
02 Tuesday 11:00 - 13:00 Jack Erskine 133, 134 17 Jul - 23 Jul
31 Jul - 6 Aug
14 Aug - 27 Aug
11 Sep - 8 Oct
03 Monday 11:00 - 13:00 Jack Erskine 133, 134 17 Jul - 23 Jul
31 Jul - 6 Aug
14 Aug - 27 Aug
11 Sep - 8 Oct
Tutorial A
Activity Day Time Location Weeks
01 Friday 11:00 - 13:00 Jack Erskine 315 24 Jul - 30 Jul
7 Aug - 13 Aug
9 Oct - 22 Oct
02 Friday 11:00 - 13:00 Jack Erskine 111 24 Jul - 30 Jul
7 Aug - 13 Aug
9 Oct - 22 Oct
03 Tuesday 11:00 - 13:00 Jack Erskine 315 24 Jul - 30 Jul
7 Aug - 13 Aug
9 Oct - 22 Oct
04 Tuesday 11:00 - 13:00 Jack Erskine 101 24 Jul - 30 Jul
7 Aug - 13 Aug
9 Oct - 22 Oct
05 Monday 11:00 - 13:00 Jack Erskine 315 24 Jul - 30 Jul
7 Aug - 13 Aug
9 Oct - 22 Oct
06 Monday 11:00 - 13:00 Jack Erskine 441 24 Jul - 30 Jul
7 Aug - 13 Aug
9 Oct - 22 Oct

Examination and Formal Tests

Test A
Activity Day Time Location Weeks
01 Thursday 19:00 - 20:30 Jack Erskine 010 Computer Lab 2 Oct - 8 Oct
02 Thursday 19:00 - 20:30 Jack Erskine 001 Computer Lab 2 Oct - 8 Oct
03 Thursday 19:00 - 20:30 Jack Erskine 134 Lab 3 2 Oct - 8 Oct
04 Thursday 19:00 - 20:30 Jack Erskine 131 Lab 1 2 Oct - 8 Oct
05 Thursday 19:00 - 20:30 Jack Erskine 136 Lab 4 2 Oct - 8 Oct
06 Thursday 19:00 - 20:30 Jack Erskine 133 Lab 2 2 Oct - 8 Oct
07 Thursday 19:00 - 20:30 Jack Erskine 248 Computer Lab 2 Oct - 8 Oct

Timetable Note

There will be three lectures per week (times to be announced), which will be given by Prof Tanja Mitrovic (email tanja@cosc.canterbury.ac.nz) and Dr Miguel Morales (miguel.morales@canterbury.ac.nz). Labs will be held in CSSE labs in the Jack Erskine building.

Please consult the UC website for the latest information about the times and locations of COSC265 lectures, labs and tutorials (the CSSE Department is not responsible for scheduling these). Also, most information for the course will be made available via LEARN or on the CSSE and CIS web pages.

Course Coordinator

Tanja Mitrovic

Tutor

Yalini Sundralingam

Assessment

Assessment Due Date Percentage  Description
Assignment Part 1 11 Aug 2023 8% Due by 5pm
Assignment Part 2 25 Aug 2023 16% Due by 5pm
Quizzes 6% Due date: TBA
Lab Test 05 Oct 2023 20% 7.00-9.00pm
Final Exam 50% Closed Book, 2 hours, date TBC


2022 Covid-19 Update: Please refer to the course page on AKO | Learn for all information about your course, including lectures, labs, tutorials and assessments.

No assignments will be accepted after the drop dead date (i.e. a week after the assignment is due). The penalty for the late submission of an assignment will be an absolute deduction of 15% of the maximum possible mark.

In order to pass a course you must meet two requirements:
a) The university has adopted a common scale for converting marks to grades. According to this scale, an average mark of 50% is sufficient to pass the course (i.e. to achieve a C-), with an average mark of 55% a C grade is achieved and so forth. We apply this conversion scale to the average marks students achieve over all assessment items.
b) You must achieve an average mark of at least 45% on the lab test and exam.
Marks are sometimes scaled to achieve consistency between courses from year to year.

Textbooks / Resources

Required Texts

Elmasri, Ramez. , Navathe, Sham; Fundamentals of database systems ; 7th; Pearson, 2017.

Previous editions of the same textbook are also suitable.
The COSC265 lecture notes and all additional material will be available via Learn.

Notes

Important documents

COSC265 handouts will be available in Learn. Notices about this course will be posted to the course forum in the Learn system (learn.canterbury.ac.nz). CSSE students will also be made members of a class called "CSSE Notices", where general notices will be posted that apply to all classes (such as information about building access or job opportunities).

There are several important documents available online about departmental regulations, policies and guidelines at the following site. We expect all students to be familiar with these. http://www.cosc.canterbury.ac.nz/policy/

Additional Course Outline Information

Grade moderation

The Computer Science department's grading policy states that in order to pass a course you must meet two requirements:
1. You must achieve an average grade of at least 50% over all assessment items.
2. You must achieve an average mark of at least 45% on invigilated assessment items.

If you satisfy both these criteria, your grade will be determined by the following University-wide scale for converting marks to grades: an average mark of 50% is sufficient for a C- grade, an average mark of 55% earns a C grade, 60% earns a C+ grade and so forth. However if you do not satisfy both the passing criteria you will be given either a D or E grade depending on marks. Marks are sometimes scaled to achieve consistency between courses from year to year.

Students may apply for special consideration if their performance in an assessment is affected by extenuating circumstances beyond their control.

Applications for special consideration should be submitted via the Examinations Office website within five days of the assessment.

Where an extension may be granted for an assessment, this will be decided by direct application to the Department and an application to the Examinations Office may not be required.

Special consideration is not available for items worth less than 10% of the course.

Students prevented by extenuating circumstances from completing the course after the final date for withdrawing, may apply for special consideration for late discontinuation of the course. Applications must be submitted to the Examinations Office within five days of the end of the main examination period for the semester.

Indicative Fees

Domestic fee $916.00

International fee $4,750.00

* All fees are inclusive of NZ GST or any equivalent overseas tax, and do not include any programme level discount or additional course-related expenses.

For further information see Computer Science and Software Engineering .

All COSC265 Occurrences

  • COSC265-23S2 (C) Semester Two 2023