Introduction to Databases

Introduction to Databases

Course title
Introduction to Databases
Course tag
10010
Semester
2
Course status
Mandatory
ECTS
5
Lectures
30
Practice
30
Independent work
90
Total
150
Teachers and associates
dr. sc. Goran Đambić, dipl. ing.
mr. sc. Mario Fabijanić, dipl. ing.
The course aims
Learn to design simple relational databses. Learn to use SQL programming language to retrieve, insert, update and delete data from relational database.
Content
Students will learn to build ER model based on user requirements. Students will learn to transform ER model into relational model and implement it with DDL statements. Students will learn about entity, relational and domain integrities and how to implement them in relational databases. Students will learn to manage data by using insert, update and delete statements. Students will learn basic elements of select statement: execution order, joins, subqueries, grouping and aggregate functions.
Literature:
1. Tina Kaštelan, Ivan Mesic: Uvod u baze podataka, Algebra, Zagreb, 2009.
2. M. Radovan: Baza podataka, Informator, Zagreb, 1993.
Supplementary literature
1. S. Tkalac: Relacijski model podataka, Informator, Zagreb, 1988.
2. D. J. Ullman: Database and Knowledge - base Systems, Computer Science Press, 1999.
3. Clare Churcher, Beginning Database Design: From Novice to Professional, Apress, January 2007.
4. E. F. Codd, The Relational Model for Database Management: Version 2, Addison Wesley Publishing Company, April 1990.

Minimum learning outcomes

  1. Construct relational model based on user requests
  2. Use DDL instructions to implement relational model
  3. Use basic SQL instructions for data manipulation in relational database
  4. Use joins for data retrieval in relational database
  5. Recognize normal form of relational database
  6. Use system and aggregate functions and grouping for data retrieval
  7. Use subqueries

Preferred learning outcomes

  1. Choose most efficient relational model
  2. Differentiate effects of constraints on relational model
  3. Analyze effects of SQL instructions on data consistency
  4. Solve problem by using joins
  5. Suggest changes in relational schema in order to achieve higher normal form
  6. Solve problem by using system and aggregate functions and grouping
  7. Compare data retrieval by using joins and subqueries