|
Lecturer(s)
|
-
Podaras Athanasios, Ing. Ph.D.
-
Lamr Marián, Ing. Ph.D.
-
Nowak Stanislav, Ing. Bc.
|
|
Course content
|
Lectures : 1. Database systems as part of IS / ICT. History and development of database systems. Database, DBMS, data catalog, data models. 2. Conceptual modeling in database design. ERA model. 3. Transformation of the conceptual scheme into a relational database schema. 4. Relational Data Model - Database Session, Integrity Limitations. 5. Functional dependencies, multi-dependencies. 6. Normalization. Normal forms. 7. Relational algebra 8. SQL Query Languages. SQL-development, standards. Data definition in SQL. * 9. SQL: data manipulation, external and internal connections, natural connections, structured queries. * 10. SQL: Views, Triggers, Procedures, Database Access Control. * 11. Transaction processing. Computational models. * 12. Objectivity in databases, object-relational data model. 13. Data warehouses, multidimensional warehouse models. 14. Trends in Database Systems Development Seminars: 1. Organizational instructions, assignment of the semester task. 2. Getting to know the environment and development tools. 3. Conceptual data modeling. 4. Transformation of conceptual model into relational. 5. Design a client database client interface. 6. Programming the client side of the database application. 7. Examples of normalization and normal forms. 8. Relative algebra as a query language. 9. SQL Basics. 10. Examples of SQL DML practice. 11. Views and Stored Procedures. 12. Triggers. 13. Implementation of a specific database entry solution. 14. Presentation of semestral projects. Seminars take place in a computer classroom with the tools for ER modeling and development environment MS SQL Server. The first part is devoted to database design and client applications. In the second part of the semester, SQL statements are trained.
|
|
Learning activities and teaching methods
|
|
unspecified
|
|
Learning outcomes
|
Learning outcomes of the course unit are to acquaint students with principles of relational database technologies. The first part of the semester is devoted to requirements analyzes, conceptual modeling, design and implementation of the database schema. The second part of the semester discusses the basics of SQL, security, optimization and new trends in database systems.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
unspecified
Credit requirements: Active participation in seminars, thesis, preparation of a semestral project and its presentation. Exam: Written and oral part.
|
|
Recommended literature
|
-
CONNOLLY, T. M. a C. E. BEGG. Database solutions: A Step-by-Step Quide to Building Databases.. New York: Pearson/Addison Wesley, 2014. ISBN 978-0321173508.
-
CORONEL, C. a S. MORRIS. Database Systems: Design, Implementation, and Management.. Boston: CENGAGE Learning, 2016. ISBN 978-1-305-62748-2.
-
GÁLA, L., J. POUR a Z. ŠEDIVÁ. Podniková informatika: počítačové aplikace v podnikové a mezipodnikové praxi. 3. vyd.. Praha: Grada Publishing, 2015. ISBN 978-80-247-5457-4.
-
LACKO, Ľ. Mistrovství v SQL Server 2012: [kompletní průvodce databázového experta].. Brno: Computer Press, 2013. ISBN 978-80-25-13773-4.
-
POKORNÝ, J. a M. VALENTA. Databázové systémy.. Praha: ČVUT Praha, 2013. ISBN 978-80-01-05212-9.
-
POUR, J., J. MARYŠKA a J. NOVOTNÝ. Business Intelligence v podnikové praxi.. Professional Publishing, 2012. ISBN 978-80-7431-065-2.
-
STEPHENS, R. K., R. R. PLEW a A. JONES. Naučte se SQL za 28 dní.. Brno: Computer Press, 2012. ISBN 978-80-25-1270-01.
|