COSC265-12S2 (C) Semester Two 2012

Relational Database Systems

15 points

Details:
Start Date: Monday, 9 July 2012
End Date: Sunday, 11 November 2012
Withdrawal Dates
Last Day to withdraw from this course:
  • Without financial penalty (full fee refund): Sunday, 22 July 2012
  • Without academic penalty (including no fee refund): Sunday, 7 October 2012

Description

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

This course covers 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.

Learning Outcomes

After completing this course, students will be able to
- design databases well
- use relational algebra to query databases
- use SQL to query, define, populate, update and manage databases
- understand the functions of Relational Database Management Systems

Prerequisites

(1) COSC121 or INFO125 or ACIS125; (2) 15 points from Mathematics, Statistics, Engineering Mathematics or MSCI110. MATH101 is not acceptable. MATH120/STAT101 are strongly recommended.

Restrictions

COSC205, COSC226

Course Coordinator

Tanja Mitrovic

Tutor

Yalini Sundralingam

Assessment

Assessment Due Date Percentage 
1: Quizzes throughout the semester 5%
2: Assignment 25%
3: Lab test 20%
4: Final exam 50%

Textbooks / Resources

Recommended Reading

Elmasri, Ramez. , Navathe, Sham; Fundamentals of database systems ; 5th ed; Pearson/Addison Wesley, 2007.

(6th edition), previous editions of the same textbook are also suitable.

Indicative Fees

Domestic fee $692.00

International fee $3,200.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-12S2 (C) Semester Two 2012
Previous year Next year