This module will introduce the learner to the basic concepts in the theory, design and implementation of relational and non-relational databases and how they fit into the area of information management. The student will learn basic database design techniques and will gain expertise in the main constructs of SQL/querying.
Introduction to Databases
Database approach, Roles in the database environment. Functions of a DBMS, Components of a database system, Retrieval of data, Creation of links between tables
Database Design: Introduction to ER Modelling
Basic Modelling concepts, The ER model: identifiers, attributes & relationships, application of business rules, modifying data(INSERT, UPDATE and DELETE), simple VIEWS
Data Manipulation
Simple select queries, Nested queries, Aggregate functions, Group-by operator , Table Joins.
Data Definition
Data definition commands, Understanding datatypes, Creating table structures, Basic SQL constraints.
Cloud-based Databases & RAD
Introduction to cloud-based databases and rapid application development, Connecting to a cloud-based database, SQL queries in the cloud and basic application development.
Lecture, lab and tutorial.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |