Course Unit Profile

<--- Back to Course Diagram

Basic Information

Course Unit Title: PRINCIPLES OF DATA BASES

Course Unit Code: 244AA

Level of course unit

First Cycle (Laurea) Degree Programme in Computer Science

Year of study

Third year

Semester when the course is delivered

Annual

Number of ECTS credits allocated: 6

Name of Lecturer(s):

Prof.: Antonio Albano
Email: albano@di.unipi.it

Prof.: Giorgio Ghelli
Email: giorgio.ghelli@unipi.it

Prof.: Dino Pedreschi
Email: dino.pedreschi@unipi.it

Language of instruction

Italian

General Information

Learning outcomes

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.







Course contents

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.







Specific Information

Prerequisites, co-requisites, as a prerequisite for further study

Prerequisites

For this course the prerequisite/s is/are

Co-requisites

None.

Prerequisite for

None.

Mode of delivery

Delivery

face to face

Attendance

Advised

Teaching methods

Learning activities

Recommended or required reading

Recommended reading includes: A. Albano, G. Ghelli e R. Orsini, Fondamenti di Basi di Dati, Zanichelli, Bologna, 2005.


Assessment methods and criteria

Assessment methods

Assessment criteria

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.

Work placement

No

<--- Back to Course Diagram