Economia e Management | DATABASES

cod. 0212700129

DATABASES

	0212700129
	DEPARTMENT OF MANAGEMENT & INNOVATION SYSTEMS
	EQF6
	BUSINESS MANAGEMENT
	2021/2022

CURRICULUM MANAGEMENT AND COMPUTER SCIENCE

	OBBLIGATORIO
	YEAR OF COURSE 3
	YEAR OF DIDACTIC SYSTEM 2014
	SPRING SEMESTER

TEACHING UNITS

	SSD	CFU	HOURS	ACTIVITY	TYPE OF ACTIVITY
	INF/01	9	54	LESSONS	SUPPLEMENTARY COMPULSORY SUBJECTS

	Objectives
	TRAINING OBJECTIVES AIM OF THE COURSE IS TO OFFER TO THE STUDENT AN INTRODUCTION TO CONCEPTS ("KNOWING") AND FUNDAMENTAL TECHNIQUES ("KNOW HOW TO DO") ON THE DESIGN AND IMPLEMENTATION OF DATA BASE MANAGEMENT SYSTEMS, WHICH MAY BE USEFUL BOTH FOR ITS FUTURE STUDIES AND FOR ITS FUTURE WORK. KNOWLEDGE AND UNDERSTANDING SKILLS AT THE END OF THE TEACHING THE STUDENT WILL BE ABLE TO UNDERSTAND AND USE THE TERMINOLOGICAL VOCABULARY OF THE DATABASE MANAGEMENT SYSTEMS. THE STUDENT WILL LEARN THE BASIC CONCEPTS ON THE CONCEPTUAL AND LOGIC DESIGN OF RELATIONAL DATABASES AND THE RELATIVE INTERACTION LANGUAGES (IN PARTICULAR THE SQL LANGUAGE). HE WILL LEARN THE STRUCTURAL PROPERTIES OF THE RELATIONAL MODEL AND THE MAIN TECHNIQUES OF RESTRUCTURING, VERIFYING AND OPTIMIZING A DATA-BASED INFORMATION SYSTEM. THIS WILL ALLOW IT, STARTING FROM THE USER REQUIREMENTS, TO ARRIVE TO PRODUCE QUALITY DATABASE SYSTEMS AND FULLY MEETING THE CLIENT'S NEEDS. ABILITY TO APPLY KNOWLEDGE AND UNDERSTANDING. THE COURSE PUTS SPECIAL EMPHASIS ON THE APPLICATION ASPECT. THE STUDENT WILL BE ABLE TO: ANALYZE THE REQUIREMENTS OF THE SYSTEM TO BE DEVELOPED, CONCEPTUALLY AND LOGICALLY DESIGN A RELATIONAL DB AND IMPLEMENT IT BY CREATING THE OBJECTS THAT WILL CONTAIN THE DATA (TABLES), OPPORTUNELY CHOOSING THE MOST SUITABLE TYPES OF DATA, INSERTING APPROPRIATE INTEGRITY BINDINGS, CREATING QUESTIONS AND VISUALIZATION TOOLS AND DATA ANALYSIS. IN ADDITION, HE WILL BE ABLE TO OPERATE IMPORT / EXPORT OF DATA BETWEEN A DBMS AND OTHER FORMATS (ELECTRONIC SHEETS, WORD PROCESSOR, PDF, HTML, ...); THE STUDENT WILL ALSO LEARN TO MANAGE MULTIMEDIA DATA WITHIN A "MIXED" DB. DURING THE ENTIRE DESIGN PROCESS, HE WILL BE ABLE TO VERIFY THE DRAWING THROUGH THE MAIN TECHNIQUES OF RESTRUCTURING AND DESIGN OPTIMIZATION, AND THEN VERIFY THE QUALITY OF THE FINAL LOGICAL SCHEME THROUGH THE NORMALIZATION TECHNIQUES. AT THE END OF THE COURSE THE STUDENT WILL BE ABLE TO ANALYZE, DESIGN AND DEVELOP SMALL WORKING DB-BASED MULTIMEDIA APPLICATIONS, STARTING FROM REAL COMPANY SITUATIONS.

TRAINING OBJECTIVES
AIM OF THE COURSE IS TO OFFER TO THE STUDENT AN INTRODUCTION TO CONCEPTS ("KNOWING") AND FUNDAMENTAL TECHNIQUES ("KNOW HOW TO DO") ON THE DESIGN AND IMPLEMENTATION OF DATA BASE MANAGEMENT SYSTEMS, WHICH MAY BE USEFUL BOTH FOR ITS FUTURE STUDIES AND FOR ITS FUTURE WORK.

KNOWLEDGE AND UNDERSTANDING SKILLS
AT THE END OF THE TEACHING THE STUDENT WILL BE ABLE TO UNDERSTAND AND USE THE TERMINOLOGICAL VOCABULARY OF THE DATABASE MANAGEMENT SYSTEMS.
THE STUDENT WILL LEARN THE BASIC CONCEPTS ON THE CONCEPTUAL AND LOGIC DESIGN OF RELATIONAL DATABASES AND THE RELATIVE INTERACTION LANGUAGES (IN PARTICULAR THE SQL LANGUAGE). HE WILL LEARN THE STRUCTURAL PROPERTIES OF THE RELATIONAL MODEL AND THE MAIN TECHNIQUES OF RESTRUCTURING, VERIFYING AND OPTIMIZING A DATA-BASED INFORMATION SYSTEM. THIS WILL ALLOW IT, STARTING FROM THE USER REQUIREMENTS, TO ARRIVE TO PRODUCE QUALITY DATABASE SYSTEMS AND FULLY MEETING THE CLIENT'S NEEDS.

ABILITY TO APPLY KNOWLEDGE AND UNDERSTANDING.
THE COURSE PUTS SPECIAL EMPHASIS ON THE APPLICATION ASPECT.
THE STUDENT WILL BE ABLE TO:
ANALYZE THE REQUIREMENTS OF THE SYSTEM TO BE DEVELOPED,
CONCEPTUALLY AND LOGICALLY DESIGN A RELATIONAL DB
AND IMPLEMENT IT BY CREATING THE OBJECTS THAT WILL CONTAIN THE DATA (TABLES), OPPORTUNELY CHOOSING THE MOST SUITABLE TYPES OF DATA, INSERTING APPROPRIATE INTEGRITY BINDINGS, CREATING QUESTIONS AND VISUALIZATION TOOLS AND DATA ANALYSIS.
IN ADDITION, HE WILL BE ABLE TO OPERATE IMPORT / EXPORT OF DATA BETWEEN A DBMS AND OTHER FORMATS (ELECTRONIC SHEETS, WORD PROCESSOR, PDF, HTML, ...); THE STUDENT WILL ALSO LEARN TO MANAGE MULTIMEDIA DATA WITHIN A "MIXED" DB.
DURING THE ENTIRE DESIGN PROCESS, HE WILL BE ABLE TO VERIFY THE DRAWING THROUGH THE MAIN TECHNIQUES OF RESTRUCTURING AND DESIGN OPTIMIZATION, AND THEN VERIFY THE QUALITY OF THE FINAL LOGICAL SCHEME THROUGH THE NORMALIZATION TECHNIQUES.
AT THE END OF THE COURSE THE STUDENT WILL BE ABLE TO ANALYZE, DESIGN AND DEVELOP SMALL WORKING DB-BASED MULTIMEDIA APPLICATIONS, STARTING FROM REAL COMPANY SITUATIONS.

	Prerequisites
	BASIC CONCEPTS OF COMPUTER SCIENCE, AS FROM THE COURSE "FONDAMENTI DI INFORMATICA" OF THIS DEGREE COURSE.

	Contents
	THE TEACHING CONSISTS OF 60 HOURS OF DIDACTICS (9 CFU). IN PARTICULAR 6 CREDITS (36 HOURS) WILL BE DEDICATED TO FACE-TO-FACE LESSONS AND 3 CREDITS (18 HOURS) TO CLASSROOM EXERCISES AND TO THE ANALYSIS, DEVELOPMENT AND DISCUSSION OF CLASSROOM PROJECTS. IN PARTICULAR, IT IS SO STRUCTURED: MODULE 1: INFORMATION SYSTEMS AND DBMS (30 HOURS IN TOTAL, OF WHICH 18 HOURS OF LECTURES AND 12 HOURS OF CLASSROOM EXERCISES), DIVIDED AS FOLLOWS: BASIC CONCEPTS (6 HOURS OF LECTURES): INFORMATION SYSTEMS, DB AND DBMS - DATA MODELS - LANGUAGES, USERS, ADVANTAGES AND DISADVANTAGES - MAIN PARTS OF A DBMS THE RELATIONAL MODEL (6 HOURS OF LECTURES): RELATIONAL MODEL, STRUCTURES - INTEGRITY CONSTRAINTS THE SQL LANGUAGE (6 HOURS OF LECTURES + 12 HOURS OF CLASSROOM EXERCISES): SIMPLE QUERIES - AGGREGATION QUERIES - QUERIES ON GROUPED DATA - QUERIES ON MULTIPLE TABLES - NESTED QUERIES - SET TYPE QUERIES - DATA HANDLING QUERIES MODULE 2: THE DESIGN OF A DATABASE (24 TOTAL HOURS, OF WHICH 18 HOURS OF LECTURES AND 6 HOURS OF EXERCISES, CLASSROOM PROJECTS AND ASSISTANCE FOR THE DEVELOPMENT OF STUDENTS' PROJECTS), DIVIDED AS FOLLOWS: INTRODUCTION TO DATABASE DESIGN (2 HOUR OF FRONTAL LESSONS) CONCEPTUAL DESIGN, THE ENTITY-RELATIONSHIP MODEL (4 HOURS OF LECTURES + 2 HOURS OF EXERCISES AND PROJECTS): THE MAIN CONSTRUCTS OF THE MODEL: ENTITIES, RELATIONSHIPS - OTHER MODEL CONSTRUCTS: CARDINALITY, IDENTIFIERS, GENERALIZATIONS - SUPPORTING DOCUMENTATION OF THE ER SCHEMES: COMPANY RULES, DATA DICTIONARY, CONSTRAINT RULES, DERIVATION RULES FROM THE CONCEPTUAL MODEL TO THE LOGICAL MODEL (4 HOURS OF LECTURES + 2 HOURS OF EXERCISES AND PROJECTS): ESTIMATION OF THE APPLICATION LOAD OF AN ER DIAGRAM: VOLUMES TABLE, OPERATIONS TABLE, ACCESS TABLE - RESTRUCTURING OF ER SCHEMES: ANALYSIS OF REDUNDANCIES, ELIMINATION OF GENERALIZATIONS - PARTITIONING / COMBINATION OF CONCEPTS AND CHOICE OF MAIN IDENTIFIERS: LOGICAL DESIGN: TRANSLATION IN THE RELATIONAL MODEL AND NORMALIZATION (4 HOURS OF LECTURES + 2 HOURS OF EXERCISES AND PROJECTS): TRANSFORMATION OF AN ER DIAGRAM INTO A RELATIONAL SCHEME: TRANSFORMATION OF ENTITIES, TRANSFORMATION OF RELATIONSHIPS - NORMALIZATION: REDUNDANCIES, ANOMALIES, FUNCTIONAL DEPENDENCIES, NORMAL FORMS, NORMAL FORM OF BOYCE AND CODD, BCNF NORMALIZATION, PROPERTIES OF DECOMPOSITIONS (DECOMPOSITION WITHOUT LOSSES, MAINTENANCE OF FUNCTIONAL DEPENDENCIES), THIRD NORMAL FORM, OTHER NORMAL FORMS DESIGN (4 HOURS OF LECTURES): DESCRIPTION OF COMPLETE PROJECTS (SCIENTIFIC REVIEW, TRAINING COMPANY). ASSISTANCE IN THE DEVELOPMENT OF STUDENT PROJECTS WITH VERIFICATION OF THE PROGRESS OF THE PROJECTS.

Contents

THE TEACHING CONSISTS OF 60 HOURS OF DIDACTICS (9 CFU). IN PARTICULAR 6 CREDITS (36 HOURS) WILL BE DEDICATED TO FACE-TO-FACE LESSONS AND 3 CREDITS (18 HOURS) TO CLASSROOM EXERCISES AND TO THE ANALYSIS, DEVELOPMENT AND DISCUSSION OF CLASSROOM PROJECTS.

IN PARTICULAR, IT IS SO STRUCTURED:
MODULE 1: INFORMATION SYSTEMS AND DBMS (30 HOURS IN TOTAL, OF WHICH 18 HOURS OF LECTURES AND 12 HOURS OF CLASSROOM EXERCISES), DIVIDED AS FOLLOWS:
BASIC CONCEPTS (6 HOURS OF LECTURES): INFORMATION SYSTEMS, DB AND DBMS - DATA MODELS - LANGUAGES, USERS, ADVANTAGES AND DISADVANTAGES - MAIN PARTS OF A DBMS
THE RELATIONAL MODEL (6 HOURS OF LECTURES): RELATIONAL MODEL, STRUCTURES - INTEGRITY CONSTRAINTS
THE SQL LANGUAGE (6 HOURS OF LECTURES + 12 HOURS OF CLASSROOM EXERCISES): SIMPLE QUERIES - AGGREGATION QUERIES - QUERIES ON GROUPED DATA - QUERIES ON MULTIPLE TABLES - NESTED QUERIES - SET TYPE QUERIES - DATA HANDLING QUERIES

MODULE 2: THE DESIGN OF A DATABASE (24 TOTAL HOURS, OF WHICH 18 HOURS OF LECTURES AND 6 HOURS OF EXERCISES, CLASSROOM PROJECTS AND ASSISTANCE FOR THE DEVELOPMENT OF STUDENTS' PROJECTS), DIVIDED AS FOLLOWS:
INTRODUCTION TO DATABASE DESIGN (2 HOUR OF FRONTAL LESSONS)
CONCEPTUAL DESIGN, THE ENTITY-RELATIONSHIP MODEL (4 HOURS OF LECTURES + 2 HOURS OF EXERCISES AND PROJECTS): THE MAIN CONSTRUCTS OF THE MODEL: ENTITIES, RELATIONSHIPS - OTHER MODEL CONSTRUCTS: CARDINALITY, IDENTIFIERS, GENERALIZATIONS - SUPPORTING DOCUMENTATION OF THE ER SCHEMES: COMPANY RULES, DATA DICTIONARY, CONSTRAINT RULES, DERIVATION RULES
FROM THE CONCEPTUAL MODEL TO THE LOGICAL MODEL (4 HOURS OF LECTURES + 2 HOURS OF EXERCISES AND PROJECTS): ESTIMATION OF THE APPLICATION LOAD OF AN ER DIAGRAM: VOLUMES TABLE, OPERATIONS TABLE, ACCESS TABLE - RESTRUCTURING OF ER SCHEMES: ANALYSIS OF REDUNDANCIES, ELIMINATION OF GENERALIZATIONS - PARTITIONING / COMBINATION OF CONCEPTS AND CHOICE OF MAIN IDENTIFIERS:
LOGICAL DESIGN: TRANSLATION IN THE RELATIONAL MODEL AND NORMALIZATION (4 HOURS OF LECTURES + 2 HOURS OF EXERCISES AND PROJECTS): TRANSFORMATION OF AN ER DIAGRAM INTO A RELATIONAL SCHEME: TRANSFORMATION OF ENTITIES, TRANSFORMATION OF RELATIONSHIPS - NORMALIZATION: REDUNDANCIES, ANOMALIES, FUNCTIONAL DEPENDENCIES, NORMAL FORMS, NORMAL FORM OF BOYCE AND CODD, BCNF NORMALIZATION, PROPERTIES OF DECOMPOSITIONS (DECOMPOSITION WITHOUT LOSSES, MAINTENANCE OF FUNCTIONAL DEPENDENCIES), THIRD NORMAL FORM, OTHER NORMAL FORMS
DESIGN (4 HOURS OF LECTURES): DESCRIPTION OF COMPLETE PROJECTS (SCIENTIFIC REVIEW, TRAINING COMPANY). ASSISTANCE IN THE DEVELOPMENT OF STUDENT PROJECTS WITH VERIFICATION OF THE PROGRESS OF THE PROJECTS.

	Teaching Methods
	THE COURSE AIMS TO ACCOMPANY STUDENTS IN THE PERMANENT TRAINING PROCESS (LIFELONG LEARNING), WHICH INVOLVES THE CONTINUOUS UPDATE (FOR THE WHOLE LIFE) OF KNOWLEDGE AND SKILLS, TRYING TO STIMULATE CURIOSITY AND INTEREST TOWARDS NEW TECHNOLOGY AND TECHNOLOGY. TO INCREASE ATTENTION AND LEARNING SKILLS, THE TEACHER WILL SHOW THE "PRACTICAL" RESULTS OF WHAT IS PRESENTED AT LESSON AND WILL ENCOURAGE STUDENTS TO CONTINUE INTERACTION WITH HIM AND WITH THE OTHER STUDENTS. IN THE CLASSROOM, TO MAINTAIN THE CUTE ATTENTION, SLIDES WILL BE USED, ACCOMPANIED BY MULTIMEDIA ELEMENTS. FOR THE PURPOSE OF HABITING THEM TO SELF-LEARNING, STUDENTS WILL BE INVITED TO DEEPEN THE COURSE TOPICS, BY PRESENTING THEM ONLINE RESOURCES OF PARTICULAR INTEREST. DURING THE COURSE THE TEACHER WILL MAKE A WIDE USE OF EXAMPLES, GUIDED EXERCISES AND EXERCISES TO BE CARRIED OUT AT HOME BY STUDENTS, WITH THE CORRECTION TO THE NEXT LESSON. FROM THE STRUCTURAL POINT OF VIEW, THE LESSONS MAY BE: • FRONTAL LESSONS WITH EXAMPLES AND GUIDED EXERCISES. • EXERCISES AT HOME. • END-OF-TOPIC GUIDED PROJECTS. IN THE FRONTAL LESSONS, THE TEACHER WILL PRESENT SOME EXAMPLES, ABLE TO GIVE CONCRETENESS TO WHAT THEORETICALLY EXPLAINED, AND THEN HE WILL INVITE THE STUDENTS TO PERFORM THE EXERCISES IN THE CLASSROOM, WHOSE SOLUTIONS WILL BE IMMEDIATELY DESCRIBED AND COMMENTED BY THE TEACHER. IN THE GUIDED PROJECTS, WHICH TAKE PLACE AT THE END OF EVERY TOPIC, A COMPLETE EXAMPLE WILL BE PRESENTED WHICH WILL INCREASELY SHOW, IN INCREMENTAL WAY WITH RESPECT TO THE PREVIOUS TOPICS, THE PRACTICE OF THE ENTIRE TOPIC. THESE PROJECTS WILL COVER ALL THE PHASES, FROM THE ANALYSIS OF THE REQUIREMENTS UP TO THE NORMALIZATION OF THE LOGICAL SCHEME. EVERY PROJECT WILL BE INTRODUCED, ILLUSTRATED, STARTED AND THEN LEFT TO THE STUDENTS. AT THE END OF EACH GUIDED PROJECT THE COMPLETE SOLUTION OF THE PROJECT WILL BE PRESENTED. THE CLASSROOM AND HOME EXERCISES PRESENT A GROWING AND INCREMENTAL LEVEL OF DIFFICULTIES; THEY WILL BE PRESENTED BY THE TEACHER AND THEN LEFT TO THE STUDENTS. AT THE END OF THE STUDENTS 'WORK, THE TEACHER WILL SHOW AND COMMENT THE SOLUTION OF THE EXERCISE. IN THE LAST PART OF THE COURSE, THE STUDENTS, WITH THE SUPERVISION OF THE TEACHER, WILL BE ORGANIZED IN SOME WORKING TEAM AND WILL BE ASSIGNED TO EACH GROUP A PROJECT TO BE DEVELOPED FROM ZERO AND TO BE DELIVERED BY THE END OF THE COURSE.

Teaching Methods

THE COURSE AIMS TO ACCOMPANY STUDENTS IN THE PERMANENT TRAINING PROCESS (LIFELONG LEARNING), WHICH INVOLVES THE CONTINUOUS UPDATE (FOR THE WHOLE LIFE) OF KNOWLEDGE AND SKILLS, TRYING TO STIMULATE CURIOSITY AND INTEREST TOWARDS NEW TECHNOLOGY AND TECHNOLOGY.
TO INCREASE ATTENTION AND LEARNING SKILLS, THE TEACHER WILL SHOW THE "PRACTICAL" RESULTS OF WHAT IS PRESENTED AT LESSON AND WILL ENCOURAGE STUDENTS TO CONTINUE INTERACTION WITH HIM AND WITH THE OTHER STUDENTS. IN THE CLASSROOM, TO MAINTAIN THE CUTE ATTENTION, SLIDES WILL BE USED, ACCOMPANIED BY MULTIMEDIA ELEMENTS.

FOR THE PURPOSE OF HABITING THEM TO SELF-LEARNING, STUDENTS WILL BE INVITED TO DEEPEN THE COURSE TOPICS, BY PRESENTING THEM ONLINE RESOURCES OF PARTICULAR INTEREST.
DURING THE COURSE THE TEACHER WILL MAKE A WIDE USE OF EXAMPLES, GUIDED EXERCISES AND EXERCISES TO BE CARRIED OUT AT HOME BY STUDENTS, WITH THE CORRECTION TO THE NEXT LESSON.

FROM THE STRUCTURAL POINT OF VIEW, THE LESSONS MAY BE:
• FRONTAL LESSONS WITH EXAMPLES AND GUIDED EXERCISES.
• EXERCISES AT HOME.
• END-OF-TOPIC GUIDED PROJECTS.

IN THE FRONTAL LESSONS, THE TEACHER WILL PRESENT SOME EXAMPLES, ABLE TO GIVE CONCRETENESS TO WHAT THEORETICALLY EXPLAINED, AND THEN HE WILL INVITE THE STUDENTS TO PERFORM THE EXERCISES IN THE CLASSROOM, WHOSE SOLUTIONS WILL BE IMMEDIATELY DESCRIBED AND COMMENTED BY THE TEACHER.

IN THE GUIDED PROJECTS, WHICH TAKE PLACE AT THE END OF EVERY TOPIC, A COMPLETE EXAMPLE WILL BE PRESENTED WHICH WILL INCREASELY SHOW, IN INCREMENTAL WAY WITH RESPECT TO THE PREVIOUS TOPICS, THE PRACTICE OF THE ENTIRE TOPIC.
THESE PROJECTS WILL COVER ALL THE PHASES, FROM THE ANALYSIS OF THE REQUIREMENTS UP TO THE NORMALIZATION OF THE LOGICAL SCHEME.
EVERY PROJECT WILL BE INTRODUCED, ILLUSTRATED, STARTED AND THEN LEFT TO THE STUDENTS. AT THE END OF EACH GUIDED PROJECT THE COMPLETE SOLUTION OF THE PROJECT WILL BE PRESENTED.

THE CLASSROOM AND HOME EXERCISES PRESENT A GROWING AND INCREMENTAL LEVEL OF DIFFICULTIES; THEY WILL BE PRESENTED BY THE TEACHER AND THEN LEFT TO THE STUDENTS. AT THE END OF THE STUDENTS 'WORK, THE TEACHER WILL SHOW AND COMMENT THE SOLUTION OF THE EXERCISE.

IN THE LAST PART OF THE COURSE, THE STUDENTS, WITH THE SUPERVISION OF THE TEACHER, WILL BE ORGANIZED IN SOME WORKING TEAM AND WILL BE ASSIGNED TO EACH GROUP A PROJECT TO BE DEVELOPED FROM ZERO AND TO BE DELIVERED BY THE END OF THE COURSE.

	Verification of learning
	REACHING OF THE TEACHING OBJECTIVES IS CERTIFIED BY PASSING AN EXAM WITH ASSESSMENT IN 30/30. IN THE EXAMINATION THE STUDENT WILL HAVE TO SHOW TO KNOW "THEORETICALLY" THE CONCEPTS AND TO KNOW HOW TO "PRACTICALLY" APPLY THE TECHNIQUES LEARNED IN THE COURSE STUDY. THE EXAMINATION WILL TAKE PLACE, IF NOT OTHERWISE COMMUNICATED THROUGH THE OFFICIAL CHANNELS OF THE UNIVERSITY, AT THE DEPARTMENT'S MULTIMEDIA LABORATORY (BUILDING B2, ENTRANCE 14, GROUND FLOOR) THE DAY AND TIME SET FOR THE APPEAL WILL HAVE STARTING NOW . THE EXAMINATION IS DIVIDED INTO THREE PARTS: A "THEORETICAL", A "PRACTICE" (MODULE 1) AND A "DESIGN" PART (MODULE 2); EACH PART PRESENTS A MINIMUM THRESHOLD OF SUFFICIENCY, UNDER WHICH THE ENTIRE EXAM IS NOT PASSED, EVEN IF THE INSUFFICIENCY CONCERNS ONLY ONE OF THE PARTIES. AT THE END OF THE TESTS, THE TEACHER WILL SHOW THE SOLUTIONS (SO AS TO ALLOW A FIRST SELF-CORRECTION BY THE STUDENTS) AND WILL COMMUNICATE THE DAY AND TIME WHEN THE FINAL EXAMINATION OPERATIONS WILL TAKE PLACE. NORMALLY EVERYTHING ENDS IN THE SAME DAY WHEN THE APPEAL STARTS. THE EXAMINATION WILL CONCLUDE WITH THE VISION AND DISCUSSION OF THE ELABORATES AND WITH A FINAL INTERVIEW. THE EXAM MUST BE COMPLETED IN A SINGLE APPEAL, FOR WHICH THE PARTIES MUST BE PASSED ALL IN THE SAME APPEAL. THIS MEANS THAT THEY ARE NOT CONSERVATIVE: TESTS PASSED IN OTHER APPEALS CANNOT BE RELIED ON AN APPEAL. IN DETAIL: PART 1: "THEORETICAL" TOPICS OF THE ENTIRE COURSE: • SCORE OF THE TEST: UP TO 8 POINTS, WITH A MINIMUM SCORE OF 5. X PART 2A: DEVELOPMENT OF A DBMS APPLICATION (MODULE 1) • DEVELOPMENT OF A SMALL DBMS APPLICATION BY CREATING THE REQUIRED STRUCTURES (TABLES, MASKS, REPORTS, ETC.) BY ASSIGNING THEIR CORRECT PROPERTIES, AND THEN POPULATING THE DATABASE AND, FINALLY, CREATING THE REQUESTED QUESTIONS. • SCORE OF THE TEST: UP TO 12 POINTS, WITH SUFFICIENCY AT 6.5 (OF WHICH AT LEAST 4 ON THE QUERY IN SQL) PART 2B: DESIGN OF A DATABASE (MODULE 2) • THE TEST CONSISTS IN THE DESIGN OF A SMALL DATABASE, STARTING FROM A SET OF REQUIREMENTS GIVEN BY THE TEACHER. THE STUDENT MUST DEVELOP THE APPLICATION BY PASSING THROUGH ALL PHASES (FROM THE CREATION OF THE ER DIAGRAM TO THE NORMALIZATION OF THE RELATIONAL SCHEMA). • SCORE OF THE TEST: UP TO 12 POINTS, WITH A SUFFICIENCY OF 6.5 (OF WHICH AT LEAST 3.5 ON THE CONCEPTUAL DESIGN AND 3 ON THE LOGIC DESIGN). MAXIMUM TIME AVAILABLE TO COMPLETE THE VARIOUS PARTS: 120 MINUTES

Verification of learning

REACHING OF THE TEACHING OBJECTIVES IS CERTIFIED BY PASSING AN EXAM WITH ASSESSMENT IN 30/30.
IN THE EXAMINATION THE STUDENT WILL HAVE TO SHOW TO KNOW "THEORETICALLY" THE CONCEPTS AND TO KNOW HOW TO "PRACTICALLY" APPLY THE TECHNIQUES LEARNED IN THE COURSE STUDY.

THE EXAMINATION WILL TAKE PLACE, IF NOT OTHERWISE COMMUNICATED THROUGH THE OFFICIAL CHANNELS OF THE UNIVERSITY, AT THE DEPARTMENT'S MULTIMEDIA LABORATORY (BUILDING B2, ENTRANCE 14, GROUND FLOOR) THE DAY AND TIME SET FOR THE APPEAL WILL HAVE STARTING NOW .

THE EXAMINATION IS DIVIDED INTO THREE PARTS: A "THEORETICAL", A "PRACTICE" (MODULE 1) AND A "DESIGN" PART (MODULE 2); EACH PART PRESENTS A MINIMUM THRESHOLD OF SUFFICIENCY, UNDER WHICH THE ENTIRE EXAM IS NOT PASSED, EVEN IF THE INSUFFICIENCY CONCERNS ONLY ONE OF THE PARTIES.
AT THE END OF THE TESTS, THE TEACHER WILL SHOW THE SOLUTIONS (SO AS TO ALLOW A FIRST SELF-CORRECTION BY THE STUDENTS) AND WILL COMMUNICATE THE DAY AND TIME WHEN THE FINAL EXAMINATION OPERATIONS WILL TAKE PLACE. NORMALLY EVERYTHING ENDS IN THE SAME DAY WHEN THE APPEAL STARTS.
THE EXAMINATION WILL CONCLUDE WITH THE VISION AND DISCUSSION OF THE ELABORATES AND WITH A FINAL INTERVIEW. THE EXAM MUST BE COMPLETED IN A SINGLE APPEAL, FOR WHICH THE PARTIES MUST BE PASSED ALL IN THE SAME APPEAL. THIS MEANS THAT THEY ARE NOT CONSERVATIVE: TESTS PASSED IN OTHER APPEALS CANNOT BE RELIED ON AN APPEAL.

IN DETAIL:
PART 1: "THEORETICAL" TOPICS OF THE ENTIRE COURSE:
• SCORE OF THE TEST: UP TO 8 POINTS, WITH A MINIMUM SCORE OF 5.
X
PART 2A: DEVELOPMENT OF A DBMS APPLICATION (MODULE 1)
• DEVELOPMENT OF A SMALL DBMS APPLICATION BY CREATING THE REQUIRED STRUCTURES (TABLES, MASKS, REPORTS, ETC.) BY ASSIGNING THEIR CORRECT PROPERTIES, AND THEN POPULATING THE DATABASE AND, FINALLY, CREATING THE REQUESTED QUESTIONS.
• SCORE OF THE TEST: UP TO 12 POINTS, WITH SUFFICIENCY AT 6.5 (OF WHICH AT LEAST 4 ON THE QUERY IN SQL)
PART 2B: DESIGN OF A DATABASE (MODULE 2)
• THE TEST CONSISTS IN THE DESIGN OF A SMALL DATABASE, STARTING FROM A SET OF REQUIREMENTS GIVEN BY THE TEACHER. THE STUDENT MUST DEVELOP THE APPLICATION BY PASSING THROUGH ALL PHASES (FROM THE CREATION OF THE ER DIAGRAM TO THE NORMALIZATION OF THE RELATIONAL SCHEMA).
• SCORE OF THE TEST: UP TO 12 POINTS, WITH A SUFFICIENCY OF 6.5 (OF WHICH AT LEAST 3.5 ON THE CONCEPTUAL DESIGN AND 3 ON THE LOGIC DESIGN).
MAXIMUM TIME AVAILABLE TO COMPLETE THE VARIOUS PARTS: 120 MINUTES

	Texts
	•P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI – MODELLI E LINGUAGGI DI INTERROGAZIONE 4° EDIZIONE”, MCGRAW-HILL EDUCATION (ITALY) SRL, ISBN 978-8838668005 •(ALTERNATIVELY) P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI - 5° EDIZIONE”, MCGRAW-HILL EDUCATION (ITALY) SRL,, ISBN 978-8838694455 • (FOR CONSULTATION AND / OR STUDY) R. ELMASRI, S. NAVATHE: “SISTEMI DI BASI DI DATI, FONDAMENTI - 6° EDIZIONE”, PEARSON ITALIA, ISBN 978-88-719-2628-5

Texts

•P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI – MODELLI E LINGUAGGI DI INTERROGAZIONE 4° EDIZIONE”, MCGRAW-HILL EDUCATION (ITALY) SRL, ISBN 978-8838668005
•(ALTERNATIVELY) P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI - 5° EDIZIONE”, MCGRAW-HILL EDUCATION (ITALY) SRL,, ISBN 978-8838694455
• (FOR CONSULTATION AND / OR STUDY) R. ELMASRI, S. NAVATHE: “SISTEMI DI BASI DI DATI, FONDAMENTI - 6° EDIZIONE”, PEARSON ITALIA, ISBN 978-88-719-2628-5