Data elaboration laboratory (2015/2016)

Course code
4S000708
Name of lecturer
Maurizio Boscaini
Coordinator
Maurizio Boscaini
Number of ECTS credits allocated
3
Other available courses
Academic sector
NN - -
Language of instruction
Italian
Period
Semestrino IIA, Semestrino IIB

Lesson timetable

Learning outcomes

Provide the basic knowledge, theoretical and practical, for the creation of a database with Microsoft
Access and process data with Microsoft Excel.

Syllabus

Difference between information systems and computer systems.
Models of conceptual design:
- Database, DBMS (DataBase Management System)
- Entities
- Associations
- Cardinality (one-to-one, one-to-many, many-to-many)
- E-R diagram (Entity-Relationship)
- Relationships
Practical exercises in the laboratory with the use of Microsoft Access and Excel.

Reference books
Author Title Publisher Year ISBN Note
R. Elmasri, S.H. Navathe Sistemi di Basi di Dati: Fondamenti (Edizione 6) Pearson 2011 978-88-7192-628-5 Dispense fornite dal docente. Appunti delle lezioni.

Assessment methods and criteria

The exam is divided into two parts:
1. multiple choice test;
2. creation of a database with Access and a spreadsheet (calculations, graphs, etc.) with Excel.

Teaching aids

Documents

STUDENT MODULE EVALUATION - 2015/2016