Maurizio TUCCI | DATA BASE

cod. 0512700015

DATA BASE

	0512700015
	DEPARTMENT OF CHEMISTRY AND BIOLOGY "ADOLFO ZAMBELLI"
	EQF6
	ENVIRONMENTAL SCIENCES
	2018/2019

PERCORSO COMUNE

	OBBLIGATORIO
	YEAR OF COURSE 2
	YEAR OF DIDACTIC SYSTEM 2016
	SECONDO SEMESTRE

TEACHING UNITS

SSD	CFU	HOURS	ACTIVITY	TYPE OF ACTIVITY
INF/01	5	40	LESSONS	SUPPLEMENTARY COMPULSORY SUBJECTS
INF/01	1	12	EXERCISES	SUPPLEMENTARY COMPULSORY SUBJECTS

PROFESSORS

	MONICA MARIA LUCIA SEBILLO T Curriculum
	MAURIZIO TUCCI Curriculum

	Objectives
	OBJECTIVE OF COURSE IS TO INTRODUCE STUDENTS TO THE DESIGN AND USE OF DATA BASES. THE COURSE AIMS TO PROVIDE THE ELEMENTS TO - KNOW THE STRUCTURE AND FUNCTIONS OF AN INFORMATION SYSTEMS; KNOW THE TECHNOLOGY, THE MODELS AND LANGUAGES FOR THE DESIGN, IMPLEMENTATION AND MANAGEMENT OF DATA BASES; - KNOW HOW TO DESIGN AND PRODUCE DATA BASES STARTING FROM THE USER'S REQUIREMENTS; KNOWING HOW TO REMOVE A DATABASE; - KNOW HOW TO MAKE AN APPROPRIATE DOCUMENTATION.

OBJECTIVE OF COURSE IS TO INTRODUCE STUDENTS TO THE DESIGN AND USE OF DATA BASES. THE COURSE AIMS TO PROVIDE THE ELEMENTS TO - KNOW THE STRUCTURE AND FUNCTIONS OF AN INFORMATION SYSTEMS; KNOW THE TECHNOLOGY, THE MODELS AND LANGUAGES FOR THE DESIGN, IMPLEMENTATION AND MANAGEMENT OF DATA BASES; - KNOW HOW TO DESIGN AND PRODUCE DATA BASES STARTING FROM THE USER'S REQUIREMENTS; KNOWING HOW TO REMOVE A DATABASE; - KNOW HOW TO MAKE AN APPROPRIATE DOCUMENTATION.

	Prerequisites
	THE COURSE ASSUMES KNOWLEDGE OF: •FUNDAMENTALS OF COMPUTER SCIENCE •ABSTRACTION CONCEPTS AND ABSTRACT DATA TYPES

	Contents
	CONCEPTUAL AND LOGICAL MODELLING OF DATABASES •THE ENTITY/RELATIONSHIP MODEL •THE RELATIONAL DATA MODEL •TECHNIQUES FOR RESTRUCTURING CONCEPTUAL DATA SCHEMAS •RULES FOR MAPPING ER TO RELATIONAL MODEL •AUTOMATED TOOLS SUPPORTING DATABASE DESIGN ACTIVITIES QUERY LANGUAGES AND DESIGN METHODOLOGIES •RELATIONAL ALGEBRA •THE SQL LANGUAGE •NORMALIZATION RULES FOR RELATIONAL DATABASES LABORATORY CASE TOOLS SUPPORTING DATABASE DESIGN THE RELATIONAL DBMS MYSQL

Contents

CONCEPTUAL AND LOGICAL MODELLING OF DATABASES
•THE ENTITY/RELATIONSHIP MODEL
•THE RELATIONAL DATA MODEL
•TECHNIQUES FOR RESTRUCTURING CONCEPTUAL DATA SCHEMAS
•RULES FOR MAPPING ER TO RELATIONAL MODEL
•AUTOMATED TOOLS SUPPORTING DATABASE DESIGN ACTIVITIES
QUERY LANGUAGES AND DESIGN METHODOLOGIES
•RELATIONAL ALGEBRA
•THE SQL LANGUAGE
•NORMALIZATION RULES FOR RELATIONAL DATABASES
LABORATORY
CASE TOOLS SUPPORTING DATABASE DESIGN
THE RELATIONAL DBMS MYSQL

	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/12 HOURS) FOCUSSING ON PRACTICAL ACTIVITIES, WHERE STUDENTS COOPERATE TO SOLVE EXERCISES, UNDER THE SUPERVISION OF THE INSTRUCTOR. STUDENTS WILL EXPLOIT MYSQL FUNCTIONS TO CREATE SOFTWARE APPLICATIONS FOR CONVENTIONAL DATABASES, IN SEVERAL DOMAINS OF INTEREST STUDENTS WILL BE ASSIGNED A PROJECT THAT THEY WILL CARRY OUT IN GROUPS OF 2-4 PEOPLE, IN ORDER TO TRAIN ON PRACTICAL ASPECTS OF THE LABORATORY LESSONS, AND TO SIMULATE GROUP DYNAMICS OF TYPICAL WORKING ENVIRONMENTS.

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/12 HOURS) FOCUSSING ON PRACTICAL ACTIVITIES, WHERE STUDENTS COOPERATE TO SOLVE EXERCISES, UNDER THE SUPERVISION OF THE INSTRUCTOR. STUDENTS WILL EXPLOIT MYSQL FUNCTIONS TO CREATE SOFTWARE APPLICATIONS FOR CONVENTIONAL DATABASES, IN SEVERAL DOMAINS OF INTEREST
STUDENTS WILL BE ASSIGNED A PROJECT THAT THEY WILL CARRY OUT IN GROUPS OF 2-4 PEOPLE, IN ORDER TO TRAIN ON PRACTICAL ASPECTS OF THE LABORATORY LESSONS, AND TO SIMULATE GROUP DYNAMICS OF TYPICAL WORKING ENVIRONMENTS.

	Verification of learning
	THE EXAM IS ADDRESSED TO EVALUATE THE INDIVIDUAL LEARNING ABOUT DATABASE FUNDAMENTALS AND APPLICATIONS. THE ASSESSMENT WILL BE BASED ON: •WRITTEN EXAMINATION TO EVALUATE THE GAINED THEORETICAL KNOWLEDGE ACQUIRED ON DATABASE DESIGN AND IMPLEMENTATION ASPECTS. THE EVALUATION CRITERIA INCLUDE THE CORRECTNESS, THE COMPLETENESS, AND THE CLARITY OF THE PRESENTATION (3 HOURS) •ORAL EXAMINATION TO EVALUATE THE PROJECT AND TO ASSESS THE GAINED KNOWLEDGE. THE EVALUATION CRITERIA INCLUDE THE COMPLETENESS AND THE CORRECTNESS OF THE PROJECT DOCUMENTATION, OF THE REALIZED ARTIFACTS, TOGETHER WITH THE FLUENCY AND THE CLARITY OF PRESENTATION OF THE COURSE CONTENTS DURING THE COURSE, STUDENTS CAN TAKE TWO/THREE PARTIAL EXAMS AT THE END OF LECTURES CONCERNING CONCEPTUAL / LOGICAL MODELLING AND IMPLEMENTATION. PASSING THE TRIALS ENTITLES STUDENTS TO BE EXONERATED BY THE WRITTEN EXAM. THE WRITTEN EXAM AFFECTS ONE-THIRD OF THE FINAL VOTE WHILE THE ORAL EXAM (INCLUDING THE PROJECT PRESENTATION) AFFECTS THE REMAINING TWO-THIRD.

Verification of learning

THE EXAM IS ADDRESSED TO EVALUATE THE INDIVIDUAL LEARNING ABOUT DATABASE FUNDAMENTALS AND APPLICATIONS. THE ASSESSMENT WILL BE BASED ON:
•WRITTEN EXAMINATION TO EVALUATE THE GAINED THEORETICAL KNOWLEDGE ACQUIRED ON DATABASE DESIGN AND IMPLEMENTATION ASPECTS. THE EVALUATION CRITERIA INCLUDE THE CORRECTNESS, THE COMPLETENESS, AND THE CLARITY OF THE PRESENTATION (3 HOURS)
•ORAL EXAMINATION TO EVALUATE THE PROJECT AND TO ASSESS THE GAINED KNOWLEDGE. THE EVALUATION CRITERIA INCLUDE THE COMPLETENESS AND THE CORRECTNESS OF THE PROJECT DOCUMENTATION, OF THE REALIZED ARTIFACTS, TOGETHER WITH THE FLUENCY AND THE CLARITY OF PRESENTATION OF THE COURSE CONTENTS
DURING THE COURSE, STUDENTS CAN TAKE TWO/THREE PARTIAL EXAMS AT THE END OF LECTURES CONCERNING CONCEPTUAL / LOGICAL MODELLING AND IMPLEMENTATION. PASSING THE TRIALS ENTITLES STUDENTS TO BE EXONERATED BY THE WRITTEN EXAM.
THE WRITTEN EXAM AFFECTS ONE-THIRD OF THE FINAL VOTE WHILE THE ORAL EXAM (INCLUDING THE PROJECT PRESENTATION) AFFECTS THE REMAINING TWO-THIRD.

	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 SOFTWARE / HARDWARE • MYSQL • PERSONAL COMPUTER OTHER SLIDE AND EXERCISES PROVIDED BY THE INSTRUCTOR.

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

SOFTWARE / HARDWARE
• MYSQL
• PERSONAL COMPUTER

OTHER
SLIDE AND EXERCISES PROVIDED BY THE INSTRUCTOR.

	More Information
	PRACTICE EXERCISES AND COURSE ATTENDANCE ARE HIGHLY RECOMMENDED. A SIGNIFICANT AMOUNT OF TIME SHOULD BE DEVOTED TO THE HOME WORKING. A SUITABLE TRAINING REQUIRES ON AVERAGE 2 HOURS OF HOME WORKING FOR EACH HOUR OF LECTURING. INFORMATION ABOUT THE COURSE ARE AVAILABLE ON THE E-LEARNING PLATFORM OF THE DIPARTIMENTO DI INFORMATICA AT HTTP://ELEARNING.INFORMATICA.UNISA.IT/EL-PLATFORM/

BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2019-10-21]

Maurizio TUCCI | DATA BASE