DATA BASE

Scienze Ambientali DATA BASE

0512700015
DEPARTMENT OF CHEMISTRY AND BIOLOGY "ADOLFO ZAMBELLI"
EQF6
ENVIRONMENTAL SCIENCES
2022/2023

YEAR OF COURSE 2
YEAR OF DIDACTIC SYSTEM 2016
SPRING SEMESTER
CFUHOURSACTIVITY
540LESSONS
112EXERCISES
Objectives
KNOWLEDGE AND UNDERSTANDING
THE STUDENT IS EXPECTED TO ACQUIRE KNOWLEDGE ON:
•MODELS, LANGUAGES AND TECHNOLOGIES FOR DATABASE DESIGN, IMPLEMENTATION, AND MANAGEMENT.

APPLYING KNOWLEDGE AND UNDERSTANDING
THE STUDENT IS EXPECTED TO BE ABLE TO:
•DESIGN AND IMPLEMENT GOOD QUALITY DATABASES STARTING FROM THE USER REQUIREMENTS,
•EXTRACT INFORMATION FROM DATABASES,
•DESIGN SOFTWARE APPLICATIONS INTERACTING WITH DATABASES,
•PRODUCE A SUITABLE DOCUMENTATION OF THE DATABASE DESIGN AND IMPLEMENTATION PROCESS.
Prerequisites
THE COURSE ASSUMES KNOWLEDGE OF:
•FUNDAMENTALS OF COMPUTER SCIENCE
Contents
CONCEPTUAL AND LOGICAL MODELLING OF DATABASES:
•THE ENTITY/RELATIONSHIP MODEL (5 hours Frontal)
•THE RELATIONAL DATA MODEL (5 hours Frontal)
•TECHNIQUES FOR RESTRUCTURING CONCEPTUAL DATA SCHEMAS (5 hours Frontal)
•RULES FOR MAPPING ER TO RELATIONAL MODEL (5 hours Frontal)
•AUTOMATED TOOLS SUPPORTING DATABASE DESIGN ACTIVITIES (5 hours Frontal)

QUERY LANGUAGES AND DESIGN METHODOLOGIES:
•RELATIONAL ALGEBRA (5 hours Frontal, 4 hours tutorial)
•THE SQL LANGUAGE (5 hours Frontal, 4 hours tutorial)
•NORMALIZATION RULES FOR RELATIONAL DATABASES (5 hours Frontal, 4 hours tutorial)
Teaching Methods
THE COURSE INCLUDES:
•THEORETICAL-METHODOLOGICAL FRONTAL LECTURES (5 CFUS/40 HOURS), TO TRANSFER THE KNOWLEDGE RELATED TO THE COURSE CONTENTS
•LABORATORY SESSIONS (1 CFUS/312 HOURS) FOCUSSING ON PRACTICAL ACTIVITIES, WHERE STUDENTS COOPERATE TO SOLVE EXERCISES, UNDER THE SUPERVISION OF THE INSTRUCTOR.

THE CONDUCT OF THE EXERCISES AND THE FREQUENCY OF THE TEACHING ARE STRONGLY RECOMMENDED.
Verification of learning
THE EXAM IS ADDRESSED TO EVALUATE THE INDIVIDUAL LEARNING ABOUT DATABASE FUNDAMENTALS AND APPLICATIONS. THE ASSESSMENT WILL BE BASED ON:
•WRITTEN AND ORAL EXAMINATION TO EVALUATE THE GAINED THEORETICAL KNOWLEDGE ACQUIRED ON DATABASE DESIGN AND DEVELOPMENT ASPECTS.

THE MINIMUM MARK (18/30) IS AWARDED WHEN THE STUDENT DEMONSTRATES A LIMITED KNOWLEDGE OF THE FUNDAMENTAL AND APPLICATIVE CONCEPTS OF THE DATABASE.

THE MAXIMUM VOTE (30/30) IS AWARDED WHEN THE STUDENT SHOWS A COMPLETE AND IN-DEPTH KNOWLEDGE OF THE FUNDAMENTAL CONCEPTS OF DATABASE AND IS ABLE TO ESTABLISH CONNECTIONS BETWEEN THESE AND THE DESIGN AND DEVELOPMENT ASPECTS.

PRAISE MAY BE ATTRIBUTED TO STUDENTS WHO REACH THE MAXIMUM VOTE OF 30/30 AND WHO PROVE THAT THEY ARE ABLE TO APPLY AUTONOMOUSLY KNOWLEDGE AND SKILLS ACQUIRED EVEN IN CONTEXTS OTHER THAN THOSE PROPOSED IN THE LESSON
Texts
COURSE BOOKS:
•P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI - MODELLI E LINGUAGGI DI INTERROGAZIONE”, 4A EDITION, MCGRAW-HILL, 2013
•R. A. ELMASRI, S. B. NAVATHE, “SISTEMI DI BASI DI DATI – FONDAMENTI”, 6A EDITION, ADDISON WESLEY, 2011

ADDITIONAL BOOKS:
•BEAULIEU, “LEARNING SQL”, 2A EDITION, O'REILLY MEDIA, 2009
•M. FISHER, J. ELLIS, J. BRUCE, “JDBC™ API TUTORIAL AND REFERENCE”, 3A EDITION, ADDISON WESLEY, 2003

OTHER:
SLIDE AND EXERCISES PROVIDED BY THE INSTRUCTOR.
More Information
- COURSE LANGUAGE: ITALIAN

CONTACTS
PROF.SSA GENOVEFFA TORTORA
TORTORA@UNISA.IT
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2023-01-23]