Basi di Dati e Sistemi Informativi I
Programma dettagliato del corso
Introduction to DB and DBMS
Relational databases: the relational model
The structure of the relational model
Integrity constraints
Relational Algebra
Union, intersection, difference, renaming, selection, projection
Join, queries, equivalence of algebraic expressions, algebra with null values, views
SQL
Data definition in SQL
SQL queries
Data modification in SQL, other definitions of data in SQL, access control
Design techniques and models
The database design process
The Entity-Relationship model
Documentation of E-R schemas
Conceptual design
Requirements collection and analysis
General criteria for data representation
Design strategies
Quality of a conceptual schema
A comprehensive method for conceptual design
An example of conceptual design
CASE tools for database design
Logical design
Performance analysis on E-R schemas
Restructuring of E-R schemas
Translation into the relational model
An example of logical design
Logical design using CASE tools
Normalization
Redundancies and anomalies
Functional dependencies
Boyce-Codd normal form
Decomposition properties
Third normal form
Database design and normalization
Technology of a database server
definition of transaction
concurrency control
buffer management
reliability control system
physical access structures
query optimization
definition of indexes in SQL
Distributed architectures
Client-server architecture
Distributed database
Technology of distributed database
Two-phase commit protocol
Ineroperability
Co-operation among pre-existing systems
Parallelism
Replicated databases
Last update 19-12-00
BACK