| Academic year 2026/2027 |
| Supervisor: | Ing. Jiří Kovář, Ph.D. | |||
| Supervising institute: | ÚAI | |||
| Teaching language: | Czech | |||
| Course type: | departmental course | |||
| Aims of the course unit: | ||||
|   | ||||
| Learning outcomes and competences: | ||||
|   | ||||
| Prerequisites: | ||||
|   | ||||
| Course contents: | ||||
The course is an introduction to database systems. Data processing, redundancy and inconsistency, integrity, confidentiality, multi-user access to data. Index-sequential data organization. Integrity constraints for relationships.
Theoretical aspects of information systems design. Functional dependencies, normal forms of relations, decomposition theorem. SQL query language. |
||||
| Teaching methods and criteria: | ||||
|   | ||||
| Assesment methods and criteria linked to learning outcomes: | ||||
|   | ||||
| Controlled participation in lessons: | ||||
|   | ||||
| Type of course unit: | ||||
| Lecture | 13 × 2 hrs. | optionally | ||
| Computer-assisted exercise | 13 × 2 hrs. | compulsory | ||
| Course curriculum: | ||||
| Lecture | 1. Definition of the subject, study literature. Database paradigm. Data classification (physical classification, index files). Disadvantages of classical file processing. Database systems, DDL and DML languages. Database system architecture. Physical and logical independence. Data models - relation to JSON and XML. |
|||
| Computer-assisted exercise | 1. The most commonly used approaches to working with databases and their software implementation, including the use of Entity Framework. |
|||
| Literature - fundamental: | ||||
| 1. Connoly, T.M. and Begg, C.E.: Database Systems : A Practical Approach to Design, Implementation and Management. Pearson Education, 2004 (4th edition). | ||||
| 2. Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition). | ||||
| 3. Fortier, P.J.: Database Systems Handbook. McGraw-Hill, 1997. | ||||
| 4. Lacko, L.: SQL. Hotová řešení pro SQL Server, Oracle a MySQL. Computer Press, Brno, 2003. | ||||
| 7. Pratt, J.P.: A Guide to SQL. Course Technology, 2003 (6th edition). | ||||
| 8. Ullman, L.: PHP and MySQL for Dynamic Web Sites. Pearson Education, 2003 (český překlad: PHP a MySQL: Názorný průvodce tvorbou dynamických www stránek. Computer Press, Brno, 2004). | ||||
| 10. Williams, H.E. and Lane, D.: Web Database Applications with PHP and MySQL. O’Reilly, 2002 (český překlad: Programujeme webové aplikace pomocí PHP a MySQL. Computer Press, Praha, 2002). | ||||
| 11. Holubová, I, Kosek, J., Minařík, K., Novák, D.: Big Data a NoSQL databáze. Grada, Praha, 2015. | ||||
| 12. Velte, T. A., Velte, T. J., Elsenpeter, R: Cloud Computing. A Practical Approach. McGraw Hill, New York, 2010. | ||||
| 13. Stanoevska-Slabeva, K., Wozniak, T., Ristol, S. (eds.): Grid and Cloud Computing. A Business Perspective on Technology and Applications. Springer-Verlag, Berlin, 2010. | ||||
| 14. Redmond, E., Wilson, J. R.: Seven Databases in Seven Weeks. A Guide to Modern Databases and the NoSQL. Movement-Pragmatic Bookshelf, 2012. | ||||
| Literature - recommended: | ||||
| 1. Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition). | ||||
| 2. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Addison Wesley, 4th edition, 2003. | ||||
| The study programmes with the given course: | |||||||||
| Programme | Study form | Branch | Spec. | Final classification | Course-unit credits | Obligation | Level | Year | Semester |
| B-MAI-P | full-time study | --- no specialisation | -- | Cr,Ex | 6 | Compulsory-optional | 1 | 3 | W |
| B-STR-P | full-time study | AIŘ Applied Computer Science and Control | -- | Cr,Ex | 6 | Compulsory | 1 | 3 | W |
| C-AKR-P | full-time study | CZS | -- | Cr,Ex | 6 | Elective | 1 | 1 | W |
Faculty of Mechanical Engineering
Brno University of Technology
Technická 2896/2
616 69 Brno
Czech Republic
+420 541 14n nnn
+420 726 81n nnn – GSM Telef. O2
+420 604 07n nnn – GSM T-mobile
Operator: nnnn = 1111