Alberto POSTIGLIONE | DATABASES
Alberto POSTIGLIONE DATABASES
cod. 0212700129
DATABASES
| 0212700129 | |
| DEPARTMENT OF MANAGEMENT & INNOVATION SYSTEMS | |
| EQF6 | |
| BUSINESS MANAGEMENT | |
| 2024/2025 |
| OBBLIGATORIO | |
| YEAR OF COURSE 3 | |
| YEAR OF DIDACTIC SYSTEM 2014 | |
| SPRING SEMESTER |
| SSD | CFU | HOURS | ACTIVITY | |
|---|---|---|---|---|
| INF/01 | 9 | 54 | LESSONS |
| Exam | Date | Session | |
|---|---|---|---|
| POSTIGLIONE | 09/12/2024 - 09:00 | SESSIONE ORDINARIA | |
| POSTIGLIONE | 09/12/2024 - 09:00 | SESSIONE DI RECUPERO |
| Objectives | |
|---|---|
| EDUCATIONAL OBJECTIVES THE OBJECTIVE OF THE COURSE IS TO OFFER FUNDAMENTAL CONCEPTS AND TECHNIQUES, QUERY AND MANAGEMENT LANGUAGES AND TECHNIQUES AND METHODS FOR DESIGNING A DATABASE, WHICH MAY BE USEFUL TO THE STUDENT FOR THE CONTINUATION OF HIS MASTER'S STUDIES AND FOR HIS FUTURE WORK. . KNOWLEDGE AND UNDERSTANDING. THE STUDENT WILL ACQUIRE KNOWLEDGE RELATING TO: •THE RELATIONAL MODEL AND RELATED LANGUAGES WITH REFERENCE TO EXISTING SYSTEMS (IN PARTICULAR THE SQL LANGUAGE), •THE MAIN TECHNIQUES FOR QUERYING AND MANIPULATING A DATABASE, •THE PROCESS OF CONCEPTUAL AND LOGICAL DESIGN OF RELATIONAL DATABASES, AND THEIR VERIFICATION AND OPTIMIZATION. •TO IMPORT/EXPORT DATA TO OTHER APPLICATIONS, •TO THE CREATION OF SMALL DATA-BASED APPLICATIONS, IMMEDIATELY USABLE. ABILITY TO APPLY KNOWLEDGE AND UNDERSTANDING THE STUDENT WILL BE ABLE TO START FROM USER REQUIREMENTS AND END UP PRODUCING QUALITY DATABASE STRUCTURES. IN PARTICULAR, HE WILL BE ABLE TO: •DESIGN FIRST CONCEPTUALLY AND THEN LOGICALLY A RELATIONAL DBMS. •CHECK THE DRAWING THROUGH THE MAIN DESIGN OPTIMIZATION TECHNIQUES, SUCH AS NORMALIZATION. •QUERY AND MODIFY A DATABASE, EVEN IN A SOPHISTICATED WAY, USING SENTENCES IN THE SQL LANGUAGE. •DEVELOP SMALL DB-BASED MULTIMEDIA APPLICATIONS BASED ON REAL CASES, IMMEDIATELY USABLE. COMMUNICATION SKILLS THE STUDENT WILL BE ABLE TO: -STRUCTURE AND DISSEMINATE INFORMATION IN VARIOUS CONTEXTS (INCLUDING NON-SPECIALIST ONES) WITH AN ADEQUATE VOCABULARY; -MANAGE IT TOOLS AND SUPPORTS; -PREPARE REPORTS AND REPORTS (BOTH INDIVIDUAL AND IN GROUPS). LEARNING ABILITY THE STUDENT WILL BE ABLE TO: -FIND THE INFORMATION NECESSARY TO UPDATE BOTH GENERAL AND SPECIALIZED KNOWLEDGE; -CRITICALLY ANALYZE AND PROCESS AND INTEGRATE DATA, INFORMATION AND EXPERIENCES, INCLUDING THROUGH SOFTWARE OR OTHER TECHNOLOGICAL SUPPORTS. |
| Prerequisites | |
|---|---|
| BASIC CONCEPTS OF COMPUTER SCIENCE, AS FROM THE COURSE "FONDAMENTI DI INFORMATICA" OF THIS DEGREE COURSE. |
| Contents | |
|---|---|
| THE COURSE CONSISTS OF 54 TEACHING HOURS (9 CREDITS). IN PARTICULAR, 6 CREDITS (36 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 (24 HOURS IN TOTAL, OF WHICH 18 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-AIR RELATIONSHIP. •NOTES ON THE NORMALIZATION OF A LOGICAL SCHEME PRESENTATION AND ANALYSIS OF PROJECTS •• SCIENTIFIC JOURNAL - 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 – 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 |
| 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: 2024-11-18]
