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
|