Course Details
Name:
Basi di Dati / Databases
Basic information
Credits:
Bachelor Degree in Computer Science: 6 Ects (b)
Degree(s):
Compulsory 2nd year Bachelor Degree in Computer Science curriculum General
Language:
Italian
Course Objectives
Following this course, the students will:
understand what is a database, from the conceptual, mathematical and practical points of view; become able to develop the conceptual and logical design of a relational database,
including both the structure and the operations; understand the basic functionalities of a DBMS (Data Base Management System); acquire notions about advanced aspects and future directions of the filed.
Course Content
- Introduction, data models, the relational model (RL).
- Relational algebra and calculus, Datalog.
- Database Conceptual and Logical Design: Entity Relationship (E-R) diagrams, restructuration and translation into relational schemas.
- Normalization of relational schemas.
- Advanced databases: object-oriented databases, hints on data wharehouses and cloud-computing.
- Database Technology: concurrency and fault-tolerance.
Prerequisites and Learning Activities
The student should be acquainted with some programming language,
so as to understand what a file is, and to have experimented some
basic operations on files. The student should possess some basic knowledge
of operating systems, namely about the file-system and concurrency. It is mandatory to possess basic notions of mathematical Logic and Set Theory.
Teaching Methods
Language: Italian
Lectures and interactive exercise sessions.
Assessment Methods and Criteria
The exam of the Database Module is composed of a mandatory written test and an optional oral test. The oral test can be required: by the student in order to improve grades; by the teacher in case the student's written test has serious omissions or mistakes.
Textbooks
- Atzeni, Ceri, Paraboschi, Torlone, Basi di Dati: Concetti, Linguaggi e Architetture,. McGraw-Hill.
Notes
- Orario di ricevimento: Mercoledi' 10:30-12:30 oppure su appuntamento email (the lecturer can meet the students on Wednesday, 10:30-12:30 or by making an appointment via email)
Curriculum Vitae docente (Lecturer CV): http://www.di.univaq.it/stefcost/curring.htm
NOTA: per sillabo, testi ecc. vedi Basi di Dati con Laboratorio
Online Teaching Resources
Recent teaching material
This list contains only the latest published resources. Resources marked with an asterisk belong to other courses (indicated between brackets)
- Click here to access the complete resources list.
Course page updates
This course page is available (with possible updates) also for the following academic years:
Course information last updated on: 25 gennaio 2018, 13:04