Use the Tab and Up, Down arrow keys to select menu items.
An introduction to database systems, database design, relational databases and database management systems.
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).
1. Discuss the role of database systems in software applications, the database life cycle, and the functions of relational database management systems [WA1]2. Design conceptual database schema from requirements, map conceptual schemas to relational schemas and normalize relational databases [WA2, WA3]3. Design physical schemas to achieve good performances [WA2, WA3]4. Use relational algebra and SQL to query and implement relational databases [WA5]5. Apply relational algebra to optimize evaluation of queries [WA4]
This course will provide students with an opportunity to develop the Graduate Attributes specified below:
Critically competent in a core academic discipline of their award
Students know and can critically evaluate and, where applicable, apply this knowledge to topics/issues within their majoring subject.
Employable, innovative and enterprising
Students will develop key skills and attributes sought by employers that can be used in a range of applications.
COSC121 or COSC131 or INFO125
Students must attend one activity from each section.
There will be three lectures per week (times to be announced). Labs will be held in CSSE labs in the Jack Erskine building. Please check your timetable for location of tutorials.
Tanja Mitrovic
Miguel Morales
Yalini Sundralingam
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.
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.The 7th edition of the course textbook can now be purchased from here
Library portalCourse Information on Learn Course Outline 2022
Important documentsCOSC265 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/
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.
Domestic fee $998.00
International fee $5,188.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 .