2. Professors
  3. POSTIGLIONE Alberto
  4. Teaching

DATA BASE AVANZATI

Alberto POSTIGLIONE DATA BASE AVANZATI

0212700137
DIPARTIMENTO DI SCIENZE AZIENDALI - MANAGEMENT & INNOVATION SYSTEMS
EQF6
BUSINESS MANAGEMENT
2016/2017



YEAR OF DIDACTIC SYSTEM 2014
SECONDO SEMESTRE
CFUHOURSACTIVITY
530LESSONS
ALBERTO POSTIGLIONE Curriculum
Objectives
DUBLIN DESCRIPTORS

KNOWLEDGE AND UNDERSTANDING
THE AIM OF THE COURSE IS TO GIVE AN INTRODUCTION TO CONCEPTS ("KNOWING") AND BASIC TECHNIQUES ("KNOW HOW") OF DATABASES, ON QUERY LANGUAGES AND ON MANAGEMENT AND TECHNICAL AND DESIGN METHODS THAT MAY BE USEFUL TO THE STUDENT FOR THE CONTINUATION OF THE MASTER'S STUDIES AND FOR HIS FUTURE WORK.
SPECIFICALLY, WITH REGARD TO KNOWLEDGE, IT WILL INITIALLY DEEPENED THE STUDY ON THE DATABASES THAT STUDENTS HAVE ALREADY ADDRESSED IN THEIR PREVIOUS COURSES: THE RELATIONAL MODEL AND THE RELATED LANGUAGES WITH REFERENCE TO EXISTING SYSTEMS (PARTICULARLY THE SQL LANGUAGE). IT WILL THEN TACKLED THE CONCEPTUAL AND LOGIC DESIGN PROCESS OF RELATIONAL DATABASES, AND THEIR VERIFICATION AND OPTIMIZATION, WHICH WILL ALLOW, STARTING FROM USER REQUIREMENTS, GETTING TO PRODUCE QUALITY DATA BASES STRUCTURES. THEY WILL BE DEEPENED THE MAIN TECHNIQUES FOR VISUALIZATION AND DATA PROCESSING, SUCH AS REPORTS, FORMS AND MODULES).
FINALLY, THEY WILL BE INTRODUCED SOME ADVANCED TOPICS SUCH AS DATA WAREHOUSING AND DATA MINING, THE PROBLEM OF BIG DATA, THE BASICS OF ONLINE DATA, THE MULTIMEDIA DATABASES.
APPLYING KNOWLEDGE AND UNDERSTANDING

PARTICULAR EMPHASIS IT IS PLACED ON APPLICATIONS, WHICH IS A FUNDAMENTAL PART OF THE COURSE AND OF THE FINAL EVALUATION.
THE STUDENT WILL BE ABLE TO DESIGN, FIRST CONCEPTUALLY AND THEN LOGICALLY, A RELATIONAL DBMS USING APPROPRIATE CASE TOOLS. HE WILL BE ABLE TO VERIFY THE DESIGN THROUGH THE MAIN TECHNIQUES OF DESIGN OPTIMIZATION, SUCH AS NORMALIZATION. AT THE END OF THE COURSE STUDENTS WILL BE ABLE TO DEVELOP SMALL DB-BASED MULTIMEDIA APPLICATIONS ACTUALLY RUNNING, FROM PROJECTS DEVELOPED DURING THE COURSE.
MAKING JUDGMENTS

ABILITY TO ASSESS THE FEASIBILITY OF A DESIGN BASED ON A DB. KNOWLEDGE OF THE REAL POTENTIAL THAT A DBMS PROVIDES
COMMUNICATION SKILLS

KNOWLEDGE OF TECHNICAL TERMS AND THE COMMUNICATION TOOLS AVAILABLE IN A DBMS ENVIRONMENT (REPORTS, FORMS, MODULES, APPLICATIONS, ...). THE STUDENT WILL BE ABLE TO DEVELOP FULLY FUNCTIONAL APPLICATIONS WITH FRIENDLY INTERFACES (EVEN IN THE WEB).
LEARNING ABILITY

TO INCREASE THE LEARNING ABILITY WE WILL TRY TO STIMULATE THE CURIOSITY AND INTEREST BY PRESENTING THE "PRACTICAL" IMPLICATIONS OF WHAT IS SAID, OR DONE, TO CLASS. WE WILL TRY TO STIMULATE A CONTINUED DIALOGUE WITH THE STUDENTS AND MOTIVATE THEM TO CONSTANTLY STUDY THROUGH "EVIDENCE ELAPSED" THAT COULD ALSO APPLY FOR PARTIAL EXEMPTIONS FROM EXAMS.
IN THE LESSONS IT WILL BE MADE USE OF TRANSPARENCIES TO PRESENT ARGUMENTS, SUITABLY ACCOMPANIED BY MULTIMEDIA ELEMENTS, TO TRY TO KEEP THE EVER-VIGILANT ATTENTION.
THE STUDENT WILL COME INVITED TO DEEPEN THE TOPICS PRESENTED IN CLASS, CITING WEBSITES AND ONLINE RESOURCES OF PARTICULAR INTEREST.
IT WILL BE VERY INTENSIVE THE RECOURSE TO EXAMPLES, IN THE CLASSROOM, AND TO EXERCISES TO BE DONE IN THE CLASSROOM OR AT HOME BY THE STUDENT, WITH THEIR CORRECTION TO THE NEXT LESSON.
Prerequisites
BASIC THEORETICAL KNOWLEDGE ON RELATIONAL DATABASE MANAGEMENT SYSTEMS (RELATIONAL MODEL, CONCEPTS OF DATA TYPES, RELATIONAL AND INTER-RELATIONAL CONSTRAINTS, LANGUAGES QBE AND SQL, BASIC QUERIES UNTIL TO THE NESTED QUERIES) AND PRACTICAL KNOWLEDGE ON BASIC OPERATIONS (CREATION, MODIFICATION AND POPULATION OF TABLES, FORMS AND REPORTS, CONSTRAINTS AND USE OF QBE AND SQL).
Contents
INTRODUCTION:
• INFORMATION SYSTEMS, INFORMATION AND DATA
• DATABASES AND DATA BASE MANAGEMENT SYSTEMS
• MODELS OF THE DATA,
• LANGUAGES AND USERS OF DATABASES,
• ADVANTAGES AND DISADVANTAGES OF DBMS

THE RELATIONAL MODEL.
• THE RELATIONAL MODEL STRUCTURES
• INTEGRITY CONSTRAINTS

SQL:
• DEFINITION OF DATA IN SQL
• QUERIES IN SQL,
• MANIPULATION OF DATA IN SQL
• ACCESS CONTROL
• USE SQL IN PROGRAMMING LANGUAGES.

THE DATABASE DESIGN:
• INTRODUCTION TO THE DESIGN
• METHODS AND MODELS FOR THE PROJECT
• THE ENTITY-RELATIONSHIP MODEL
• DOCUMENTATION OF SCHEMES E-R

CONCEPTUAL DESIGN:
• THE COLLECTION AND ANALYSIS OF THE REQUIREMENTS
• BASIS OF PRESENTATION
• PROJECT STRATEGY
• QUALITIES OF A CONCEPTUAL SCHEME

LOGICAL DESIGN:
• PERFORMANCE ANALYSIS OF E-R SCHEMES
• RESTRUCTURING OF SCHEMES E-R
• TRANSLATION INTO THE RELATIONAL MODEL
• LOGICAL DESIGN WITH CASE TOOLS.

NORMALIZATION:
• REDUNDANCY AND ANOMALIES
• FUNCTIONAL DEPENDENCIES
• NORMAL FORM BOYCE AND CODD
• PROPERTIES OF THE DECOMPOSITIONS
• THIRD NORMAL FORM
• DATABASES DESIGN AND STANDARDISATION

TOPICS OF LABORATORY ACTIVITIES:
• CONCEPTUAL DESIGN WITH CASE TOOLS
• LOGICAL DESIGN WITH CASE TOOLS
• MICROSOFT ACCESS: SYSTEM FEATURES, THE DEFINITION OF THE TABLES, SPECIFICATION OF JOIN PATHS, POPULATING THE TABLES, THE QUERY DEFINITION, QUERY BY EXAMPLE, THE SQL INTERPRETER, FORMS AND REPORTS, THE MACRO DEFINITION
• MENTION TO MYSQL
Teaching Methods
LECTURES AND GUIDED EXERCISES. FREE EXERCISES WITH TRACES PROVIDED BY THE TEACHER THAT WILL BE DISCUSSED IN THE CLASSROOM.
Verification of learning
THE FINAL EXAM TAKES PLACE AT THE COMPUTER LAB.
IT INCLUDES:
• VERIFICATION OF KNOWLEDGE OF THE THEORETICAL ARGUMENTS
• COMPLETE DESIGN OF A DBMS.
EACH PART HAS A MINIMUM THRESHOLD, BELOW WHICH THE COMPLETE EXAMINATION IS NOT PASSED.
Texts
P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE: BASI DI DATI: MODELLI E LINGUAGGI DI INTERROGAZIONE, MCGRAW-HILL ITALIA
- RAMEZ ELMASRI, SHAMKANT NAVATHE: SISTEMI DI BASI DI DATI, PEARSON/ADDISON WESLEY
SLIDES OF THE COURSE AND ADDITIONAL TEACHING MATERIALS (TUTORIALS, EXAMS, ...), THEY CAN BE DOWNLOADED FROM THE TEACHER'S SITE (HTTP://WWW.UNISA.IT/DOCENTI/POSTIGLIONEA/INDEX )
More Information
NONE
  BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2019-03-11]