Università degli Studi di Napoli "Parthenope"

Teaching schedule

Academic year: 
2019/2020
Belonging course: 
Disciplinary sector: 
MATHEMATICAL METHODS OF ECONOMY, FINANCE AND ACTUARIAL SCIENCES (SECS-S/06)
Language: 
Italian
Credits: 
9
Year of study: 
2
Teachers: 
Cycle: 
First Semester
Hours of front activity: 
72

Language

Italian

Course description

The aim of the course is to train a student with the knowledge and skills necessary for an effective and efficient use of information assets in companies. He will be able to contribute to the construction, updating and management of databases, in order to use them for the strategic analysis of market data. Furthermore, he will be able to evaluate the company's positioning in the various market segments, evaluate the potential for expansion of new markets and analyze the trends in goods and make forecasts of consumer and investment goods. Furthermore, the course will be in line with the knowledge required for admission to the state exam for the Junior Actuary profession.
Knowledge and understanding skills
The aim of the course is to offer an introduction to concepts ("know") and fundamental techniques ("know how") on data bases, on query and management languages and on design techniques and methods that can be useful to the student for the continuation of the magisterial studies and for his future work.
In particular, with regard to knowledge, the study of the databases will initially be explored: the relational model and the related languages with reference to the existing systems (in particular to the sql language). The conceptual and logical design process of relational databases will then be addressed, and their verification and optimization, which will allow, starting from the user requirements, to arrive at producing quality database structures. The main techniques for visualizing and processing data, such as reports, forms and forms) will be examined in depth.
Finally, some advanced topics will be introduced such as data warehousing and data mining, the big data problem, online databases, multimedia databases.
Ability to apply knowledge and understanding
Particular emphasis will be placed on the applicative aspect, which is a fundamental part of the course and of the final evaluation.
The student will be able to first conceptually and then logically, design a relational database using appropriate tools. He will be able to verify the project through the main optimization techniques, such as standardization. At the end of the course the student will be able to develop small, effective db-based applications starting from projects developed during the course.
Autonomy of judgment
Ability to evaluate the feasibility of a design based on a database management system. Knowledge on the actual potential that a dbms makes available.
Communication skills
Knowledge of technical terminology and communication tools available in a dbms environment (reports, forms, modules, applications, ...). The student will be able to develop fully functional applications with friendly interfaces.

Prerequisites

Basic knowledge of Computing is required, with particular reference to the Data Types. The ability of the student to translate simple real problems into algorithms that can be implemented on a computer is required.

Syllabus

Block 1 - DATABASE (12 h):
1. Concept of databases
2. Use of a database
3. Model of data
4. Non-relational databases
5. Relational databases
6. The SQL language
Block 2 - DATA MANIPULATION OPERATIONS (16 h):
1. Queries on a table
2. Queries on multiple tables
3. Interrogations by operators on sets
4. Subqueries
5. Data manipulations
Block 3 - DATA DEFINITION OPERATIONS (16 h):
1. Creating tables
2. Types of data
3. Constraints
4. Controls
Block 4 - DATA ACCESS (16 h):
1. Logical views
2. Management of transactions
3. Security in access to data
Block 5 - DISTRIBUTED DBMS AND CLIENT / SERVER ARCHITECTURES (12 h):
1. Distribution of data
2. Client / Server Data Warehouse Architectures
3. The data mining process

Block 1 - DATABASE (12 h):
1. Concept of databases
2. Use of a database
3. Model of data
4. Non-relational databases
5. Relational databases
6. The SQL language
Block 2 - DATA MANIPULATION OPERATIONS (16 h):
1. Queries on a table
2. Queries on multiple tables
3. Interrogations by operators on sets
4. Subqueries
5. Data manipulations
Block 3 - DATA DEFINITION OPERATIONS (16 h):
1. Creating tables
2. Types of data
3. Constraints
4. Controls
Block 4 - DATA ACCESS (16 h):
1. Logical views
2. Management of transactions
3. Security in access to data
Block 5 - DISTRIBUTED DBMS AND CLIENT / SERVER ARCHITECTURES (12 h):
1. Distribution of data
2. Client / Server Data Warehouse Architectures
3. The data mining process

Teaching Methods

To improve and increase the ability to learn we will try to stimulate curiosity and interest by presenting the "practical" aspects of what is said, or done, in class. We will try to stimulate a continuous dialogue with the students and to motivate them to a constant study through "inter-trial tests" that could also be valid for partial exoneration of exam tests.
In the lessons will be made use of transparencies to present the topics, adequately accompanied by multimedia elements, to try to keep the attention always alert.
The student will be invited to deepen the topics presented in class indicating websites and online resources of particular interest.
There will be an extremely intensive appeal to examples to illustrate in the classroom by the teacher or exercises to be carried out in the classroom or at home by the student, with correction in the next lesson.

Textbooks

Atzeni P., Ceri S., Fraternali P., Paraboschi S., Torlone R. “Database Systems”. McGraw-Hill ISBN 978-88-386-9445-5.

Learning assessment

The assessment is based on a written examination and on a project work for attending students, while assessment consists of a written examination and of an oral examination for non-attending students.
The written examination consists of five open questions (with a maximum score of 5 points for each answer) and one exercise on the sql code (with a maximum score of 5 points).
The project work focuses on the analysis of a case study and on the elaboration of an information system project and the creation of a database.
The vote of the project work or of the oral examination is expressed in scale from 0 to 30, and it is averaged with the vote of written examination (equal weighting) in order to determine the final vote.

More information

The course is held in DAD mode through the Microsoft Teams application as part of the "Elaborazione dei Dati 2020-2021" team with access code: vjgtvyx