Learning objectives
The course aims to bring students to know and understand the theoretical and practical basis for the management of databases based on the relational model, and the basic techniques necessary for the development of websites
that interact with databases.
Students, at the end of the course, must demonstrate that they have acquired such knowledge, by using these tools to build a simple website that solves a practical problem which requires querying and editing the contents of a database .
Prerequisites
None
Course unit content
Introduction to the DBMSs
The Relational Model
SQL
Database Design
Web Programming and Tools
Full programme
1) Introduction
Relational Databases: Model and languages
2) The relational model
3) Relational Algebra
4) SQL: basic concepts
5) SQL: advanced features
6) SQL for the applications
Designing databases
7) Methods and models for database design
8) Conceptual design
9) Logical design
10) Normalization
Web tools and programming
11) Databases and the web
12) Apache, MySQL, PHP
13) Fundamentals of PHP
14) Accessing a MySQL database using PHP
Bibliography
Atzeni Ceri Paraboschi Torlone
Basi di dati: Modelli e linguaggi di interrogazione (3a Ed.)
McGraw-Hill Italia, 2009
Luke Welling Laura Thomson
MySQL - Tutorial
Pearson Education Italia 2004
J. Greenspan, B. Bulger
Sviluppare applicazioni per database con MySQL/PHP
Apogeo 2001
Teaching methods
Theoretical knowledge will be acquired through lectures. At least 10 hours of laboratory practice will allow students to acquire practical skills about web programming and SQL querying.
Assessment methods and criteria
Two written tests, also offered early as intermediate tests: the first concerns the theory of the relational model and SQL, and the second concerns database design.
Students who have passed both tests will be assigned a vote equal to the average of the marks obtained in the two tests. The full test is passed if the average is greater than or equal to 18 and if the lower vote in the written tests is greater than or equal to 15.
One can also deliver a project on web-based database access.
The project assigns an additional score ranging from -2 (no project developed) to +3 points.
Other information
- - -
