Introduction to databases
- Class 30
- Practice 30
- Independent work 90
Course title
Introduction to databases
Lecture type
Obligatory
Course code
22-06-506
Semester
2
ECTS
5
Lecturers and associates
Course overview
This module introduces students to concepts of relational databases and relational database management systems (RDBMS).
This module is core to both Applied Computer Engineering and Multimedia Computing study programmes and provides the foundation for database related modules that students of Applied Computing study programme will take in the following semesters. For Multimedia Computing study programme, this module is important because of backend programming modules in the next semesters. In both cases, skills learnt in this module will contribute significantly to students’ development as professionals in respecting fields.
Students will learn:
• Relational databases concepts, which are necessary to build skills that are more complex and required in the labour market.
• Normal forms (1NF, 2NF, 3NF) and the normalization process.
• How to construct and interpret SQL statements for selecting, inserting, deleting and updating data.
• How to write more complex SQL queries that include JOIN mechanics, grouping, aggregate functions and subqueries.
The module is taught in Transact-SQL dialect of SQL programming language. The module assessment is based on solving a series of smaller practical tasks. Database design tasks are solved by using a defined tool for ER Modelling, whereas database querying tasks are solved by using a defined database client tool to connect to an actual database.
Literature
Essential reading:
1. Harrington, J. L. (2016) Relational Database Design and Implementation. 4th edn. Amsterdam: Elsevier Inc.
Recommended reading:
1. Churcher, C. (2012) Beginning Database Design: From Novice to Professional. New York City: Apress.
Bachelor in Computer Engineering
Minimal learning outcomes
- Construct a relational data model starting from user requirements.
- Create a database using DDL statements based on a relational model.
- Propose changes to the relational model to achieve a higher normal form.
- Use basic statements to manage data in a relational database.
- Construct a solution using system and aggregate functions and grouping.
- Apply subqueries to create a more complex query.
Preferred learning outcomes
- Construct a relational data model starting from user requirements, including subsets and involutes.
- Create a constraint-rich database using DDL statements based on a relational model.
- Propose changes to the complex relational model to achieve a higher normal form.
- Use statements and joins to manage data in a relational database.
- Construct a complex solution using system and aggregate functions and grouping.
- Apply subqueries to create a more complex query, including queries in FROM clause.