COMP6140
10 units
6000 level
Course handbook
Description
This course provides students with theoretical knowledge and practical skills in the use of databases and database management systems. The conceptual and logical design and implementation of relational databases are covered.
Availability2024 Course Timetables
Online
- Semester 2 - 2024
Learning outcomes
On successful completion of the course students will be able to:
1. Design data models and execute database normalisation
2. Evaluate the role of database management systems
3. Identify and use contemporary logical design methods and tools for databases
4. Master database languages (e.g. SQL)
5. Implement a database solution to a computing problem
6. Develop sophisticated queries to extract information from large datasets
7. Maintain key aspects of data security and data quality management
8. Explore research aspects of databases and information management
Content
- Data Modelling (ER Model and Conceptual Design)
- Relational Algebra and Relational Calculus
- SQL
- Transaction Management and Concurrency Control
- Schema Refinement, Functional Dependencies, Normalisation
- Security and Authorisation
- Database Administration
Requisite
This course has similarities to INFT2040. If you have completed INFT2040 you cannot enrol in this course.
Assumed knowledge
Knowledge of and experience in programming
Assessment items
Project: Assignment 1: Database Project - Description and EER model
Project: Assignment 2: Database Project - Logical Database Design
Quiz: Practical Test - Lab test on SQL
Project: Assignment 3: Database Project - Physical Database Design
Online Open Book Formal Examination: Final Examination
Compulsory Requirement: Pass requirement 40% - Must obtain 40% in this assessment item to pass the course.
Contact hours
Semester 2 - 2024 - Online
Online Activity-1
- Online 4 hour(s) per week(s) for 13 week(s) starting in week 1
- For the online version of this course, four hours per week is a minimum recommendation and may vary with individual student learning styles.
Course outline
- COMP6140 - Semester 2, 2023 (Online) (PDF, 213.5 KB)
The University of Newcastle acknowledges the traditional custodians of the lands within our footprint areas: Awabakal, Darkinjung, Biripai, Worimi, Wonnarua, and Eora Nations. We also pay respect to the wisdom of our Elders past and present.