Politecnico di Torino
Politecnico di Torino
   
Login  
it
Politecnico di Torino
Academic Year 2016/17
02EYONL, 02EYONM, 02EYOQR
Database and company information systems
1st degree and Bachelor-level of the Bologna process in Industrial Production Engineering - Torino/Athlone
1st degree and Bachelor-level of the Bologna process in Industrial Production Engineering - Torino/Barcellona
1st degree and Bachelor-level of the Bologna process in Industrial Production Engineering - Torino/Nizza
Teacher Status SSD Les Ex Lab Tut Years teaching
Di Carlo Stefano ORARIO RICEVIMENTO O2 ING-INF/05 23.5 20 16.5 0 7
SSD CFU Activities Area context
ING-INF/05 6 A - Di base Matematica, informatica e statistica
Subject fundamentals
The goal of the course is provide an introduction to databases (i.e., the set of technologies used to store data), their design methodologies and their integration into distributed environments. Moreover, the course introduces basic notion on enterprise information systems.
Expected learning outcomes
Knowledge of relational databases, their design methods and their use in the development of Web Applications.
Knowledge of information systems
Design of relational databases employed in industrial and commercial applications
Management and use of relational databases in industrial and commercial applications
Prerequisites / Assumed knowledge
Basic programming and computer science foundamentals
Contents
INTRODUCTION
-- Course overview
-- Introduction to data bases
RELATIONAL MODEL AND RELATIONAL ALGEBRA
-- Relational model
-- Relational algebra
THE SQL LANGUAGE: BASIC CONCEPTS
-- The SELECT instruction: basic use
-- Nested queries
-- Set operators
-- Update instructions
-- Table management
DESIGN OF WEB APPLICATION BASED ON DATABASES
-- Introduction to HTML
-- Introduction to PHP
-- Development of applications based on Apache/PHP/mysql
DATABASE DESIGN
-- Entity-Relationship model
-- Conceptual design
-- Logic design
Delivery modes
The course includes both lectures and a set of labs.
Labs focus on the design of web application based on the PHP language and supported by databases. They enable the student to apply the concept presented during the lectures.
Texts, readings, handouts and other learning resources
All topics covered during lectures and labs are supported by electronic material provided on the course website.
Assessment and grading criteria
The exam is split into two parts:
1. A written exam that focus on the knowledge of the SQL language and the relational algebra
2. An homework consisting in the development of a web application based on a database using the technologies presented during the labs:
a. The requirements of the application are provided by the students and approved by the professor
b. When completed, the project is discussed with the professor
c. The project can be developed in groups of maximum 3 students.

The exam is scored as follows:
1. Written exam: maximum score 30/30 with minimum threshold of 15/30. It represents 30% of the final score
2. Homework and discussion: maximum score 30/30 with minimum threshold of 15/30. It represents 70% of the final score.

The final score is the weighted average of the two previous scores.

Programma definitivo per l'A.A.2016/17
Back



© Politecnico di Torino
Corso Duca degli Abruzzi, 24 - 10129 Torino, ITALY
WCAG 2.0 (Level AA)
Contatti