CS253 - Information and Data 2

TIMETABLE	TEACHING MATERIAL
Credits	20
Level	2
Semester	Term 1
Availability	Available to participants taking UG Graduate and Degree Apprenticeship programmes, e.g. BSc Hons IT: Software Development and BSc Hons Digital and Technology Solutions.
Prerequisites	N/A
Learning Activities Breakdown	12 tutorials, online study, assignments, quizzes and a group project.
Items of Assessment	2
Assessment	One individual assignment worth 30%, a series of quizzes worth 10%, and a final class test worth 60%.
Lecturer	Leila Shafti

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

After completing this class participants will 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 an ability to utilise triggers / stored procedures, and understand the importance of indexing.
Display knowledge of potential future developments in database technology.

Syllabus

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

Office:	0141 548 3189/3096
	cis-office@strath.ac.uk
	LT1101
IT Support:	cis-support@strath.ac.uk
	0141 548 3592
	LT1307
Emergency:	0141 548 2222
Security Control:	0141 548 3333

Syllabuses - UG

CS253 - Information and Data 2

Aims and Objectives

Learning Outcomes

Syllabus

Recommended Reading