Database Systems (in English)

• 39 hrs lectures
• 13 hrs projects

• 51 pts final exam (written part)
• 15 pts mid-term test (written part)
• 34 pts projects

Mastering fundamentals of relational database theory and skill in using database technology at a level required for database design, development of database applications and database administration.
Student is able to develop conceptual models of an application domain for database applications. He/she can develop database applications for relational databases, knows the standard database language for relational databases SQL, and has experience with some integrated development environment for database applications.  and have knowledge of relational database management system fundamentals. He/she receives basic competencies for database administrator's work like user account creation, access rights assignment and performance tuning. Student acquaints with fundamentals of some important functions of advanced database system like transactional processing, concurrency and recovery. Student acquaints with basic English terminology in the subject.
Student will learn how to analyze a given problem in a small team and he/she will learn to design and implement solution of the problem individually. He/she learns to present and defend  both partial and final results of the project.

• Introduction to Software Engineering (IUS)

The sets, relations and mappings. The elementary notions of the graph theory. Basics of hashing and tree-based search. Basic steps of software development. Rudiments of programming and data modeling.

• Ramakrishnan R.: Database Management Systems. Third edition. McGraw-Hill Science/Engineering/Math, 2000, 1104 p.
• Date C.J.: An Introduction to Database Systems. Seventh edition. Addison-Wesley, 2000, 838 p.
• Lemahieu, W., Broucke, S., Baesens, B.: Principles of Database Management. Cambridge University Press. 2018, 780 p.
• Oracle Database Documentation [online]. Redwood Shores, CA, USA: Oracle Corporation, 2021 [cit. 2021-12-23]. Available at: https://docs.oracle.com/en/database/oracle/oracle-database/

• Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p.

1. Course Introduction, Introduction to Databases
2. Database Analysis and Design, Conceptual Modelling and Entity-Relationship Diagram
3. Relational Database Model
4. Transformation of a Conceptual Model to a Relational Database Schema, Normalization
5. SQL: Data Definition
6. Relational Algebra and Calculus
7. SQL: Select Statements
8. SQL: Indices and Views
9. Database Performance, Indexing and Hashing
10. SQL: Database Triggers and Stored Procedures
11. Database Transactions
12. Database Security
13. Architectures of Database Systems

1. An Introduction to Oracle Database at BUT FIT
2. Data Definition in Oracle Database and Introduction to SQL and PL/SQL
3. Advanced Oracle SQL Queries
4. Database Triggers, Stored Procedures, and Indexing in Oracle Database

• Data and use case models - 5 points
• Building of the database in SQL - 9 points 
• Querying in SQL - 10 points
• Advanced database objects and documentation - 10 points
• Midterm written exam - 15 points
• Final written examination - 51 points
• For activities during the semester (except for the final exam), a student must earn at least 24 points for receiving the credit and thus for entering the exam.

Mid-term exam passing, realization and presentation/defence of projects in due dates.