ADVANCED INFORMATION TOOLS FOR BUSINESS
Objectives of the course:
The aim of the course is to provide students with:
1) a base of knowledge of mathematical methods for optimization, with applications to economic decision analysis;
2) advanced knowledge for planning and management of databases.
Expected learning outcomes
Knowledge and understanding: the student should be able to understand the mathematical methods used in linear optimization problems and the principles of designing and managing a database. It should also be able to use the normally available software (as a minimum, Microsoft Access and the resolver in Excel).
Applying knowledge and understanding: the student should be able to apply the acquired knowledge in solving real business planning problems such as maximizing profits or minimizing costs. To this end the teacher will discuss and illustrate some different real cases during the lessons; for non-attending students, assistance time will be provided.
Making judgements: the student should be able to use the acquired knowledge also in an autonomous way, by also applying them even in contexts not directly proposed.
Communication: the student should be able to answer in a clear and thorough way to the problem proposed in the written examination and the questions formulated inf the possible oral examination.
Lifelong learning skills: the student should be able to show a good learning ability, by widening, for example, his/her knowledge with use of relevant bibliographic references, The student should also be able to analyze and evaluate the impact and the constraints related complex situations.
Linear algebra: systems of linear equations, vector and matrix calculus. Functions of several variables.
BASIC KNOWLEDGE OF DATA PROCESSING.
this is basically covered by the first-level courses offered by the university Parthenope in the economic area. For students coming from different first-level degree programs, an integration including a relevant bibliographic reference will be provided.
Unconstrained and constrained optimization problems. Introduction to Linear Programming. Excel risolutor.
RELATIONAL DATABASE: MODELS AND LANGUAGES. SQL LANGUAGE. DATABASE MICROSOFT ACCESS. USE OF ACCESS DBMS FOR SOLVING ECONOMIC PROBLEMS. TABLES, QUERIES AND REPORTS.
During the lessons the issues mentioned in the study program will be discussed and presented, together with applications and examples such as specific cases of regulation in typical markets or sectors. Additional didactic and support material is made available on the teacher web page, where slides presentation used at lesson can be found, together with additional material for deepening a number of thematic issues.
The main readings will be suggested at the beginning of the course. For students who speak Italian, the main reference is represented by the following book:
DE CESARE, MADDALENA, Introduzione alla Programmazione Lineare, Giappichelli
P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE, “Basi di dati – Modelli e linguaggi di interrogazione”, McGraw Hill.
P. ATZENI, A. DE CHECCHI, G. SINDONI, M. TIRELLI, G. FIORENTINO, A.P. PALA, “IT4PS – Le Basi di Dati per Economia”, McGraw Hill
The assessment is based on a structured written test aimed at evaluating the actual achievement of the objectives on part the students. In order to evaluate the depth in understanding general theoretical knowledge, a real problem is proposed. The students should be able to fully solve it by developing the mathematical formulation of the same and implementing the resolution software. The time allocated for completion of the test is 1 hour. The test runs on the computer and is evaluated in a scale from 0 to 30.
An oral examination can also be held, in case the teacher judges it useful to better ascertain the student’s knowledge. The vote 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.