COMP1140
10 units
1000 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
Singapore PSB
- Trimester 1 - 2024 (Singapore)
Callaghan
- Semester 2 - 2024
Learning outcomes
On successful completion of the course students will be able to:
1. Design conceptual models encapsulating data requirements for business and organisational scenarios
2. Convert conceptual models to logical data models
3. Implement a database solution using contemporary database management systems (DBMS)
4. Develop expertise in database languages (e.g. SQL) including the ability to develop sophisticated queries to extract information from large datasets
5. Understand data security and data quality management
Content
1. Conceptual Modelling with ER
2. Relational Model and ER to Relational Mapping
3. Schema Refinement with Normalization based on Functional Dependencies
4. Relational Algebra
5. SQL
6. Database Transactions and Concurrency Control
7. Security, Authorisation and Access
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
Trimester 1 - 2024 (Singapore) - Singapore PSB
Computer Lab-1
- Face to Face On Campus 2 hour(s) per week(s) for 11 week(s) starting in week 3
Lecture-1
- Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1
Semester 2 - 2024 - Callaghan
Computer Lab-1
- Face to Face On Campus 2 hour(s) per week(s) for 11 week(s) starting in week 3
- Compulsory Requirement: Students must attend 80% of sessions.
Lecture-1
- Face to Face On Campus 2 hour(s) per week(s) for 12 week(s) starting in week 1
Course outline
- COMP1140 - Semester 2, 2023 (Callaghan) (PDF, 201.5 KB)
- COMP1140 - Trimester 1, 2024 (Psb) (PDF, 228.8 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.