First cycle
degree courses
Second cycle
degree courses
Single cycle
degree courses
School of Engineering
COMPUTER ENGINEERING
Course unit
DATABASE MANAGEMENT SYSTEMS
INP6076257, A.A. 2017/18

Information concerning the students who enrolled in A.Y. 2017/18

Information on the course unit
Degree course Second cycle degree in
COMPUTER ENGINEERING
IN0521, Degree course structure A.Y. 2009/10, A.Y. 2017/18
N0
bring this page
with you
Number of ECTS credits allocated 9.0
Type of assessment Mark
Course unit English denomination DATABASE MANAGEMENT SYSTEMS
Department of reference Department of Information Engineering
Mandatory attendance No
Language of instruction English
Branch PADOVA
Single Course unit The Course unit can be attended under the option Single Course unit attendance
Optional Course unit The Course unit can be chosen as Optional Course unit

Lecturers
Teacher in charge NICOLA FERRO ING-INF/05

Mutuated
Course unit code Course unit name Teacher in charge Degree course code
INP6076257 DATABASE MANAGEMENT SYSTEMS NICOLA FERRO IN2371
INP6076257 DATABASE MANAGEMENT SYSTEMS NICOLA FERRO IN2371
INP6076257 DATABASE MANAGEMENT SYSTEMS NICOLA FERRO IN2371

ECTS: details
Type Scientific-Disciplinary Sector Credits allocated
Core courses ING-INF/05 Data Processing Systems 9.0

Mode of delivery (when and how)
Period Second semester
Year 1st Year
Teaching method frontal

Organisation of didactics
Type of hours Credits Hours of
teaching
Hours of
Individual study
Shifts
Lecture 9.0 72 153.0 No turn

Calendar
Start of activities 26/02/2018
End of activities 01/06/2018

Syllabus
Prerequisites: + Good knowledge of the Java programming language
+ Knowledge of computer networks
Target skills and knowledge: The goal is to learn to design and develop a distributed application for the management of and access to structured data over time.

The achievement of this goal consists of:
- acquisition of strong competences concerning databases, their data models and properties, formal languages for querying a database, and suitable methodologies for designing a database;
- acquisition of the capability of carrying out an actual project for the design and development of a database application using a relational database management system (RDBMS)
Examination methods: + Written exam (individual exam)
--- questions on the topics covered during the lectures
--- exercise about designing and querying a database

+ Implementation of a database application through individual homeworks.
Assessment criteria: The evaluation will be based on the comprehension and knowledge of the notions and methodologies about databases, on the capability of facing the different phases of the design of a database, on the comprehension and knowledge of the models and languages for querying a database, on the implementation of a project for the development of a database application.
Course unit contents: + Overview of database management systems
--- Recap on computer networks and client/server model
--- Notions on distributed applications and their architectures
--- Notions on Web applications

+ Gathering, analysis and design of user requirements

+ The Entity-Relationship (ER) model
--- conceptual design

+ The Relational model and the relational database management systems
--- logical design
--- functional dependencies and normalization
--- relational algebra
--- mapping from conceptual to relational model

+ The SQL language
--- data definition language
--- data manipulation language

+ Programmatic access to databases
--- the JDBC APIs for the Java programming language
Planned learning activities and teaching methods: + Lectures

+ Labs
--- use of an open source database management system (PostgreSQL);
--- programmatic access to databases (JDBC)

+ Seminars
Additional notes about suggested reading: The teaching material consists of:
- reference book
- instructor's slides
- suggested readings

Suggested readings:
+ Ramez A. Elmasri, Shamkant B. Navathe (2011). Sistemi di basi di dati. Fondamenti (6 edizione). Pearson Education, Italia.
+ Ramakrishnan, R. and Gehrke, J. (2004). Sistemi di basi di dati. McGraw- Hill, Milano, Italia.
+ Batini, C., Ceri, S., and Navathe, S. B. (1992). Conceptual Database Design. An Entity-Relationship Approach. The Benjamin/Cummings Publishing Company, Inc., Redwood City (CA), USA.
+ Batini, C., De Petra, G., Lenzerini, M., and Santucci, G. (2002). La progettazione concettuale dei dati. Franco Angeli, Milano.
+ Atzeni, P., Batini, C., and De Antonellis, V. (1985). La teoria relazionale dei dati. Boringhieri, Torino, Italia.
+ Celko, J. (2011). Joe Celko's SQL for Smarties: Advanced SQL Programming. Morgan Kaufmann Publishers, San Francisco (CA), USA.
Textbooks (and optional supplementary readings)
  • Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone, Basi di dati. Italia: McGraw Hill, 2014. iv edizione
  • Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 7th Edition. --: Pearson, 2016.