menu

CECS Professional Skills Mapping

COMP2400 — Relational Databases

code: COMP2400
name: Relational Databases
unit value: 6
description: This course is an introduction to database concepts and the general skills for designing and using databases, with a focus on relational database concepts and techniques. Current industry developments of database systems such as NoSQL databases will be introduced at
the end of the course.
P&C: https://programsandcourses.anu.edu.au/course/COMP2400
course learning outcomes:
  1. Interpret and explain the basic concepts of the relational model and understand its mathematical foundation,
  2. Apply SQL language to define, query and manipulate a relational database
  3. Apply conceptual database modelling methods such as entity-relationship model to design a relational database
  4. Research, justify and apply database design methods on functional dependencies and normal forms to evaluate the quality of a relational database design,
  5. Interpret and discuss query processing and optimisation, transaction and security management in a relational database management system
  6. Reflect upon state of the art of database management systems and big data management challenges
assessment:
  1. Quizzes and Labs (5%)
  2. Assignment 1 on SQL (20%)
  3. Assignment 2 on Database Theory (15%)
  4. Test on NoSQL (5%)
  5. Final exam (55%)

Mapped learning outcomes

learning outcome1. KNOWLEDGE AND SKILL BASE2. ENGINEERING APPLICATION ABILITY3. PROFESSIONAL AND PERSONAL ATTRIBUTESassessment tasks
1.11.21.31.41.51.62.12.22.32.43.13.23.33.43.53.612345
  1. Interpret and explain the basic concepts of the relational model and understand its mathematical foundation,
✓✓✓✓
  1. Apply SQL language to define, query and manipulate a relational database
✓✓✓✓✓✓✓✓
  1. Apply conceptual database modelling methods such as entity-relationship model to design a relational database
✓✓✓✓✓✓✓✓✓
  1. Research, justify and apply database design methods on functional dependencies and normal forms to evaluate the quality of a relational database design,
✓✓✓✓✓✓✓
  1. Interpret and discuss query processing and optimisation, transaction and security management in a relational database management system
✓✓✓✓✓✓✓
  1. Reflect upon state of the art of database management systems and big data management challenges
✓✓✓✓✓

Course contribution towards the Engineers Australia Stage 1 Competency Standard

This table depicts the relative contribution of this course towards the Engineers Australia Stage 1 Competency Standard. Note that this illustration is indicative only, and may not take into account any recent changes to the course. You are advised to review the official course page on P&C for current information..

1. KNOWLEDGE AND SKILL BASE
1.1
 
1.2
 
1.3
 
1.4
1.5
 
1.6
 
2. ENGINEERING APPLICATION ABILITY
2.1
 
2.2
 
2.3
 
2.4
3. PROFESSIONAL AND PERSONAL ATTRIBUTES
3.1
3.2
 
3.3
3.4
 
3.5
 
3.6

Engineers Australia Stage 1 Competency Standard — summary

1. KNOWLEDGE AND SKILL BASE
✓1.1Comprehensive, theory based understanding of the underpinning natural and physical sciences and the engineering fundamentals applicable to the engineering discipline.
✓1.2Conceptual understanding of the, mathematics, numerical analysis, statistics, and computer and information sciences which underpin the engineering discipline.
✓1.3In depth understanding of specialist bodies of knowledge within the engineering discipline.
1.4Discernment of knowledge development and research directions within the engineering discipline.
✓1.5Knowledge of contextual factors impacting the engineering discipline.
✓1.6Understanding of the scope, principles, norms, accountabilities and bounds of contemporary engineering practice in the engineering discipline.
2. ENGINEERING APPLICATION ABILITY
✓2.1Application of established engineering methods to complex engineering problem solving.
✓2.2Fluent application of engineering techniques, tools and resources.
✓2.3Application of systematic engineering synthesis and design processes.
2.4Application of systematic approaches to the conduct and management of engineering projects.
3. PROFESSIONAL AND PERSONAL ATTRIBUTES
3.1Ethical conduct and professional accountability.
✓3.2Effective oral and written communication in professional and lay domains.
3.3Creative, innovative and pro-active demeanour.
✓3.4Professional use and management of information.
✓3.5Orderly management of self, and professional conduct.
3.6Effective team membership and team leadership.

Updated:  18 February 2021/ Responsible Officer:  Dean, CECS/ Page Contact:  CECS Academic Education Services