Portale di Ateneo - En.Unibs.it

Borrowed courses

INTRODUCTION TO DATABASES

INGEGNERIA ELETTRONICA E DELLE TELECOMUNICAZIONI

comune
INTRODUCTION TO DATABASES

INGEGNERIA ELETTRONICA E DELLE TELECOMUNICAZIONI

comune
INTRODUCTION TO DATABASES

INGEGNERIA DELL'AUTOMAZIONE INDUSTRIALE

comune

Other Courses of the Study Programme

Course year: 1

ALGEBRA AND GEOMETRY - 9 credits - Basic
BASIC CHEMISTRY - 6 credits - Basic
COMPUTER SCIENCE
Attendance grouping
12 credits - Raggruppamento di frequenza
EXPERIMENTAL PHYSICS 1 (MECH., TERM.) - 9 credits - Basic
INTRODUCTION TO BASIC MATTERS - MATHEMATICS - Student's own choice
MATHEMATICAL ANALYSIS I (SECTION 1) - 9 credits - Basic
PROBABILITY AND STATISTICS - 6 credits - Basic
TEST OF ENGLISH - 3 credits - Language/Final Examination
TEST OF FRENCH - 3 credits - Language/Final Examination
TEST OF GERMAN - 3 credits - Language/Final Examination
TEST OF SPANISH - 3 credits - Language/Final Examination

Course year: 2

ADVANCED PROGRAMMING JAVA, C - 9 credits - Characterising
APPLIED ECONOMICS IN ENGINEERING - 6 credits - Related/Supplementary
COMMUNICATION NETWORKS
Attendance grouping
9 credits - Raggruppamento di frequenza
COMPUTER ORGANIZATION AND DESIGN - 6 credits - Characterising
ELECTRICAL CIRCUITS FOR ELECTRONICS - 6 credits - Related/Supplementary
EXPERIMENTAL PHYSICS 1 (ELECTROMAG, OPTICS EM WAVES) - 6 credits - Basic
FUNDAMENTALS OF SYSTEMS AND CONTROL - 9 credits - Characterising
MATHEMATICAL ANALYSIS AND OPERATIONS RESEARCH
Attendance grouping
12 credits - Raggruppamento di frequenza

Course year: 3

ALGEBRA FOR CODING THEORY AND CRYPTOGRAPHY - 6 credits - Student's own choice
APPLIED ANALYSIS
Attendance grouping
6 credits - Raggruppamento di frequenza - Student's own choice
DEVICES FOR TELECOMMUNICATIONS - 6 credits - Student's own choice
DIGITAL CONTROL SYSTEMS - 6 credits - Student's own choice
FINAL THESIS - 3 credits - Language/Final Examination
FUNDAMENTALS OF SIGNALS AND SYSTEMS - 6 credits - Characterising
GENERAL ELECTRONICS
Attendance grouping
9 credits - Raggruppamento di frequenza
LEGISLATION AND REGULATION FOR TELECOMMUNICATIONS - 6 credits - Characterising
MODELS WITH DIFFUSION - 3 credits - Student's own choice
OPERATING SYSTEMS AND COMPUTING INFRASTRUCTURES
Attendance grouping
12 credits - Raggruppamento di frequenza
PRINCIPLES OF BIOLOGY AND BIOMEDICINE
Attendance grouping
6 credits - Raggruppamento di frequenza - Student's own choice
PROGRAMMING LANGUAGES & INTRODUCTION TO DATABASES
Attendance grouping
12 credits - Raggruppamento di frequenza
SHOCK WAVES - 3 credits - Student's own choice
SIGNALS AND SYSTEMS - 9 credits - Student's own choice
SOFTWARE ENGINEERING - 9 credits - Characterising
STAGE - 12 credits - Student's own choice
SYSTEMS FOR INDUSTRY AND PLC - 6 credits - Student's own choice
TECHNOLOGIES OF ARTIFICIAL LANGUAGES - 6 credits - Student's own choice
UNCERTAIN DYNAMICAL SYSTEMS - 6 credits - Student's own choice

INTRODUCTION TO DATABASES

Single discipline educational activity

Course Sheet

Academic Year of enrolment:

2016/2017

Academic Year of provision:

2018/2019

Type of Course:

Characterising

Degree:

Bachelor's Degree Programme in COMPUTER SCIENCE AND ENGINEERING

Disciplinary Sector:

Data Processing Systems

Language:

Italian

Grouping head:

PROGRAMMING LANGUAGES & INTRODUCTION TO DATABASES

Grouping type:

Credits:

Programme Year:

Professor and Collaborators:

MELCHIORI Michele Professor

GERMINARIO Maddalena Collaborator

Cycle:

Second semester

Hours of classroom activity:

Hours of individual study:

Knowledge about computer priciples and programming.

Educational Goals

This course aims at providing students with general and practical abilities for the design, implementation and querying of databases.

Content

The course provides an introduction to databases, their design, use and to the systems for database management (DBMS).

SYLLABUS

Introduction to database concepts and terminology.

Conceptual and logical models.

Query languages.

Database design.

SQL and programming laguages.

Introduction to the database normalization theory.

Introduction to database transactions.

Use of transactions for development of applications.

Laboratory sessions with database implementation and querying by means of open source and commercial tools.

Extended Syllabus

Introduction to database concepts and terminology.

Conceptual and logical models.

Query languages.

Database design.

SQL and programming laguages.

Introduction to database normalization theory.

Use of transactions for development of applications.

Laboratory sessions with database implementation and querying by means of open source and commercial tools.
Laboratory lessons on the PHP programming language for data intensive Web applications.

Recommended Bibliography

(These textbooks are in Italian language. Equivalent textbooks in English can be suggested by the teacher)

* Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi e Riccardo Torlone, Basi di dati - Modelli e linguaggi di interrogazione 4/ed, McGraw-Hill Italia, 2013
* For exercises:
S. Foresti, E. Pedrini, S. De Capitani Di Vimercati, Eserciziario di basi di dati, Pitagora editrice, 2006

Methods of Provision

Conventional

Teaching Methods

The teaching method includes both lessons and laboratories with the use of commercial software tools. The students have also to perform laboratory exercises on the learned concepts and tools.

Assessment Methods

In order to pass the exam, students have either: (i) to develop and discuss a database application during the course semester, and to make a partial written exam, or (ii) to make a complete written exam followed possibly by an oral one.

Assessment:

Final Mark

Programme of Educational Activities

Start date of teaching period:

Monday, February 18, 2019

End date of teaching period:

Friday, June 7, 2019

Other Information

none