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

Year:

COMP389 Databases

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
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 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 their knowledge in the essentials of database modeling and design;
  2. apply their knowledge in the areas of relational data structures, data manipulation, and data integrity;
  3. apply their knowledge in using SQL;
  4. explain the principles of query optimisation;
  5. apply their knowledge in the areas of functional dependencies and normalisation; and
  6. explain the principles of object oriented modeling as well as the principles of recovery, concurrency and security.

Graduate Attributes (GA)
Attribute Taught Assessed Practised
1 Knowledge of a Discipline
Knowledge of database concepts are developed in the lectures and assessed in the 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
The unit involves skills in online learning, literature research and computer skills.
True True True
6 Problem Solving
Problem-solving skills are developed through programming exercises.
True True True
7 Social Responsibility
Database security issues are taught and practised in this unit.
True True
8 Team Work
Labs/tutorials include tasks performed in groups.
True
   

Email to a friend