Course Details for A.Y. 2018/2019
Name:
Database Systems / Database Systems
Basic information
Credits:
: Master Degree in Applied Data Science 6 CFU (c)
Degree(s):
Master Degree in Applied Data Science 1st anno curriculum Data for Smart City Compulsory
Master Degree in Applied Data Science 1st anno curriculum Data for Life Science Compulsory
Language:
English
Course Objectives
This course aims at providing practical knowledge and competences about database systems. After a brief introduction to database systems and their architectures, the course turns to data modelling through the Entity-Relationship model. Then, a brief overview of the Boolean algebra is provided, in order to introduce students to SQL essential aspects. The latter consist of introducing data types and definition, and training students on basic SQL constraints and queries, as well as insert/delete/update operations. Afterwards, SQL advanced aspects are provided, such as complex queries, triggers, views and modification of a database schema. Finally, the course introduces database programming, illustrates limitations of traditional database systems and provides knowledge about XML and JSON data formats.
Course Content
- Introduction to database systems and architectures.
- Usage of the Entity Relationship model for data modelling.
- Boolean Algebra.
- SQL essential aspects: data types and data definition, basic SQL constraints and querying, insert/delete/update.
- SQL advanced aspects: complex queries, triggers, views, database schema modification.
- Introduction to database programming and advanced aspects: limitations, XML and JSON data formats.
Assessment Methods and Criteria
The exam of the Database Systems course is composed of a mandatory written test and an optional oral test. The oral test can be required: by the student in order to improve grades; by the teacher in case the student's written test has serious omissions or mistakes.
Textbooks
- Elmasri Ramez And Navathe Shamkant, Fundamentals of Database Systems , Pearson. (vol. 7th edition) 2016.
Course page updates
This course page is available (with possible updates) also for the following academic years:
To read the current information on this course, if it is still available, go to the university course catalogue .
Course information last updated on: 10 settembre 2018, 16:38