The course participant must be able to operate all parts of SQL. Efficient use of procedures and functions as the basic application part in SQL. Must be familiar with locking and transactions. Already halfway through the course, the student will be able to pass a query to the application for processing.

Upon completion of the course, the student will have the ability to create and control a database.

1. Relational data model. 2. Keys. Normalizations. 3. Relational algebra. 4. DBMS, DDL, DML, SQL. 5. Search and single-relational query. 6. Join queries. Importance of keys. 7. Updating tables. 8. Application SQL. 9. Triggers, views, application in SQL. 10. Case study.

1. CREATE. 2. Table linking. Integrity. 3. Normalization and its impact on tables. 4. ALTER. UPDATE. 5. SELECT. 6. Case study 1. 7. PROCEDURES. FUNCTIONS 8. Case study 2. 9. Insert, update, view, delete. Locking. 10. Case study 3.

Databases Design

SQL server mysql

Total assigned hours: 80

New material: 40
Elaboration and examples (recapitulation): 0

Auditory exercises: 20
Laboratory exercises: 10
Calculation tasks: 0
Seminar paper: 0
Project: 0
Consultations: 0
Discussion/workshop: 5
Research study work: 0

Review and grading of calculation tasks: 0
Review and grading of lab reports: 0
Review and grading of seminar papers: 0
Review and grading of the project: 0
Test: 0
Test: 0
Final exam: 5

Activity during lectures: 0
Test/test: 70
Laboratory practice: 0
Calculation tasks: 0
Seminar paper: 0
Project: 0
Final exam: 30
Requirement for taking the exam (required number of points): 70

Lex de Haan, Toon Koppelaars; Applied Mathematics for Database; Apress; Gordana Pavlović-Lažetić; Introduction to relational databases; poincare.matf.bg.ac.rs; Hugh Darwen; An Introduction to Relational Database Theory; bookboon.com; Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom; Database Systems: The Complite Book; Prentice Hall; Suad Alagić; Relation databases; Svijetlost