Database Systems

This subject is available under ICMS undergraduate degrees, please click the button below to find an undergraduate course for you.

Subject Code:

DAT101A

Subject Type:

Core 

Credit Points:

3 credit points

Pre-requisite/Co-requisite: 

None 

Subject Level:

100

Subject Rationale:

Data is a critical component of any contemporary computer application. Hence, it is a critical computing skill to understand how databases function and how to effectively manage them. This subject equips students with the relevant skills to develop database applications and the logic behind relational and non-relational database management systems.   

 Students will learn the foundations of the industry-standard database query language – SQL. They will also be introduced to further relevant technologies and concepts used to implement and manage databases including, query data models, data dictionaries implementation techniques including indexing, query evaluation, and normalisation. The challenges of administering relational database management systems, maintaining database security and integrity, ethical considerations, backup and recovery procedures will be addressed. 

Learning Outcomes:

a) Explain the core components and functions of databases and their application within the business context.

b) Apply key database modelling principles to construct data models.

c) Evaluate business requirements and translate them into effective and ethical database designs.

d) Construct Structured Query Language (SQL) commands to define, retrieve, and manipulate data.

e) Apply normalisation rules to evaluate and optimise table structures.

Student Assessment:

Broad Topics to be Covered:

Please note that these topics are often refined and subject to change so for up to date weekly topics and suggested reading resources, please refer to the Moodle subject page.