Università degli Studi di Urbino Carlo Bo / Portale Web di Ateneo


DATABASES
BASI DI DATI

Databases
Informatica Applicata

A.Y. Credits
2012/2013 12
Lecturer Email Office hours for students
Maurizio Maffi Tuesday morning on appointment.

Assigned to the Degree Course

Date Time Classroom / Location

Learning Objectives

The objective of this course is to introduce information systems and to describe the data models and techniques of conceptual design, logical and physical development and management of databases.

Program

01. Introduction to Information Systems:
01.01 Knowledge management and information systems.
01.02 Data Base Management Systems (DBMS).
01.03 Life cycle of DBMS.

02. Conceptual design of databases:
02.01 Analysis of the requirements.
02.02 Model Entity-Relationship (E-R).
02.03 Strategies project.
02.04 Integration of diagrams.

03. Logical design of databases:
03.01 Relational model.
03.02 Optimization of E-R models.
03.03 Restoration of E-R models.
03.04 From R-E model to the relational model.
03.05 Normalization.

04. Query languages​​:
04.01 Relational algebra: basic operators.
04.02 Relational algebra: auxiliary operators.
04.03 Relational Calculus.
04.04 Structured Query Language (SQL).
04.05 Subqueries in SQL.
04.06 Language Data Definition in SQL.
04.07 Language of updating data in SQL.
04.08 Views in SQL.

05. Secondary storage devices and file management:
05.01 Secondary Storage Devices.
05.02 Organization of the files.
05.03 Indexing.
05.04 B-tree.
05.05 B +-tree.
05.06 Organizations static hash.
05.07 Organization Dynamic hash.

06. Architecture of DBMS:
06.01 Transactions and anatomy of the DBMS.
06.02 Management of failures and recovery techniques.
06.03 Management of the scheduling.
06.04 Theory of serializability.
06.05 Serializability and competition.
06.06 Locking techniques.
06.07 Database and distributed transactions.
06.08 Methods of joins.
06.09 Optimization of queries.

07. Laboratory activities:
07.01 Introduction to MySQL on the Linux operating system.
07.02 Architecture of the MySQL server and client.
07.03 Development MySQL database driven.
07.04 Access to MySQL database using PHP.

Bridging Courses

Algorithms and Data Structures, Computer Architecture, Procedural and Logic Programming.

Teaching, Attendance, Course Books and Assessment

Teaching

Theory lectures and laboratory exercises, both face-to face and on-line.

Attendance

Although recommended, course attendance is not mandatory.

Course books

- Atzeni, Ceri, Paraboschi, Torlone, "Basi di Dati: Modelli e Linguaggi di Interrogazione", McGraw-Hill, 2006
(copre le sezioni 01, 02, 03, 04 del programma).
- Atzeni, Ceri, Fraternali, Paraboschi, Torlone, "Basi di Dati: Architetture e Linee di Evoluzione", McGraw-Hill, 2007
(copre le sezioni 05, 06 del programma).
- Dorbolò, Guidi, "Guida a SQL", McGraw-Hill, 2004.
MySQL Reference Manual.

Assessment

Individual laboratory project, written exam and (optional) oral exam.

Disability and Specific Learning Disorders (SLD)

Students who have registered their disability certification or SLD certification with the Inclusion and Right to Study Office can request to use conceptual maps (for keywords) during exams.

To this end, it is necessary to send the maps, two weeks before the exam date, to the course instructor, who will verify their compliance with the university guidelines and may request modifications.

Notes

The course is offered both face-to-face and on-line within the Laurea Degree Program in Applied Computer Science.

« back Last update: 17/10/2012

Il tuo feedback è importante

Raccontaci la tua esperienza e aiutaci a migliorare questa pagina.

Il tuo 5x1000 per sostenere le attività di ricerca

L'Università di Urbino destina tutte le risorse che deriveranno da questa iniziativa alla ricerca scientifica ed al sostegno di giovani ricercatori.

15 22

Se sei vittima di violenza o stalking chiama il 1522, scarica l'app o chatta su www.1522.eu

Il numero, gratuito è attivo 24 h su 24, accoglie con operatrici specializzate le richieste di aiuto e sostegno delle vittime di violenza e stalking.

Posta elettronica certificata

amministrazione@uniurb.legalmail.it

Social

Università degli Studi di Urbino Carlo Bo
Via Aurelio Saffi, 2 – 61029 Urbino PU – IT
Partita IVA 00448830414 – Codice Fiscale 82002850418
2024 © Tutti i diritti sono riservati

Top