Faculty: ENGINEERING
First level degree Name: MANAGEMENT ENGINEERING
First level degree Internet Address:
Course Title: DATA BASE SYSTEMS
GISS Codex: 27000261
Sharing: None
Composition in modules: NONE
Scientific Discipline Sector: ING-INF/05
Professor/Research in charge: / PROF. ESTER ZUMPANO
Teaching Position / ASSOCIATED PROFESSOR
ECTS:6
Teaching Hours: N° 65 / Lectures Hours: 26
Exercises Hours: 20
Laboratorio Hours:19
Self study hours: N° 85
Tipology: Other Activities
Teaching Language: Italian
Collocazione: 1st Year, 1st Semester
Prerequirement:None
Objectives of the course:
The main objective of this course is to provide students with the background to design, implement, and use database management systems. The course will focus on relational database management systems (DBMSs) and the use of non-procedural query languages such as SQL. We will also study relational algebra, design theory and normalization, using SQL in host languages like Java. The student will also gain practical experience in designing and programming real-world database applications.
Topics Include:Evolution of Database Management Systems; Entity Relationship Modeling and Design; Relational Data Model and Relational Algebra; Structured Query Language; Client Server and Distributed databases
Lecture contents
Basic Concepts.
This part introduces basic terminology, the notion of database systems, data independence,data abstraction, the advantage of database systems, data models (E-R model, therelational model, etc.), data storage and query processing, and database system architecture.
The Relational Data Model.
This part deals with the formal theory underlying relational database systems. The threeaspects of the relational data model, namely, relational data structure, relational datamanipulation, relational data integrity, are discussed. We will cover relational algebra in
this part.
The SQL language.
This part deals with the declarative SQL language.
Database Design.
This part deals with E-R modeling method for database design. The functional dependencybased normalization approach to relational databases design is discussed in detail. Thisincludes the notion of normal forms, the algorithms to perform decomposition to 3NF, to
BCNF, etc.
Exercises contents:
Exercise on E-R model, Relational Data Model, Relational Algebra, Sql, Functional Dependencies, Normal Forms.
Laboratory contents:
Use of real DBMS(s). database Design Tool. Use of SQL in host languages such as Java.
Attendance in class: Required
Teaching performance:In the lecture hall, with blackboard and transparencies, occasionally software simulation tools will be used
Evaluation Assessement: Final written examination
Bibliografy and Recommended reading:
In Italian:

P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone: Basi di dati: Modelli e Linguaggi di Interrogazione, McGraw-Hill Italia, 2009

  • Ramez Elmasri, Shamkant Navathe: Sistemi di Basi di Dati, Pearson/Addison Wesley
In English:
  • A First Course in Database Systems, by Ullman and Widom
  • Fundamentals of database systems by Elsmasri and Navathe.
  • Database management systems by Raghu Ramakrishnan.
  • Foundations of database systems by Abiteboul, Hull and Vianu.

Time table and Lesson Rooms: /
Exams calendar:

1