DATA BASES WITH LAB. DATA BASES
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.
the ability to solve non trivial SQL queries and triggers, as well as designing EE/R conceptual models is expected.
the project must be rigidly documented with a precise language and UML diagrams.
Procedural programming skills acquired through the first course on programming with lab.
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.
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/
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.