Genoveffa TORTORA | DATABASES
Genoveffa TORTORA DATABASES
cod. 0512100008
DATABASES
| 0512100008 | |
| COMPUTER SCIENCE | |
| EQF6 | |
| COMPUTER SCIENCE | |
| 2023/2024 |
| OBBLIGATORIO | |
| YEAR OF COURSE 2 | |
| YEAR OF DIDACTIC SYSTEM 2017 | |
| AUTUMN SEMESTER |
| SSD | CFU | HOURS | ACTIVITY | |
|---|---|---|---|---|
| INF/01 | 6 | 48 | LESSONS | |
| INF/01 | 3 | 24 | LAB |
| Objectives | |
|---|---|
| KNOWLEDGE AND UNDERSTANDING THE STUDENT IS EXPECTED TO ACQUIRE KNOWLEDGE ON: •STRUCTURE AND FUNCTIONALITY OF AN INFORMATION SYSTEM, •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, •ASSESS THE IMPLICATIONS, ON THE DATABASE DEVELOPMENT, OF TRADE-OFF BETWEEN PERFORMANCE AND RESOURCES USAGE. |
| Prerequisites | |
|---|---|
| THE COURSE ASSUMES KNOWLEDGE OF: •FUNDAMENTALS OF COMPUTER SCIENCE •PROCEDURAL AND OBJECT-ORIENTED PROGRAMMING •ABSTRACTION CONCEPTS AND ABSTRACT DATA TYPES •FUNDAMENTALS OF JAVA LANGUAGE STUDENTS ARE SUPPOSED TO HAVE THE CAPABILITY OF WRITING SIMPLE PROGRAMS TO MANAGE ARCHIVES THROUGH FILE SYSTEMS. |
| Contents | |
|---|---|
| INTRODUCTIVE CONCEPTS • INTRODUCTION TO DATABASE SYSTEMS (2 HOURS) • DBMS LANGUAGES AND ARCHITECTURES (2 HOURS) CONCEPTUAL AND LOGICAL MODELLING OF DATABASES • THE ENTITY/RELATIONSHIP MODEL (6 HOURS) • THE RELATIONAL DATA MODEL (4 HOURS) • CONCEPTUAL SCHEMA RESTRUCTURING TECHNIQUES (4 HOURS) • MAPPING ER MODEL TO RELATIONAL MODEL (4 HOURS) • AUTOMATED TOOLS SUPPORTING DATABASE DESIGN (2 HOURS) QUERY LANGUAGES AND DESIGN METHODOLOGIES: • RELATIONAL ALGEBRA (6 HOURS) • THE SQL LANGUAGE (10 HOURS) • THE JDBC FUNCTION LIBRARY (4 HOURS) • NORMALIZATION OF RELATIONAL DATABASES (4 HOURS) LABORATORY • CONCEPTUAL DESIGN (4 HOURS) • CASE TOOLS SUPPORTING CONCEPTUAL DESIGN (2 HOURS) • LOGICAL DESIGN (4 HOURS) • RELATIONAL ALGEBRA QUERY DEVELOPMENT (4 HOURS) • THE RELATIONAL DBMS MYSQL (2 HOURS) • SQL QUERY DEVELOPMENT (4 HOURS) • JAVA/JDBC PROGRAMMING (4 HOURS) |
| Teaching Methods | |
|---|---|
| THE COURSE INCLUDES: •THEORETICAL-METHODOLOGICAL FRONTAL LECTURES (6 CFUS/48 HOURS), TO TRANSFER THE KNOWLEDGE RELATED TO THE COURSE CONTENTS •LABORATORY SESSIONS (3 CFUS/24 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 ARTEFACTS, 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”, 6TH EDITION, MCGRAW-HILL, 2023 •R. A. ELMASRI, S. B. NAVATHE, “FUNDAMENTALS OF DATABASE SYSTEMS”, 7TH EDITION, PEARSON, 2015 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/ CONTACTS PROF.SSA GENOVEFFA TORTORA TORTORA@UNISA.IT |
BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2024-11-05]
