Database Systems

ID: 7093
Course type: scientific and vocational
Course coordinator: Radojević Lj. Slobodan
Lecturers: Radojević Lj. Slobodan
Contact: Radojević Lj. Slobodan
Level of studies: B.Sc. (undergraduate) Academic Studies – Information Technologies in Mechanical Engineering
ECTS: 5
Final exam type: written+oral
Department: Department of Information Technologies in Mechanical Engineering

Lectures

Goal

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.

Outcome

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

Theoretical teaching

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.

Practical teaching

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.

Attendance requirement

Databases Design

Resources

SQL server mysql

Assigned hours

Total assigned hours: 80

Active teaching (theoretical)

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

Active teaching (practical)

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

Knowledge test

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

Knowledge test (100 points total)

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

Literature

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