COSC226-10S1 (C) Semester One 2010

Introduction to Databases

11 points

Details:
Start Date: Monday, 22 February 2010
End Date: Sunday, 27 June 2010
Withdrawal Dates
Last Day to withdraw from this course:
  • Without financial penalty (full fee refund): Friday, 5 March 2010
  • Without academic penalty (including no fee refund): Friday, 21 May 2010

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 AFIS125; (2) 18 points from Mathematics, Statistics or Engineering Mathematics. MATH101 is not acceptable. MATH115/STAT131/STAT111/STAT112 are strongly recommended.

Restrictions

COSC205

Course Coordinator

Tanja Mitrovic

Assessment

Assessment Due Date Percentage 
1: Assignment 01 Apr 2010 20%
2: Lab Test 02 Jun 2010 20%
3: Final Exam 60%

Textbooks / Resources

Recommended Reading

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

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 $459.00

International fee $2,063.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-10S1 (C) Semester One 2010
Previous year Next year