N90308 Information Structure and Management

Scuola di Ingegneria Industriale
Syllabus
Academic Year 2018/19 Second Semester

foto
Docente TitolareGiacomo Buonanno
E-mailbuonanno@liuc.it
Office"Torre" (main tower), 2nd floor
Phone0331 572323

Learning Objectives

At the end of the course students will be able to use, implement and design databases and database management systems.
The DataBase design will be afforded both at the conceptual and logical design level.

Learning targets

At the end of the course students will be able to use, implement and design databases and database management systems.
The DataBase design will be afforded both at the conceptual and logical design level.

Course Content

The course is organized into the following parts:
  1. Introduction to DataBases and DataBase Management Systems (DBMS)
  2. DB design at the conceptual level (ER model)
  3. DB design at the logical level (relational model)
  4. Implementation of simple DBs using appropriate tools (MS Access)

Course Delivery

The course includes:

  1. lectures, aiming at presenting design methodologies both at the conceptual and the logical design level,
  2. practical lessons in computer laboratory to apply the methodoligies to actual DB implementation.

Course Evaluation

Evaluation is based on different assignments, written test and practical solution of given problems.

Syllabus

Session 101
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

Introduction to DB and DBMS concepts
ER Model for DB design at the conceptual level

Readings:

Session 102
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

Conceptual design with ER model - Cases [1/2]

Readings:

Session 103
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

Conceptual design with ER model - Cases [2/2]

Readings:

Session 104
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

Relational Model & Relational Algebra as a Query Language

Readings:

Session 105
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

SQL [1/2]

Readings:

Session 106
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

SQL [2/2]

Readings:

Session 107
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

Translation from conceptual (ER) level design to logical (relational) level design

Readings:

Session 108
Hours of lesson: 4
Instructor: G. Buonanno

Topics:

Possible seminar on ICT Security [with the cooperation of an external expert]

Readings:

Session 201
Hours of lesson: 4
Instructor: L. Cremona

Topics:

Actual DB design and implementation using MySQL and/or Microsoft Access [1/6]

Readings:

Session 202
Hours of lesson: 4
Instructor: L. Cremona

Topics:

Actual DB design and implementation using MySQL and/or Microsoft Access [2/6]

Readings:

Session 203
Hours of lesson: 4
Instructor: L. Cremona

Topics:

Actual DB design and implementation using MySQL and/or Microsoft Access [3/6]

Readings:

Session 204
Hours of lesson: 4
Instructor: L. Cremona

Topics:

Actual DB design and implementation using MySQL and/or Microsoft Access [4/6]

Readings:

Session 205
Hours of lesson: 4
Instructor: L. Cremona

Topics:

Actual DB design and implementation using MySQL and/or Microsoft Access [5/6]

Readings:

Session 206
Hours of lesson: 4
Instructor: L. Cremona

Topics:

Actual DB design and implementation using MySQL and/or Microsoft Access [6/6]

Readings:


in order to have access to the complete syllabus please enter on the student self service