Introduction to Database Systems

You are viewing an older version of this academic item. To access a different version, adjust the year in the field above. For handbooks published prior to 2023, click the "Previous Handbooks" button at the bottom of the page.

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.

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 design.
The implementation of a database design using Structured Query Language (SQL).
The querying of databases using SQL
Database security

Enrolment restrictions

Available to undergraduate students only.

Incompatible