Technology
Subject: DATABASES (A.A. 2023/2024)
degree course in COMPUTER ENGINEERING
| Course year | 2 |
|---|---|
| CFU | 9 |
| Teaching units |
Unit basi di dati
Computer Engineering (lesson)
|
| Exam type | written |
| Evaluation | final vote |
| Teaching language | Italiano |
Teachers
Overview
The aim of the course is to provide the fundamental notions of conceptual and logical models for relational databases; to acquire the capability ability to design, create, modify, and query a database.
Admission requirements
mandatory introductory courses: none
Course contents
Database Design and Models (20 hours - 2.5 CFU)
1.1 Conceptual Design: the Entity/Relationship Model.
1.2 Logical Design: the Relational Model.
Relational Theory and Languages (28 hours - 3.5 CFU)
1.3 Relational Algebra.
1.4 The SQL92 query language.
1.5 Introduction to functional dependencies and normalization theory.
1.6 Generalities on Database Management Systems (DBMS). Three Levels (ANSI/X3/Sparc) DBMS architecture; Relational DBMS architecture.
2 Practical Exercise in the laboratory (24 hours - 3 CFU)
2.1 Introduction to PostgreSQL environment. Notions on data import and export. Graphical tools for building databases: introduction to pgAdmin.
2.2 Core elements of a database. Creating, modifying, and deleting a database and its tables. Defining and updating constraints. Data manipulation: INSERT, UPDATE, and DELETE commands.
2.3 Creating queries on a database. Complex queries: joins and subqueries, derived tables. NULL values and their treatment.
2.4 Complex structure elements: Views, indexes.
2.5 Stored procedures and triggers
Teaching methods
Lectures, practical exercises, laboratory activities. Synchronous remote delivery for all will be guaranteed; on the basis of the evolution of the COVID19 health emergency and the specificities of the educational activities, the provision will also be assessed even in the presence. teaching platform Teams
Assessment methods
--- METHOD AND CONTENTS OF THE EXAMINATION --- The exam consists of a written test, a laboratory test and an optional oral test.
Learning outcomes
Knowledge and understanding: Through lectures, students will get a comprehensive knowledge and understanding of the relational database theory, the collection and analysis of requirements, the methodologies for conceptual and logical design, the query techniques.
Applying knowledge and understanding: Through classroom exercises and practical exercises on the computer, the student will be able to apply the knowledge gained in the design and implementation of a database.
Making judgments: Thanks to the resolution of individual exercises and practical exercises in the laboratory, the student will be able to critically evaluate the design and implementative decisions taken and the results obtained.
Communication skills: The design and open-ended questions of the written examination and the eventual oral examination, will equip the student to organize and clearly present, through the technical language, the results of his work.
Learning skills: The activities carried out during the course and during the examination allow the student to acquire the instruments to autonomously upgrade his knowledge. This is especially crucial in the field of data management, where technology is constantly evolving.