Genoveffa TORTORA | DATA BASE
Genoveffa TORTORA DATA BASE
cod. 0512700015
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 |
| SSD | CFU | HOURS | ACTIVITY | |
|---|---|---|---|---|
| INF/01 | 5 | 40 | LESSONS | |
| INF/01 | 1 | 12 | EXERCISES |
| 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: 2024-08-21]
