DATA BASES WITH LAB. DATA BASES
While the course is taught in italian, the exam can be in English.
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 understanding:
a good autonomy in designing and managing a relational DBMS through SQL and PL/SQL is required.
Ability to apply knowledge and understanding:
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.
The course will introduce and treat in depth relational DBMS so to give to the students the ability to properly design, implement and manage an averagely complex relational database.
Taught classes with blackboard and chalk and practical exercises in lab using PCs. There are no slides and active participation of students is encouraged.
Shamkant B. Navathe Ramez A. Elmasri. Fundamentals of Database Systems. Addison Wesley, 6 edition, 2010.
Michael McLaughlin Scott Urman, Ron Hardman. PL/SQL programming. Oracle press, 2004.
Annalisa Franco Dario Maio, Stefano Rizzi. Esercizi di progettazione di Basi di Dati. Progetto Leonardo, 2 edition, 2005.
Further educational material (videolessons of the whole course and some solved exercises) is available on http://e-scienzeetecnologie.uniparthenope.it/
The final verification is organized in two steps: the practical test to be performed with a PC in lab and the group project, that is the development ex novo of a complete Database on a freely chosen subject. The final score will be averaged, further details are on the e-learning platform.
Team work on the project is encouraged. Further details are in the e-learning platform.