First cycle
degree courses
Second cycle
degree courses
Single cycle
degree courses
Faculty of Engineering
COMPUTER ENGINEERING
Course unit
DATABASE
IN06100770, A.A. 2012/13

Information concerning the students who enrolled in A.Y. 2012/13

Information on the course unit
Degree course Second cycle degree in
COMPUTER ENGINEERING
IN0521, Degree course structure A.Y. 2009/10, A.Y. 2012/13
N0
bring this page
with you
Number of ECTS credits allocated 9.0
Type of assessment Mark
Course unit English denomination DATABASE
Mandatory attendance No
Language of instruction Italian
Branch PADOVA
Single Course unit The Course unit CANNOT 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
IN06100770 DATABASE NICOLA FERRO IN0524

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

Course unit organization
Period Second semester
Year 1st Year
Teaching method frontal

Type of hours Credits Teaching
hours
Hours of
Individual study
Shifts
Lecture 9.0 72 153.0 No turn

Calendar
Start of activities 04/03/2013
End of activities 15/06/2013
Show course schedule 2019/20 Reg.2009 course timetable

Examination board
Board From To Members of the board
7 A.A. 2015/2016 01/10/2015 15/03/2017 FERRO NICOLA (Presidente)
AGOSTI MARISTELLA (Membro Effettivo)
DI NUNZIO GIORGIO MARIA (Supplente)
SILVELLO GIANMARIA (Supplente)
6 A.A. 2014/2015 01/10/2014 15/03/2016 FERRO NICOLA (Presidente)
DI NUNZIO GIORGIO MARIA (Membro Effettivo)
AGOSTI MARISTELLA (Supplente)
01/10/2013 15/03/2015 FERRO NICOLA (Presidente)
DI NUNZIO GIORGIO MARIA (Membro Effettivo)
AGOSTI MARISTELLA (Supplente)

Syllabus
Prerequisites:
Target skills and knowledge:: The main goal of the course is to learn to design and develop a distributed application for the management and access to structured data over the time.

This objective translates into the following competencies to be acquired:
- solid background on methods concerning databases in terms of data models, their features, and design techniques
- capability to carry out a (semi-)realistic project for the design and development of an application over a relational database management system (RDBMS)
- capability to design and develop a Web-based application by using the Java programming language
Course unit contents: - General concepts about database management systems
+ Basic notions about computer networks and the client/server paradigm
- Gathering and analysis of user requirements
- The Entity-Relationship Model
+ conceptual design
- The Relational Model (relational database management systems)
+ logic design
+ functional dependencies and normalization
+ relational algebra
- The SQL language
+ data definition language
+ data manipulation language
- Programmatic access to databases
+ the JDBC API for the Java language
- Development of a Web application
+ Java servlet
+ Java server pages
+ Java portlet
Planned learning activities:
Textbooks: Elmasri, R. A. and Navathe, S. B., Sistemi di basi di dati. Fondamenti. 6/ed. --: Pearson, 2011. Testo di riferimento Cerca nel catalogo
Atzeni, P., Ceri, S., Paraboschi, S., and Torlone, R., Basi di dati - Modelli e linguaggi di interrogazione. 3/ed. --: McGraw-Hill, 2009.
Batini, C., De Petra, G., Lenzerini, M., and Santucci, G., La progettazione concettuale dei dati. --: Franco Angeli, 2002.
Batini, C., Ceri, S., and Navathe, S. B., Conceptual Database Design. An Entity-Relationship Approach. --: The Benjamin/Cummings Publishing Company, 1992. Cerca nel catalogo
Albano, A., Ghelli, G., and Orsini, R., Basi di dati relazionali e a oggetti. --: Zanichelli, 1997. Cerca nel catalogo
Teaching methods: The course consists of:
- lectures
- labs to learn the use of the different software tools
- work group activities to develop a (semi-)realistic project
- labs to learn the different phases of the design of a database application
Assessment criteria: - Written exam: questions on theory of databases, exercise about the design of a database application
- Oral presentation of the activities of the project group
- Oral presentation of the prototype system developed by the project group
Further information: