Subject number:

Subject name:

Subject type:

Semester

obligatory
or
optional

general
or
professional

2017

Database design

Obligatory

Professional

3.

ECTS

Lectures

Exercises

Standalone work

Total

4

30

15

75

120

Lecturers and associates

dr.sc. Goran Đambić; Ivan Posinjak

Aim of the subject

Students should know and understand the elements of database architecture, understand their function and practical use on the project level and applicative use.

Knowledge and skills

Students will gain knowledge and skills needed for design of database structures and software layer, at server and database level. Students should be able to effectively upgrade existing structures and provide consulting services in the field of database development.

Lectures content

Transactions. Data protection and backups. Databases in multiuser environment. Access control mechanisms. Synchronization. Data conversion. More complex database project. Defining and shaping the layer for functionality implementation. Advanced SQL queries. Finding and solving errors. Object-oriented databases. Types of objects in the database and their application. Distributed databases.

Exercises content

Laboratory:

Database design for the purpose of solving the problem task. Basic queries for retrieving data. Creating a query for changing and controlling data. Solving typical databases problems.

Delivery of

Lectures

Exercises

Teaching material is delivered with the maximum use of visual aids like blackboard and LCD projector.

Laboratory exercises include solving ready-made examples using detailed instructions.

Knowledge assessment

Written tests, laboratory exercises

Final exam

MINIMUM LEARNING OUTCOMES

1. Use SQL to retrieve and modify data.
2. Develop views for formatting user display data in a relational database.
3. Explain the impact of indexes on performances of a relational database.
4. Develop user procedures and functions in a relational database.
5. Use triggers in a relational database.
6. Use complex data types in a relational database.
7. Organize SQL queries in transactions.
8. Describe methods for preventing data loss, authentication and authorization in a relational database.

DESIRED LEARNING OUTCOMES

1. Compare various methods used to retrieve and exchange data with SQL.
2. Evaluate the impact of additional options when creating user views in a relational database.
3. Apply indexes in order to optimize performances of relational databases.
4. Compare implementations of CRUD operations using user procedures and functions in a relational database.
5. Estimate the impact of triggers on data consistency in a relational database.
6. Devise solutions to problems using complex data types in a relational database.
7. Evaluate the impact of isolation levels on multi-user work in a relational database.
8. Apply methods for preventing data loss, authentication and authorization in a relational database.