Upon successful completion of this course, the student should be able to
* explain the basic concepts and terminology of data management and databases
* explain the principles, structure, and terminology of the relational database
* explain the DBMS services and their importance and value in software development
* explain what database transaction is and why it has a crucial role in reliable software systems
* explain the database design methodology
* use data-oriented ER diagrams and database diagrams written in UML
* create a small and simple database in SQL Server and MariaDB
* write intermediate-level SQL queries to retrieve and manipulate the database's data.

Passed courses are assessed on a scale of 1 to 5.

Basic concepts and terminology of data management and databases
Principles, structure, and terminology of the relational database
DBMS services and their importance and value in software development
Database transactions
Database design methodology
Data-oriented ER diagrams and database diagrams written in UML
Creating create a small and simple database in SQL Server and MariaDB
Writing intermediate-level SQL queries to retrieve and manipulate the database's data.

a. Contact lessons, assignments, case assignment, and independent studies OR
b. Self-study, assignments, case assignment, and written examinations OR
c. On-the-job learning, portfolio, and written examinations.

Assessment
* Weekly hands-on lab assignments, a comprehensive group work case assignment, activity in the group, learning diary, and two written exams

Recognising and validating prior learning (RPL)
* Portfolio and exam. RPL should be applied for prior commencing the course.

Connolly, T. & Begg, C. Database Systems. Addison Wesley Longman, London. 3rd edition or later
SQL Zoo online SQL tutorial and W3Schools online SQL tutorial
Course handouts

The student has completed the course Orientation to Software Engineering (SWD1TF001), or can demonstrate equivalent skills and knowledge. In addition, the course Orientation to ICT Infrastructures (ICT1TF010) is recommended to be completed before taking the Data Management and Databases course.

The student
* shows passable activity and punctuality on the course
* has passable understanding of the course contents, core concepts and terminology
* has passable knowledge and skills in writing database queries in SQL
* has passable knowledge and skills in using data-oriented diagrams
* has some difficulties in using the course materials to support own learning.

The student
* shows good activity and punctuality on the course
* has good understanding of the course contents, core concepts and terminology
* has good knowledge and skills in writing database queries in SQL
* has good knowledge and skills in using data-oriented diagrams
* has sufficient knowledge and skills in creating a small and simple database
* can use the course materials in an effective way to support own learning.

The student
* shows excellent activity and punctuality on the course
* has excellent understanding of the course contents, core concepts and terminology
* has excellent knowledge and skills in writing database queries in SQL
* has excellent knowledge and skills in using data-oriented diagrams
* has good knowledge and skills in creating a small and simple database
* uses the course materials and independently found sources fluently to support own learning.