Università degli Studi di Napoli "Parthenope"

Teaching schedule

Academic year: 
2015/2016
Belonging course: 
Course of Bachelor's Degree Programme on COMPUTER SCIENCE
Disciplinary sector: 
INFORMATICS (INF/01)
Credits: 
9
Year of study: 
2
Teachers: 
Cycle: 
Second semester
Hours of front activity: 
72

Language

Course description

The course aims to give the essential skills to design, implement and manage a relational Database through a suitable DBMS.
The SQL language is extensively studied both during the laboratory than to implement the group project, consisting in a working Database developed in the Oracle DBMS environment.
Knowledge and comprehension:
a good autonomy in designing and managing a relational DBMS through SQL and PL/SQL is required.
Applicative skills:
the ability to solve non trivial SQL queries and triggers, as well as designing EE/R conceptual models is expected.
Communication:
the project must be rigidly documented with a precise language and UML diagrams.

Prerequisites

Procedural programming skills acquired through the first course on programming with lab.

Syllabus

Information systems, Database and DBMS; conceptual modeling through EE/R diagrams; the relational model; integrity constraints; EE/R diagrams mapping to relational; elements of software design; Relational Algebra; SQL: DDL, DML, QL; PL/SQL: triggers and procedures;Normal Forms; elements of concurrency.

Teaching Methods

Textbooks

Main references:
Shamkant B. Navathe Ramez A. Elmasri. Sistemi di Basi di Dati - Complementi. Addison Wesley, 4 edition, 2005.
Shamkant B. Navathe Ramez A. Elmasri. Sistemi di Basi di Dati - Fondamenti. Addison Wesley, 6 edition, 2011.
Tom Nadeau Sam Lightstone, Toby Teorey. Physical Database Design. Morgan Kaufmann, 2007.
Michael McLaughlin Scott Urman, Ron Hardman. PL/SQL programming. Oracle press, 2004.

References for some specific topics:
Antonio Albano. Costruire sistemi per Basi di Dati. Addison Wesley, 1 edition, 2001. [Cel14] Joe Celko. Joe Celko’s complete guide to NoSQL. Morgan Kaufmann, 1 edition, 2014.
Annalisa Franco Dario Maio, Stefano Rizzi. Esercizi di progettazione di Basi di Dati. Progetto Leonardo, 2 edition, 2005.
Andrea Steelman Joel Murach. Java servlets and JSP. Murach and associated, 2 edition, 2008.
Dario Maio Paolo Ciaccia. Lezioni di Basi di Dati. Progetto Leonardo, 1 edition, 1995.

Further educational material (videolessons of the whole theory course and some pdf files) is available on http://e-scienzeetecnologie.uniparthenope.it/

Learning assessment

The final verification is organized in three steps: the written test (maximum 30/30, minimum 16/30); the project (maximum 5/5, minimum 3/5); the oral test (maximum 30/30, minimum 18/30). The final score will be averaged, further details are on the e-learning platform.

More information