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
- 2017/2018
- Teacher
- DENIS FERRARETTI
- Credits
- 6
- Didactic period
- Secondo Semestre
- SSD
- ING-INF/05
Training objectives
- The course covers the fundamental concepts necessary to design and implement the database systems and their applications.
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
- techniques and concepts for web access to relational databases
The basic acquired abilities (that are the capacity of applying the acquired knowledge) will be:
- designing and implementation of database oriented applications
- writing complex SQL queries on a relational database Prerequisites
- none
Course programme
- - Database introduction
- Conceptual modeling and E/R diagram
- Relation model
- SQL language
- Relational algebra
- Database normalization
- Databases indexesGli indici
- Concepts and techniques of web access to relational databases Didactic methods
- Classroom lectures with exercises/laboratory.
Classroom team work. Learning assessment procedures
- The examination is divided into 3 sections: a written test, a design and development project and an oral test.
The written test consists of 3 sections:
1. two questions on all the course topics;
2. an exercise on the SQL language;
3. an ER (Entity Relationship) modeling exercise.
The test aims at evaluating how deeply the student has studied the subject and how he is able to design a ER model.
To pass this test it is required to get at least 18 points out of 33. The time allowed for this test is 3 hour.
The design and development project can be done individually or in groups. The project aims at assessing the skills of analysis and design of a database system, problem-solving and team work. To pass this test it is required to get at least 18 points out of 33.
The oral exam is not compulsory and aimed to investigate further knowledge about course topics. The test assign additional points: from 0 to 6.
The final mark is the mean of the points of the first 2 tests plus points from the oral test.
Passing the final exam is the proof that knowledge and abilities outlined in the training objectives of the course have been achieved. Reference texts
- Reference book:
R. Elmasri, S. Navathe, Sistemi di Basi di Dati - Fondamenti 6/Ed, Pearson-Addison Wesley
Other interesting title::
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone, Basi di Dati - IV Edizione, McGraw-Hill
Teacher’s handouts available on the course web page.