INFORMATION SYSTEMS

Università degli Studi
"G. d'Annunzio"

Chieti - Pescara

Error message

User error: Failed to connect to memcache server: druportbe01:11211 in dmemcache_object() (line 415 of /production/drupal/dim_prod/drupal/d7cl4/prod/unich/releases/7/web/sites/all/modules/contrib/memcache/dmemcache.inc).

Single discipline educational activity

Course Sheet

Course code:

000233L

Academic Year of enrolment:

2023

Year of supply:

2023/2024

Type of Course:

Related/Supplementary

Degree:

Course of 2nd Cycle Degree in ECONOMICS AND COMMERCE

Disciplinary Sector:

Computer Science

Language:

Italian

Location:

PESCARA

Credits:

Programme Year:

Professor and Collaborators:

MEO MARIA CHIARA

Cycle:

Second semester

Hours of classroom activity:

Individual study hours:

102

Prerequisites:

None

Objectives

The goal is to provide an in-depth and up-to-date knowledge of the most
important aspects of database systems and applications.

Learning outcomes
Understand what is a database, from the conceptual, mathematical and practical point of view;
become able to develop the conceptual, logical and physical design of a relational database, including both the structure and the operations;
understand how the database systems work.

Contents

The fundamental concepts necessary for designing, using, and implementing database systems and database applications.

Extended Syllabus

- The basic introductory concepts necessary for a good understanding of database models, systems, and languages.
- Databases, typical users, and DBMS concepts, terminology, and architecture.
- The conceptual database design and the concepts of the Entity-Relationship (ER) model and ER diagrams,
- The relational data model,
- The SQL standard
- Some of the basic parts of the SQL standard for relational databases, including data definition, data modification
operations, and simple SQL queries.
- More complex SQL queries, views, and schema modification.
- MySQL

Recommended Bibliography

P.ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE, Database Systems - Concepts, Languages and Architectures, McGraw-Hill.

Slides provided by the teacher and supplementary useful material will be
made available for the students on the platform
https://fad.unich.it/

Methods of Provision

Conventional

Teaching Methods

Front lectures and exercises in classroom using blackboard, projector and
computer; practical activities (guided exercices) at the Laboratory of
Computer Science.

Evaluation methods

Verification of learning:

Written exam.

Other courses

Course year: 1

BUSINESS INFORMATION SYSTEMS
6 Credits - Characterising
ECONOMY OF NETWORKS AND INNOVATION
9 Credits - Characterising
INTERNATIONAL ECONOMICS
9 Credits - Characterising
MARKET ANALYSIS
9 Credits - Characterising
COMPUTER LANGUAGES FOR STATISTICS
6 Credits - Related/Supplementary
INFORMATION SYSTEMS
6 Credits - Related/Supplementary
OPERATIONAL RESEARCH
6 Credits - Related/Supplementary

Course year: 2

ECONOMIC STATISTICS
9 Credits - Characterising
ECONOMICS GROWTH AND TECHNOLOGICAL CHANGE
9 Credits - Characterising
LINEAR MODELS
6 Credits - Characterising
STATISTICAL METHODS FOR ECONOMIC ANALYSIS
9 Credits - Characterising
TIME SERIES ANALYSIS
9 Credits - Characterising
ELECTIVE COURSE
9 Credits - Elective Course

Search form

Aree

Error message

INFORMATION SYSTEMS