DATABASE SYSTEMS - PART 2

Academic year
2016/2017 Syllabus of previous years
Official course title
BASI DI DATI - MOD.2
Course code
CT0006 (AF:212525 AR:101260)
Modality
Blended (on campus and online classes)
ECTS credits
6 out of 12 of DATABASE SYSTEMS
Degree level
Bachelor's Degree Programme
Educational sector code
INF/01
Period
2nd Semester
Course year
2
Where
VENEZIA
Moodle
Go to Moodle page
The aim of the course is to present the fundamental concepts of
databases and the techniques for database design. Students will be given
the opportunity of experimenting the notions acquired by using relational
database systems and the SQL language. The course finally provides the
main notions needed in order to develop applications which use
databases, with special interest in web applications, focusing on
communication mechanisms between programming languages and
Database Management Systems.
Normalization theory for the relational data model.
Architecture of Relational Database Management Systems
Programming in languages with SQL integrated or through SQL APIs, like
JDBC and ODBC.
Programming with object-relational mapping technologies.
Introduction to web and web applications.
The PHP language: main concepts.
The use of PHP language with databases.
Management of a PostgreSQL database.
The development of PHP applications with PostgreSQL.
A. Albano, G. Ghelli, R. Orsini. Fondamenti di Basi di Dati. Zanichelli,
2005. (http://www.fondamentidibasididati.it/ )
written and oral
The exam consits of a written test, a project and an oral test. The written test lasts three hours and it is composed by four or five exercises aimed at verifying:
1) the capability to design the conceptual schema of a database and the acquisition of the methodology for transforming the conceptual schema into a relational schema,
2) the ability to query in SQL,
3) knowledge of the concepts and algorithms related to the theory of normalization,
4) the ability to define an access plan and the choice of adequate indices for the execution of a given query.
The written test may be replaced by successful completion of two intermediate examinations. The first one checks skills 1) and 2) and the second one evaluates the knowledge concerning 3) and 4).
During the written test is not allowed the use of books, notes, electronic media.

The project consists in developing a simple web application in PHP that uses a relational database with PostgreSQL DBMS.

During the oral exam, the student must present the project and explain its main functionalities.

In the first module of the course the students are assigned some exercises to check the acquisition of skills 1) and 2) and the execution of these exercises allows to get a bonus.
The second module of the course will be "blended": in part with class lectures and in part with on-line classes. Moreover, there will be a project development with the assistance of the teacher.
Italian
The exam consits of a written test, a project and an oral test. The written test lasts three hours and it is composed by four exercises aimed at verifying:
1) the capability to design the conceptual schema of a database and the acquisition of the methodology for transforming the conceptual schema into a relational schema,
2) the ability to query in SQL,
3) knowledge of the concepts and algorithms related to the theory of normalization,
4) the ability to define an access plan and the choice of adequate indices for the execution of a given query.
The written test may be replaced by successful completion of two intermediate examinations. The first one checks skills 1) and 2) and the second one evaluates the knowledge concerning 3) and 4).
During the written test is not allowed the use of books, notes, electronic media.

The project consists in developing a simple web application in PHP that uses a relational database with PostgreSQL DBMS.

During the oral exam, the student must present the project and explain its main functionalities.

In the first module of the course the students are assigned some exercises to check the acquisition of skills 1) and 2) and the execution of these exercises allows to get a bonus.
  • Lecture notes, material for reference or for self-assessment available online or as e-book
  • Use of virtual forum, blog or wiki
  • E-learning, moodle platforms
  • Use of open-source software