Databases and WEB - Teoria: siti web centrati sui dati (2008/2009)

Course Not running, not visible

Course code
4S00012
Name of lecturer
Alberto Belussi
Number of ECTS credits allocated
2
Other available courses
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Location
VERONA
Period
3° Q dal Apr 20, 2009 al Jun 19, 2009.

To show the organization of the course that includes this module, follow this link * Course organization

Lesson timetable

Learning outcomes

The module “Databases Theory” ("Teoria: basi di dati" in italian) of the course “Databases and WEB” has the aim to provide the student with the necessary concepts and methods for the design of data-intensive web applications. In particular, this module will be focused on a methodology for the logical design of a web application that interacts with a database system (DBMS).
In particular, the approach Model-View-Controller (MVC-2 servlet centric) will be illustrated and applied to some examples.

Syllabus

The module is organized in 16 hours of lessons and exercises carried out during the third period. The module will focuses on the logical design of a data-intensive web application and its implementation using: Postgresql, Servlet and Java Server Pages (JSP) technologies. In particolar, the following arguments will be illustrated:
* Web Server: basic internet, basic HTML (form), basic HTTP.
* Information systems on the Web: techniques for the interaction between a DBMS and a HTTP server (CGI, Servlet, JSP); JDBC library and Java data beans; the architecture proposed by the MVC-2 approach.
* a methodology for the logical design of a data-intesive web application.

Assessment methods and criteria

The final examination of the course "Database and Web" is organized in three tests. The first covers the module "Teoria: basi di dati" and consists of some exercises on the conceptual and logical design of a database, SQL and relational algebra queries and questions about the theory. The second test covers the module "Laboratorio" and consists of some exercises on the design of a web application based on the MVC-2 approach using the JSP, Java data beans and Servlet technologies. The third one covers the module "Teoria: siti web centrati sui dati" and consists of some exercises on the logical design of a data-intensive web application .
The final grade is obtained by the weighted average of the grades collected on the three modules of the course: the module "Teoria: basi di dati" (weight 3/5), the module "Teoria: siti web centrati sui dati" (weight 1/5) and the module "Laboratorio" (weight 1/5).

Teaching aids

Documents

Studying