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

Year:

COMP389 Databases

Updated: 30 March 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.

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 , On and Off Campus
An Introduction to Database Systems
ISBN: 9780321189566
Date, C.J., Addison-Wesley 8th ed. 2004
Text refers to: Semester 2 , 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 from the Dixson Library, UNE
Text refers to: Semester 2 , 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 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% 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
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

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