Skip navigation to main content

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

Sub sections:

Quick Search

Quick Links

Year:

COMP389 Databases

Updated: 18 January 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
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
Co-requisites None
Restrictions COMP382 or COMP382A or COMP389A or COMP502 or COMP589
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 COMP589 - 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.
Materials Text information will be published prior to commencement of the teaching period.
Disclaimer Offer of some subjects is subject to viability. Information in these unit descriptions is subject to change prior to commencement of semester.
Assessment
Title Exam Length Weight Mode No. Words
Assignment 1 15% On/Off Campus
Assessment Notes
Short answers
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4, 5, 6, 7 GA: 1, 2, 4, 6
Assignment 1 15% ISBT On Campus
Assessment Notes
Short answers
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4, 5, 6, 7 GA: 1, 2, 4, 6
Assignment 2 15% On/Off Campus
Assessment Notes
Short answers
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4, 5, 6, 7 GA: 1, 2, 4, 6
Assignment 2 15% ISBT On Campus
Assessment Notes
short answers
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4, 5, 6, 7 GA: 1, 2, 4, 6
Final Examination 2 hrs 70% ISBT On Campus
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4, 5, 6, 7 GA: 1, 2, 4, 6
Final Examination 2 hrs 70% On/Off Campus
Relates to Learning Outcomes (LO) and Graduate Attributes (GA)
LO: 1, 2, 3, 4, 5, 6, 7 GA: 1, 2, 4, 6

Learning Outcomes (LO) Upon completion of this unit, students will be able to:
  1. demonstrate his/her knowledge in the essentials of database modeling and design;
  2. apply his/her knowledge in the areas of relational data structures, data manipulation, and data integrity;
  3. apply his/her knowledge in using SQL;
  4. explain the principles of query optimisation;
  5. apply his/her knowledge in the areas of functional dependencies and normalisation;
  6. explain the principles of object oriented modeling;
  7. 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
Taught, assessed and practised in written assignments and bulletin board communication. 		True 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
Problem solving skills are developed through programming exercises. 		True True True
   

Email to a friend