- Teaching in italian
- DATA MANAGEMENT
- DATA MANAGEMENT
- Subject area
- Reference degree course
- MANAGEMENT ENGINEERING - INGEGNERIA GESTIONALE
- Course type
- Master's Degree
- Teaching hours
- Frontal Hours: 0.0
- Academic year
- Year taught
- Course year
- PERCORSO COMUNE
- Reference professor for teaching
- LONGO ANTONELLA
No previous skills are required. The use of computer and the tools of office automation are welcome
This is a course in information systems and data modelling; it is aimed at providing principles and tools to model data in information systems. It is a necessary prerequisite for more advanced courses in the management of digital technologies in enterprises and in the study of business intelligence. Students acquire a better understanding of relational and analytical database system structures and learn structured query language. These skills prepare them to, design and develop relational and multidimensional databases, fundamental elements of Enterprise Information Systems.
Learning Outcomes; after the course the student should be able to
- Describe the model and frameworks of an Information System; illustrate the main components of an information system from the technical and application perspective and the impact of information systems on business.
- Distinguish conceptual, logical and physical models in data management.
- Model Online Transaction processing systems from a data perspective, distinguishing among ER models, relational models and physical models
- Model Online Analytical processing systems form a data perspective, distinguishing among DFM, Snowflakes and physical models, being able to describe the relationships among them and the processes
Written and Oral
The exam is made up of both written and oral part.
The written part aims at evaluating to what extent the student has: 1) the ability to design data models according to methodologies presented during the call, 2) reasoning about his/her choices and the capacity to integrate different concepts and tools.
The oral part follows the written part if the student has been scored with sufficient at least. It is aimed to verify to what extent the student has gained knowledge and understanding of selected topics and he is able to communicate them.
Introduction to Computer and Information Systems (21 hours)
- Computer, digital media, automatic information processing. Computer networks. Enterprise information systems and information architectues.
Online Transaction Processing (30 Hours)
- The aim of this module is to teach students to design database models and to implement tables, queries, forms, reports and web pages. The focus will be on why and how to use databases in some significant business scenarios. SQL and other programming languages will be presented to understand the basics of modern Web Applications and Service Oriented Architectures.
Online Analytical Processing (30 Hours)
- The aim of this module is to present models, methodologies and tools to understand Business Intelligence. Specific attention will be put on multidimensional analysis and on how to design and implement datawarehouses.
- “Fundamentals of Database Systems", 6th Edition, Elmasri, Navathe, Addison-Wesley
- “Datawarehouse Design - Modern Principles and Methodologies”, Matteo Golfarelli, Stefano Rizzi, McGrawHill
- “Management Information Systems” Kenneth Laudon, Jane Laudon, 13th edition, Global Edition, Pearson International Edition
- Teaching materials provided at the course
First Semester (dal 25/09/2017 al 22/12/2017)
Type of assessment
Oral - Final grade