| Lectures and exercises |
hours |
| Topics |
Specific contents |
|
| Introduction to databases |
Information systems, information and data. Databases and management systems. Dat models. |
2
|
| The relational model |
Mathematical bases of the relational model. Structure and integrity constraints of the relational model. |
4
|
| Relational algebra |
Algebra operators. Queries in relational algebra. |
4
|
| The language SQL |
Data definition in SQL. Query in SQL. Data manipulation in SQL. SQL embedded in a programming language. |
10
|
| Conceptual design |
The Entity-Relationship (ER) model. Design strategies. Qualities of a conceptual scheme. Examples. |
6
|
| Logical design |
Restructuring of ER models. Translation of restructured ER schemes in the relational model. |
4
|
| Database normalization |
Redundancies and anomalies. Functional dependencies. Normal forms: 3NF and BCNF. Properties of the decompositions. |
4
|
| Use of the DBMS PostgreSQL |
Installation and use of PostgreSQL (v.8). Use of the client PgAdminIII. PostgreSQL features. |
2
|
| SQL exercises |
Implementation of instructions and queries in SQL using PostgtreSQL. |
6
|
| Database access through the web |
The language PHP. Interaction of PHP and PostgreSQL. |
2
|
| Total hours for lectures and exercises |
44 |
| for exercises only |
10 |
|
Further educational activities
|
hours
|
| Labs |
6 |
| Tutorials / Seminars |
0 |
| Workshops |
0 |
| Guided tours |
0 |
| |
|
| Total hours for further educational activities |
6 |
| Total hours |
50
|