Università degli Studi di Napoli "Parthenope"

Teaching schedule

Academic year: 
2015/2016
Partition: 
Matricole dispari
Belonging course: 
Course of Bachelor's Degree Programme on ECONOMIA AZIENDALE
Location: 
Napoli
Disciplinary sector: 
OPERATIONAL RESEARCH (MAT/09)
Credits: 
3
Year of study: 
3
Teachers: 
Cycle: 
Second semester

Language

Italian

Course description

The module is aimed at providing learners with the knowledge and abilities needed to efficiently and effectively use corporate informational assets, and to be able to participate in teams who build, manage, and update databases in order to use them for strategical analysis of market data, assessment of the corporate positioning across market segments, evaluating the potential of new markets, analyzing the evolution of assets, and making forecasts on consumer goods and investments.
Acquiring knowledge and understanding
The module is aimed at providing learners with an introduction to the concepts (“knowledge”) and techniques (“abilities”) of data bases, query languages, and design methods and tools, which will be useful in further studies and professional life.
In particular, the initial study of Data Bases will include the relational model with its languages, in particular the SQL language. Subsequently, conceptual and logical database design will be discussed.
Applying knowledge and understanding
Focus will be given to application, an essential part of the module and of the final assessment.
Learners will be able to design, conceptually and logically, a relational database, using appropriate tools. Upon completion of the module, learners will be able to build small db-based applications, starting from projects developed during the module.
Making informed judgements and choices
Learners should be able to assess the feasibility of a design centered on a Data Base Management System and to evaluate the potential benefits of a DBMS.
Communicating knowledge and understanding
Learners should be able to use correctly the lexicon and the communication tools available in a DBMS (reports, forms, modules, apps).

Prerequisites

A basic knowledge of Informatics is required, essentially regarding data types. Learners are expected to be able to formulate algorithms for the solution of simple problems.

Syllabus

Unit 1 – DATABASE (6 h):
1. Notion of a database
2. Use of a database
3. Data model
a. Relational databases
b. Non-relational databases
4. The SQL language
Unit 2 –DATA MANIPULATION IN SQL (6 h):
1. Queries on a single-table
2. Queries on multiple tables
3. Queries based on set operations
4. Subqueries
5. Data manipulation
Unit 3 –DATA DEFINITION IN SQL (6 h):
1. Table creation
2. Data types
3. Constraints
4. Commands
Blocco 4 – PROGETTAZIONE DI BASI DI DATI (6 h):
1. Phases in database design
2. ER model
3. Documentation in the ER model

Unit 1 – DATABASE (6 h):
1. Notion of a database
2. Use of a database
3. Data model
a. Relational databases
b. Non-relational databases
4. The SQL language
Unit 2 –DATA MANIPULATION IN SQL (6 h):
1. Queries on a single-table
2. Queries on multiple tables
3. Queries based on set operations
4. Subqueries
5. Data manipulation
Unit 3 –DATA DEFINITION IN SQL (6 h):
1. Table creation
2. Data types
3. Constraints
4. Commands
Blocco 4 – PROGETTAZIONE DI BASI DI DATI (6 h):
1. Phases in database design
2. ER model
3. Documentation in the ER model

Teaching Methods

To improve and augment the capacity to continue learning, curiosity and interest will be stimulated emphasizing the practical aspects of themes presented in the lectures.
To keep participation high and motivate learners to continued study, partial tests will be held, possibly valid as substitutes for parts of the exam.
Lectures will be based on slides enriched with multimedia elements, to enhance attention. Learners will be invited to deepen their understanding of the module themes, suggesting interesting websites and resources.
Examples will be illustrated in the lectures and homework will be proposed and discussed.

Textbooks

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

Learning assessment

Final assessment will consist in a written test and an optional oral exam. The written test will comprise five closed-type questions (worth 2 points each) and two exercises (worth 10 points each). The oral examination will be graded on a 0 to 30 scale and the grade will be averaged (with equal weight) with the one obtained in the written test.

More information

Mutuazioni