Course Unit Profile

<--- Back to Course Diagram

Basic Information

Course Unit Title: DATABASE PROGRAMMING

Course Unit Code: 254AA

Level of course unit

Second Cycle (Laurea magistrale) Degree Programme in Business Informatics

Year of study

First year

Semester when the course is delivered

Second semester

Number of ECTS credits allocated: 6

Name of Lecturer(s):

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

To be defined.

Language of instruction

Italian

General Information

Learning outcomes

The student who successfully completes the course will have the ability to collect requirements for a database application. Will also have the ability to design a database and a database application, and to implement it as an interenet application, using commercial technology. The student will also acquire the ability to do group work.

Course contents

Requirements collection and analysis for database application.
Conceptual and logical design of databases and database applications.
Architecture of internet database applications.
Database programming, with specific reference to the PL/SQL language.

Specific Information

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

Prerequisites

None.

Co-requisites

None.

Prerequisite for

None.

Mode of delivery

Delivery

face to face

Attendance

Mandatory

Teaching methods

Learning activities

Recommended or required reading

A. Albano, G. Ghelli e R. Orsini, Fondamenti di basi di dati, Zanichelli, Bologna, 2005.
PL/SQL reference manual.

Assessment methods and criteria

Assessment methods

Further information

The student will be evaluated on the basis of some artifacts - design documents and running code - which she/he will prepare during the semester in strict collaboration with other students of a small group, and with some weaker form of collaboration with all the other groups attending the same course. All such artifacts will have to be ready before the day that is fixed for the exam.

Assessment criteria

The student will be assessed on the basis of the quality of the artifacts that will be presented. The design documents will be judged on the basis of clarity, completeness, and adherence to the requirements. The code will be assessed on the basis of adherence to the requirements and to the project standards, robustness, and on the basis of the quality of its user interface.

Work placement

No

<--- Back to Course Diagram