Abstract

This subject aims to provide a solid grounding in database theory and application, and its place within the implementation of computer-based applications. There will be an emphasis on conceptual modelling to design a secure database that is implemented and queried using Structured Query Language (SQL).

Syllabus

Definition of a database, database management systems and their importance to business organizations.The importance and use of data models to design databases to meet business requirements.Identifying and documenting business rules.The relational database model.The conceptual design of databases using Entity Relationship Diagrams (ERD).The use of database normalisation techniques to complete database … For more content click the Read More button below.

Learning outcomes

Upon successful completion of this subject, students should:
1.
be able to apply database theory to the design and implementation of relational databases;
2.
be able to analyse and model business database requirements using Entity Relationship Diagrams (ERD);
3.
be able to analyse a database design and apply normalisation theory and techniques;
4.
be able to implement a database design using Structured Query Language (SQL);
5.
be able to query a database using SQL; and
6.
be able to investigate and propose the security requirements for a database.

Enrolment restrictions

Available to undergraduate students only.