COSC226-06S1 (U) Semester One 2006 (University Campus)

Introduction to Databases

11 points

Details:
Start Date: Monday, 20 February 2006
End Date: Sunday, 2 July 2006
Withdrawal Dates
Last Day to withdraw from this course:
  • Without financial penalty (full fee refund): Sunday, 5 March 2006
  • Without academic penalty (including no fee refund): Sunday, 28 May 2006

Description

Introduction to data models and relational databases.

The course focuses on data modelling and database systems, which have important applications in industry and generate a wide spectrum of research opportunities and employment prospects. At the end of the course you should be able to design databases and database applications, and understand the basic principles of database management systems.

Major topics include database design lifecycle; conceptual data modelling; relational data model; SQL; functional dependencies and normalization.

Learning Outcomes

To enable the students to

   * Design databases well
         o understand database design process
         o understand the ER and EER data models
         o develop EER schemas of databases
         o understand the relational data model
         o map ER into relational schemas
         o normalize relations

   * use relational algebra to query databases
         o understand the operations of relational algebra
         o specify queries

   * use SQL to query, define, populate, update and manage databases

   * understand the functionality of RDBMSs
         o understand the purpose of various components of RDBMSs
         o understand the purpose of data catalogs

Prerequisites

(1) COSC121 or COSC123; (2) COSC122; (3) 18 points from Mathematics, Statistics or Engineering Mathematics. MATH101 is not acceptable. MATH115/STAT131/STAT111/STAT112 are strongly recommended.

Restrictions

COSC205

Course Coordinator / Lecturer

Tanja Mitrovic

Assessment

Assessment Due Date Percentage 
Final Examination 60%


Please refer to the department's database for course assessments

Notes

You may practise database design in EER-Tutor, SQL queries in SQL-Tutor,
ER-to-Relational  mapping in the
ERM-Tutor,
and data normalization in NORMIT.

Indicative Fees

Domestic fee $384.00

International fee $1,632.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 COSC226 Occurrences

  • COSC226-06S1 (U) Semester One 2006 (University Campus)
  • COSC226-06S2 (U) Semester Two 2006 (University Campus) - Not Offered
Next year