Alberto POSTIGLIONE | DATABASES
Alberto POSTIGLIONE DATABASES
cod. 0212700129
DATABASES
| 0212700129 | |
| DEPARTMENT OF MANAGEMENT & INNOVATION SYSTEMS | |
| EQF6 | |
| BUSINESS MANAGEMENT | |
| 2025/2026 |
| OBBLIGATORIO | |
| YEAR OF COURSE 3 | |
| YEAR OF DIDACTIC SYSTEM 2023 | |
| SPRING SEMESTER |
| SSD | CFU | HOURS | ACTIVITY | |
|---|---|---|---|---|
| INF/01 | 10 | 60 | LESSONS |
| Objectives | |
|---|---|
| LEARNING OBJECTIVES THE AIM OF THE COURSE IS TO PROVIDE AN INTRODUCTION TO FUNDAMENTAL CONCEPTS AND TECHNIQUES IN DATABASES, QUERY AND DATA MANAGEMENT LANGUAGES, DESIGN METHODOLOGIES, AND DATA ACCESS THROUGH HIGH-LEVEL QUERY LANGUAGES. THESE FOUNDATIONS WILL BE USEFUL FOR STUDENTS PURSUING GRADUATE STUDIES AS WELL AS FOR THEIR FUTURE PROFESSIONAL CAREERS. KNOWLEDGE AND UNDERSTANDING UPON COMPLETION OF THE COURSE, STUDENTS WILL: •ACQUIRE KNOWLEDGE OF THE RELATIONAL MODEL AND ITS LANGUAGES, WITH A PARTICULAR FOCUS ON EXISTING SYSTEMS (ESPECIALLY SQL), INCLUDING THE CONCEPTUAL AND LOGICAL DESIGN PROCESS OF RELATIONAL DATABASES, VERIFICATION AND OPTIMIZATION TECHNIQUES, AND DATA IMPORT/EXPORT PROCEDURES TO AND FROM OTHER APPLICATIONS; •LEARN THE MAIN TECHNIQUES FOR QUERYING AND MANIPULATING DATABASES; •DEVELOP THE ABILITY TO BUILD SMALL DATA-BASED APPLICATIONS READY FOR IMMEDIATE USE; •BECOME FAMILIAR WITH ADVANCED TOPICS SUCH AS DATA WAREHOUSING AND DATA MINING, BIG DATA CHALLENGES, ONLINE DATABASES, AND MULTIMEDIA DATABASES. APPLYING KNOWLEDGE AND UNDERSTANDING STUDENTS WILL BE ABLE TO START FROM USER REQUIREMENTS AND DESIGN HIGH-QUALITY DATABASE STRUCTURES. COMMUNICATION SKILLS STUDENTS WILL BE ABLE TO: •STRUCTURE AND COMMUNICATE INFORMATION IN VARIOUS CONTEXTS, INCLUDING NON-SPECIALIST ONES, USING APPROPRIATE TERMINOLOGY; •MANAGE IT TOOLS AND DIGITAL RESOURCES; •PRODUCE REPORTS AND PRESENTATIONS, BOTH INDIVIDUALLY AND IN GROUPS. LEARNING SKILLS STUDENTS WILL BE ABLE TO: •RETRIEVE THE NECESSARY INFORMATION TO UPDATE BOTH GENERAL AND SPECIALIZED KNOWLEDGE; •CRITICALLY ANALYZE, PROCESS, AND INTEGRATE DATA, INFORMATION, AND EXPERIENCES, ALSO USING SOFTWARE AND TECHNOLOGICAL TOOLS. |
| Prerequisites | |
|---|---|
| BASIC CONCEPTS OF COMPUTER SCIENCE, AS FROM THE COURSE "FONDAMENTI DI INFORMATICA" OF THIS DEGREE COURSE. |
| Contents | |
|---|---|
| THE COURSE CONSISTS OF 60 TEACHING HOURS (10 CREDITS). IN PARTICULAR, 9 CREDITS (42 HOURS) WILL BE DEDICATED TO LECTURES AND 3 CREDITS (18 HOURS) TO EXERCISES AND ANALYSIS, DEVELOPMENT AND DISCUSSION OF PROJECTS. IN DETAIL, IT IS STRUCTURED AS FOLLOWS: MODULE 1: INFORMATION SYSTEMS AND DBMS (30 HOURS IN TOTAL, OF WHICH 18 HOURS OF LECTURES AND 12 HOURS OF EXERCISES), DIVIDED AS FOLLOWS: •BASIC CONCEPTS: INFORMATION SYSTEMS - DBS AND DBMS - DATA MODELS - LANGUAGES, USERS, ADVANTAGES AND DISADVANTAGES - MAIN PARTS OF A DBMS. •THE RELATIONAL MODEL: RELATIONAL MODEL - STRUCTURES - INTEGRITY CONSTRAINTS. •THE SQL LANGUAGE: SIMPLE QUERIES - AGGREGATION QUERIES - QUERIES ON GROUPED DATA - QUERIES ON MULTIPLE TABLES - NESTED QUERIES - SET QUERIES - DATA MANIPULATION QUERIES. MODULE 2: THE DESIGN OF A DATABASE (30 HOURS IN TOTAL, OF WHICH 24 HOURS OF LECTURES AND 6 HOURS OF EXERCISES AND PROJECTS), DIVIDED AS FOLLOWS: ENTITY-RELATIONSHIP MODEL (CONCEPTUAL DESIGN) •ENTITIES, RELATIONSHIPS, ATTRIBUTES - CARDINALITY - IDENTIFIERS - GENERALIZATIONS - SUPPORTING DOCUMENTATION OF AN ER SCHEMA (BUSINESS RULES, DATA DICTIONARY, CONSTRAINT RULES, DERIVATION RULES) RESTRUCTURING AN ENTITY-RELATIONSHIP DIAGRAM: •APPLICATION LOAD ESTIMATION (TABLE OF VOLUMES, TABLE OF OPERATIONS, TABLE OF ACCESSES) - ANALYSIS OF REDUNDANCIES - ELIMINATION OF GENERALIZATIONS - PARTITIONING / UNION OF CONCEPTS - CHOICE OF MAIN IDENTIFIERS. TRANSFORMATION OF AN ER DIAGRAM INTO A LOGIC SCHEME (LOGICAL DESIGN): •TRANSFORMATION OF ENTITIES - TRANSFORMATION OF BINARY RELATIONSHIPS 1-1, 1-N, N:M TRANSFORMATION OF K-RELATIONSHIPS. •NORMALIZATION: REDUNDANCIES, ANOMALIES - FUNCTIONAL DEPENDENCIES - NORMAL FORMS – BOYCE AND CODD NORMAL FORM - NORMALIZATION IN BCNF - PROPERTIES OF DECOMPOSITIONS (LOSSLESS DECOMPOSITION - MAINTAINING FUNCTIONAL DEPENDENCIES) - THIRD NORMAL FORM - OTHER NORMAL FORMS. PRESENTATION AND ANALYSIS OF PROJECTS •TRAINING SOCIETY. |
| Teaching Methods | |
|---|---|
| THE COURSE AIMS TO ACCOMPANY STUDENTS IN THE LIFELONG LEARNING PROCESS, WHICH INVOLVES CONTINUOUS UPDATING (FOR A LIFETIME) OF KNOWLEDGE AND SKILLS, TRYING TO STIMULATE CURIOSITY AND INTEREST IN INFORMATION TECHNOLOGY AND NEW TECHNOLOGIES. THEORETICAL LESSONS TO INCREASE ATTENTION AND LEARNING ABILITY, THE TEACHER WILL SHOW THE "PRACTICAL" IMPLICATIONS OF WHAT WAS PRESENTED IN CLASS AND WILL ENCOURAGE STUDENTS TO INTERACT CONTINUOUSLY WITH HIM AND WITH OTHER STUDENTS. TO MAINTAIN ALERT ATTENTION, USE WILL BE MADE OF SLIDES, SUITABLY ACCOMPANIED BY MULTIMEDIA ELEMENTS. IN ORDER TO ACCUSTOM THEM TO SELF-LEARNING, STUDENTS WILL BE INVITED TO DEEPEN THE TOPICS OF THE COURSE BY ALSO ACCESSING ONLINE RESOURCES. EXAMPLES, EXERCISES AND MINI PROJECTS THE TEACHER, TO GIVE SUBSTANCE TO WHAT IS THEORETICALLY EXPLAINED, WILL MAKE EXTENSIVE USE OF EXAMPLES, GUIDED EXERCISES TO BE CARRIED OUT IN CLASS (THE SOLUTION OF WHICH WILL BE IMMEDIATELY DESCRIBED AND COMMENTED ON) AND EXERCISES TO BE CARRIED OUT AT HOME BY THE STUDENT. THESE EXERCISES WILL BE OF INCREMENTAL COMPLEXITY, IN ORDER TO RECALL CONCEPTS STUDIED IN PREVIOUS LESSONS. THE EXERCISES WILL BE INTEGRATED WITH MINI PROJECTS, GRADUALLY MORE COMPLEX. EACH MINI PROJECT WILL INCREMENTALLY COVER THE TOPICS COVERED UP TO THAT POINT DURING THE COURSE. EACH MINI PROJECT WILL BE INTRODUCED, DESCRIBED, POSSIBLY STARTED AND THEN LEFT TO CONCLUDE FOR THE STUDENTS IN THE CLASSROOM OR AT HOME. THE COMPLETE SOLUTION OF EACH MINI-PROJECT WILL BE PRESENTED. IN THE FINAL LESSONS OF THE COURSE, THE TEACHER WILL PRESENT TWO COMPLETE AND NON-TRIVIAL PROJECTS, STARTING FROM THE ANALYSIS OF THE REQUIREMENTS UP TO THE NORMALIZATION. |
| Verification of learning | |
|---|---|
| THE ACHIEVEMENT OF THE TEACHING OBJECTIVES IS CERTIFIED BY PASSING AN EXAM WITH A RATING OUT OF THIRTY. THE EXAM MUST VERIFY THAT THE STUDENT HAS ACQUIRED THE KNOWLEDGE AND SKILLS ON EACH OF THE TWO MODULES OF THE COURSE; FOR EACH MODULE THE STUDENT MUST SHOW THAT THEY KNOW THE CONCEPTS "THEORETICALLY" AND KNOW HOW TO APPLY THE RELEVANT TECHNIQUES "PRACTICALLY". THEREFORE, THE EXAM PRESENTS A "PRACTICAL" TEST, DIVIDED INTO 2 SUB-PARTS, (MODULE 1), A "PROJECT" TEST, DIVIDED INTO 2 SUB-PARTS, (MODULE 2) AND A TEST OF "THEORETICAL" KNOWLEDGE ON CONCEPTS FROM MODULES 1 AND 2. BOTH THE VERIFICATION OF THEORETICAL KNOWLEDGE AND THE PRACTICAL AND DESIGN TESTS HAVE A MINIMUM THRESHOLD OF SUFFICIENCY, BELOW WHICH THE ENTIRE EXAM IS NOT PASSED, EVEN IF THE FAILURE CONCERNS ONLY ONE OF THEM. |
| Texts | |
|---|---|
| •P. ATZENI, S. CERI, P. FRATERNALI, S. PARABOSCHI, R. TORLONE, “BASI DI DATI – 6° EDIZIONE”, (2023) MCGRAW-HILL EDUCATION (ITALY) SRL, ISBN 978-8838656545 •(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 |
| More Information | |
|---|---|
| ON THE TEACHER'S WEBSITE (HTTP://DOCENTI.UNISA.IT/000794/HOME), SLIDES AND OTHER ONLINE RESOURCES ARE AVAILABLE |
BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2025-10-07]
