Università degli Studi di Napoli "Parthenope"

Teaching schedule

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

Language

While the course is taught in italian, the exam can be in English.

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 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.
Communication skills:
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.

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.

Teaching Methods

Taught classes with blackboard and chalk and practical exercises in lab using PCs. There are no slides and active participation of students is encouraged.

Textbooks

Main references:
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/

Learning assessment

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.

More information

Team work on the project is encouraged. Further details are in the e-learning platform.