DATABASES
Academic year and teacher
If you can't find the course description that you're looking for in the above list,
please see the following instructions >>
- Versione italiana
- Academic year
- 2021/2022
- Teacher
- ELENA BELLODI
- Credits
- 6
- Didactic period
- Secondo Semestre
- SSD
- ING-INF/05
Training objectives
- The course covers the fundamental concepts necessary to design and implement database systems.
The main objective of the course is to provide students with the foundation to face the analysis and design of relational databases.
The main knowledge acquired will be:
- basic elements about the analysis and the conceptual modeling of a relational database
- knowledge of relational algebra and the SQL language
- database normalization theory and methods
- main elements of database indexes and their implementation
The basic acquired abilities will be:
- design and implementation of database-oriented applications;
- writing complex SQL queries on a relational database. Prerequisites
- None.
Course programme
- - Database introduction
- Conceptual modeling and ER diagram
- Relation model
- SQL language
- Relational algebra
- Normalization
- Transactions
- Database indexes
- NOSQL databases Didactic methods
- Classroom lectures with exercises/laboratory.
Classroom team work.
Individual work.
Individual appointments. Learning assessment procedures
- The examination is divided into: a written test and a design and development project.
The written test consists of:
1. questions about all the course topics;
2. exercises on the SQL language.
The test aims at evaluating how deeply the student has studied the subject and how he is able to write in SQL language.
To pass this test it is required to get at least 18 points out of 32. The test can be repeated whenever the student wants, but the latest result will be the only valid.
The latest result >=18 is always valid. The result obtained with Professor Ferraretti is equally valid, and the student can ask for the presentation of the project provided that the written result has been demonstrated/retrieved.
The presentation of the project MUST FOLLOW the written test.
The design and development project can be done individually or in pairs. The project aims at assessing the skills of documentation and design of a database system and problem-solving. The project will increase or decrease the written test grade of 4 points tops.
If one is not satisfied of the final grade, it will be mandatory to develop a new project.
More detailed information about the project will be provided during the course and in the slides.
Students following Cento classes (curriculum INGEGNERIA INFORMATICA - SISTEMI WEB) may realize (not compulsory) a joint project for the courses of Basi di dati, Ingegneria dei Sistemi Web and Ingegneria del Software.
More detailed information about the project are given in the teacher's material.
There will be 6 written tests per academic year. The project can be presented by appointment via email during the examination periods. Only for students who have not completed exams within set time period can request oral examinations during term time. Reference texts
- Ramez A. Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems. 7th Edition, 2018, Pearson Addison Wesley.
Available in the library (in Italian).
Teacher’s handouts available on the course web page.
