CS273 - Introduction to Databases

Aims and Objectives

The aim of the class is to provide participants with a conceptual and practical understanding of data modelling, database design and database technology. The class then builds on a basic understanding of the relational database approach, covering more complex SQL query design and efficient execution.

Learning Outcomes

On completion of this class, participants should be able to:

• show an appreciation of the facilities and services which should be provided by a fully featured database management system.
• demonstrate knowledge of commonly occurring data models.
• display knowledge of the process of designing a database system, starting from an informal specification.
• display skill in formulating database queries using SQL.
• demonstrate ability to utilise triggers / stored procedures, and understand the importance of indexing.
• display knowledge of potential future developments in database technology.

Syllabus

1. Introduction to the Database Environment: functions of a database management system;
2. Entity Relationship modelling.
3. The Relational Data Model, relational algebra, integrity constraints.
4. Relational query languages.
5. Normalisation.
6. JDBC
6. NoSQL

Recommended Reading

This list is indicative only – the class lecturer may recommend alternative reading material. Please do not purchase any of the reading material listed below until you have confirmed with the class lecturer that it will be used for this class.

Reading material recommendations will be made available via the Myplace page for this class.

Transferable skills:

• Participants will develop their problem-solving and modelling skills.

Last updated: 2023-09-10 18:34:00