Overview

The aim of this topic is to familiarise students with the basic concepts, fundamental structures and general techniques that are needed to define, construct and manipulate a database using a Database Management System (DBMS) with the main emphasis on relational DBMSs. The topic will cover the concept of data models, … For more content click the Read More button below.

Topic availabilities

To view topic availabilities, select an availability from the drop down, towards the top right of the screen.

Tuition pattern

To view tuition patterns, select an availability from the drop down, towards the top right of the screen.

Aims

This topic aims to familiarise students with the basic concepts, fundamental structures and general techniques that are needed to define, construct and manipulate a database using a database management system (DBMS) with the main emphasis on relational DBMSs. Furthermore students should understand the concept of data models, have practical skills in data modelling using the Entity-Relationship (ER), Extend Entity-Relationship (EER) and relational data models, their diagrammatic representations, normal forms, and the Structured Query Language (SQL). In addition, students will be knowledgeable about current research trends in data modelling.

Learning outcomes

On completion of this topic you will be expected to be able to:
1.
Explain the concept of data model and have basic skills in data modelling using the information (or semantics) and the relational data models
2.
Specify the activities that a database management system supports and describe common approaches to supplying this support
3.
Discuss and practise the various techniques for database system design, implementation and maintenance
4.
Define and manipulate a relational database using SQL
5.
Appreciate of the role of ethics in a data modelling environment and maintaining a database management system and its environment
6.
Discuss current research trends in Data Modelling

Assessments

To view assessment information, select an availability from the drop down, towards the top right of the screen.

Current students should refer to FLO for detailed assessment information, including due dates. Assessment information is accurate at the time of publishing.

For policy details, visit Assessments

Requisites information

Anti-requisites:

Assumed knowledge

Basic mathematical and numeric concepts.