Lecturer(s)
|
|
Course content
|
Lectures 1. The first lecture: History of database systems, overview on current as well historic data models. Multilayer database architecture overview. 2. The second and third lecture: Relation databases principles, basic data modeling. Conceptual schema modeling (ERD model), functional modeling approaches (DFD), normalization and relations design principles 3. The fourth and fifth lecture: Unified Modeling Language (UML) basics, more detail overview on database modeling in UML (class, use case, deployment diagrams) plus behavioral diagrams. 4. The seventh and eighth lecture: SQL data definition language (creation of a new database and database objects, constraints, foreign keys, primary keys) 5. The night and tenth lecture: SQL data manipulation language (basics commands for data manipulation in relational databases, advanced data manipulation techniques and commands) 6. The eleventh lecture: advanced topics in SQL (complicated SQL commands, nested commands, left, right, outer, inner joins) 7.-8. The twelfth lecture: overview on indexes and data structures used in databases for indexing. 9.-10. The main advantages on disadvantages of different index types are discussed, SQL command for indexes creation are also given. 11.-12. The thirteenth and fourteenth lecture: Server site programming, stored procedures, triggers. 13.-14. The fifteenth lecture: Invited lecture by a selected expert in the database system field from a commercial field. Practice 1. Overview on file organizations used for data storage. 2. Normalization process is explained on selected examples 3.-4. Conceptual schema modeling (Case studio) - ERD model 5.-6. Functional modeling (Case studio) - DFD model 7.-8. UML basics, UML approaches for modeling databases 9. SQL DDL introduction, creation of several database objects, constraints and experimental verification of expected behavior 10.-11. SQL DML, at the beginning simple commands for data manipulation in relational database, followed by more complicated and sophisticated commands 12.-13. SQL server site programming principles, stored procedure, triggers 14. Note that MS SQL Server 2005 has bee
|
Learning activities and teaching methods
|
Monological explanation (lecture, presentation,briefing), Working activities (workshops)
- Class attendance
- 42 hours per semester
|
Learning outcomes
|
The course aims the current trends in database systems. Students follow during the courses standard principles in creation of database information systems with a special emphasis on pragmatic approaches in realization of the server as well as client site of the application. Particularly, students are given information about functional and data modeling approaches, followed by SQL, security aspects, transaction overview and server site programming.
The course overviews data structures used for algorithm creation and further computer data processing in the case of more complicated (mathematical) problems. Students are given information about commonly used as well as special database systems used for building information systems for special cases (e.g., GIS). Data base modeling approaches are also mentioned and students are introduced to data as well as functional database modeling approaches.
|
Prerequisites
|
Unspecified
|
Assessment methods and criteria
|
Combined examination, Oral exam, Written exam
Active participation on seminars. Oral presentation of the student's project at the end of semester.
|
Recommended literature
|
-
BRUCKNER, T., VOŘÍŠEK, J., BUCHALCEVOVÁ, A- a. kol. Tvorba informačních systémů. Principy, metodiky, architektury. Grada Publishing, 2012. ISBN 978-80-247-4153-6.
-
POKORNÝ, J., VALENTA, M. Databázové systémy. ČVUT Praha, 2013. ISBN 978-80-01-05212-9.
-
Šešera L. a kol. Datové modelování v příkladech. Grada.
-
Šimůnek P. SQL - kompletní kapesní průvodce. Grada, 1999.
|