DATABASE MANAGEMENT SYSTEMS

Second cycle degree in COMPUTER ENGINEERING

Campus: PADOVA

Language: English

Teaching period: Second Semester

Lecturer: NICOLA FERRO

Number of ECTS credits allocated: 9


Syllabus
Prerequisites: + Good knowledge of the Java programming language
+ Knowledge of computer networks
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.
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