Academic year2016/17
CourseCOMPUTER SCIENCE
Code244AA
Credits6
PeriodSemester 2
LanguageItalian
| Modules | Area | Type | Hours | Teacher(s) |
| BASI DI DATI | INF/01 | LEZIONI | 48 | |
Programma non disponibile nella lingua selezionata
Knowledge
The student who successfully completes the course will have the ability to execute the conceptual design of a database, and to translate that into a relational schema. The student will have the ability to write complex SQL queries. The student will acquire basic knowledge of the theory of relational databases. The student will know the architecture of a typical relational data base system, including the algorithm used for query execution, query optimization, and transaction management.
Assessment criteria of knowledge
The written test will be mostly focussed on conceptual design, logical design, relational theory, and the ability to write complex SQL queries.
During the oral exam, the student will be assessed on his/her demonstrated ability to discuss the main course contents using the appropriate terminology.
Methods:
- Final oral exam
- Final written exam
Teaching methods
Delivery: face to face
Learning activities:
- attending lectures
- participation in discussions
- individual study
- Practical
Attendance: Advised
Teaching methods:
Syllabus
Information systems and computer-based information systems. Functionality of DBMS.
Object-data model abstraction mechanisms. The design of databases using the object-data model. The relational data model and the data base logical design. The SQL language to create and use databases. The theory of relational databases. Functional Dependencies, Decompositions of relational schemas.Normal forms.
DBMS Architecture: query execution, query optimization, transactiona management.
Bibliography
Recommended reading includes: A. Albano, G. Ghelli e R. Orsini, Fondamenti di Basi di Dati, Zanichelli, Bologna, 2005.
Updated: 14/11/2016 17:27
