DATABASES AND INFORMATION SYSTEMS

DATABASES AND INFORMATION SYSTEMS

_
iten
Code
66784
ACADEMIC YEAR
2018/2019
CREDITS
6 credits during the 3nd year of 8752 Communication science (L-20) SAVONA
SCIENTIFIC DISCIPLINARY SECTOR
ING-INF/05
LANGUAGE
Italian
TEACHING LOCATION
SAVONA (Communication science)
semester
1° Semester
Teaching materials

OVERVIEW

The course is going to present basics on database analysis and design. Also, students will be provided with tools and programs to implement databases. We will discuss the general methodology to create databases on PCs and on the Web, including query language and desgin techniques. At the end of this course, students will be able to design and create databases.

AIMS AND CONTENT

LEARNING OUTCOMES

The course aims at covering basics on database design and providing students with the needed capabilities to create and manage databases for network applications.

AIMS AND LEARNING OUTCOMES

The students will acquire an adequate level of knowledge and capabilities in understanding database analysis and design. 

The students will be able to apply acquired notions and wil have problem solving capabilities in the field of database and database management systems. 

Teaching methods

Active lectures
Laboratory activities

SYLLABUS/CONTENT

Data and information
Information management
Information management systems
Database and database management systems
Entity-relationship analysis 
Logical and conceptual data models
From analysis to design
Database implementation
Relational algebra
SQL language
Database in a client/serve architecture with PHP/MySQL
Hands on laboratory
 

RECOMMENDED READING/BIBLIOGRAPHY

Teacher. 

R.A. Elmasri, S.B. Navathe, Fundamentals of Database Systems Ed. Pearson, 2016. 

TEACHERS AND EXAM BOARD

Ricevimento: On lectures' days, at the Savona Universtity Campus. On appointment, at the Department DIBRIS in Genoa.  

Exam Board

MAURO COCCOLI (President)

GIANNI VIARDO VERCELLI

GIOVANNI ADORNI

LESSONS

Teaching methods

Active lectures
Laboratory activities

ORARI

L'orario di tutti gli insegnamenti è consultabile su EasyAcademy.

Vedi anche:

DATABASES AND INFORMATION SYSTEMS

EXAMS

Exam description

Quizzes and project work.

Assessment methods

The quizzes aim to proving that the students have become proficient in database theory and have acquired analysis skills. 

The project work aims to proving  that the students have acquired database design capabilities and skills in using database management system programs.