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

Year:

COMP589 Databases

Updated: 29 January 2013
Credit Points 6
Offering
Responsible Campus Teaching Period Mode of Study
Armidale Trimester 2 Off Campus
Armidale Trimester 2 On Campus
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.

Materials Textbook information will be displayed approximately 8 weeks prior to the commencement of the teaching period. Please note that textbook requirements may vary from one teaching period to the next.
Disclaimer Unit information may be subject to change prior to commencement of the teaching period.
Assessment Assessment information will be published prior to commencement of the teaching period.
Learning Outcomes (LO) Upon completion of this unit, students will be able to:
  1. demonstrate in depth knowledge of the essentials of database modelling and design and apply his/her knowledge in using SQL;
  2. apply and demonstrate in depth knowledge in the areas of relational data structures, data manipulation, and data integrity;
  3. demonstrate knowledge related to the principles of query optimisation;
  4. apply in depth knowledge in the areas of functional dependencies and normalisation;
  5. demonstrate in depth knowledge related to the principles of object oriented modeling, recovery, concurrency and security; and
  6. demonstrate in depth knowledge in the area of logic-based systems.

Graduate Attributes (GA)
Attribute Taught Assessed Practised
1 Knowledge of a Discipline
Knowledge of database concepts and techniques are developed in the lectures and assessed in assessment tasks.
True True True
2 Communication Skills
Taught, assessed and practised in written assignments and bulletin board communication.
True True True
3 Global Perspectives
The unit presents a global perspective on database issues and their solutions. This is taught in lectures and practised in labs/tutorials.
True True
4 Information Literacy
This unit involves skills in online learning, literature research and computer skills.
True True
5 Life-Long Learning
Students are taught about the semantic modeling approaches and fundamentals of relational algebra, relational calculus and SQL which are considered as lifelong learning, assessed via assignments, exams and practical labs.
True True
6 Problem Solving
Problem solving skills are developed through programming exercises.
True True True
7 Social Responsibility
Database security issue are taught and practised in this unit.
True True
8 Team Work
Labs/tutorials include tasks performed in groups.
True True
   

Email to a friend