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) - 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
CELLULAR NETWORKS AND 5G
Attendance grouping
6 credits - Raggruppamento di frequenza
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
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
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:

2018/2019

Academic Year of provision:

2020/2021

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 principles 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 languages.

Introduction to the database normalization theory.

Introduction to database transactions.

Use of transactions in the 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 languages.

Introduction to database normalization theory.

Introduction to the theory of transactions.

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 can use either,

Standard modality: a written exam, formed by exercises (weight 2/3) and theory questions (weight 1/3), possibly followed by an oral interview (as decided by the professor).

Project modality: available to students that end the exam within the S2 session. In this case, it possible to replace the written part about exercises with a project (weight 2/3) aimed at design a database and implement an application based on this database. So the written exam will include the theory questions only (weight 1/3)

Assessment:

Final Mark

Programme of Educational Activities

Start date of teaching period:

Monday, February 22, 2021

End date of teaching period:

Friday, June 11, 2021

Other Information

none