Skip navigation to main content

You are here: UNE Home / Course and Unit Catalogue / 2010 / A-Z / COMP589

Sub sections:

Quick Search

Quick Links

Year:

COMP589 Databases

Updated: 27 April 2010
Credit Points 6
Offering
Responsible Campus Teaching Period Mode of Study Online Level
Armidale Semester 2 Off Campus D - Comp/internet essential
Armidale Semester 2 On Campus D - Comp/internet essential
ISBT Sydney ISBT Semester 2 On Campus D - Comp/internet essential
ISBT Sydney ISBT Summer On Campus D - Comp/internet essential
Intensive School(s) None
Supervised Exam There is a UNE Supervised Examination held at the end of the teaching period in which you are enrolled.
Pre-requisites COMP131 or COMP131A or COMP530 or COMP531 or candidature in GradCertCompSc or GradDipCompSc or MCompSc
Co-requisites None
Restrictions COMP382 or COMP382A or COMP389 or COMP389A or COMP502
Notes

200- and 300-level COMP units (excluding COMP286, COMP292,, COMP303, COMP313 and COMP393) require a knowledge of and programming experience with the C++ or Java language.
Combined Units COMP389 - Databases
Coordinator(s) Kankana Chakrabarty (kchakrab@une.edu.au)
Unit Description

This unit concentrates on database principles, architecture of database systems, database modeling, and database design. SQL, functional dependencies, normalization principles and principles of object-oriented database systems are discussed. It further includes the notions of relational algebra, relational calculus, recovery, concurrency and security. Principles of logic-based systems are discussed and explained.
Prescribed Material
Mandatory 		Text(s):

Note: Students are expected to purchase prescribed material

A First Course in Database Systems
ISBN: 9780136006374
Ullman, J.D. and Widom, J., Prentice Hall 3rd ed. 2008
Text refers to: Semester 2, ISBT Semester 2 and ISBT Summer , On and Off Campus
An Introduction to Database Systems
ISBN: 9780321197849
Date, C.J., Addison-Wesley 8th ed. 2004
Text refers to: Semester 2, ISBT Semester 2 and ISBT Summer , On and Off Campus
Referenced Material
Optional 		Text(s):

Note: Reference material is held in the University Library - purchase is optional

Database Management Systems
ISBN: 9780072465631
Ramakrishnan, R. and Gehrke, J., McGraw-Hill 3rd ed. 2003
Note: Available form the Dixson Library, UNE
Text refers to: Semester 2, ISBT Semester 2 and ISBT Summer , On and Off Campus
Disclaimer Unit information may be subject to change prior to commencement of the teaching period.
Assessment
Title Exam Length Weight Mode No. Words
Assignment 1 10% ISBT On Campus
Assessment Notes
Short answers
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6
Assignment 1 10% On/Off Campus
Assessment Notes
Theoretical assignment - approx 9 hrs
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6
Assignment 2 10% On/Off Campus
Assessment Notes
Theoretical assignment - approx 9 hrs
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6
Assignment 2 10% ISBT On Campus
Assessment Notes
Short answers
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6
Assignment 3 10% ISBT On Campus
Assessment Notes
Short answers
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6
Assignment 3 10% On/Off Campus
Assessment Notes
Theoretical assignment - approx 9 hrs
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6
Final Examination 2 hrs 70% ISBT On Campus
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6
Final Examination 2 hrs 70% On/Off Campus
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4 GA: 1, 2, 3, 4, 5, 6

Learning Outcomes (LO) Upon completion of this unit, students will be able to:
  1. demonstrate his/her knowledge in the essentials of database modelling and design and apply his/her knowledge in using SQL;
  2. apply his/her knowledge in the areas of relational data structures, data manipulation, and data integrity;
  3. explain the principles of query optimisation;
  4. apply his/her knowledge in the areas of functional dependencies and normalisation;
  5. explain the principles of object oriented modelling and logic-based systems;
  6. explain the principles of recovery, concurrency and security.

Graduate Attributes (GA)
Attribute Taught Assessed Practised
1 Knowledge of a Discipline
Knowledge of databases is developed in the lectures and assessed in all assessment tasks. 		True True True
2 Communication Skills
Practised and assessed in assignments and final examination. 		True True
3 Global Perspectives
Ethical issues discussed in the unit have a global perspective. 		True True
4 Information Literacy
The unit is part of information technology programs where information literacy skills are taught, practised and assessed. 		True True True
6 Problem Solving
The unit material and assignments teach problem-solving skills. 		True True True
7 Social Responsibility
Ethical issues related to Internet Security are taught in the unit and assessed in the examination. Also, plagiarism rules of the university require ethical behaviour from students. 		True True True
8 Team Work
 True True
   

Email to a friend