|
Lecturer(s)
|
-
Špánek Roman, Ing. Ph.D.
-
Lamr Marián, Ing. Ph.D.
-
Vitvarová Jana, Ing. Ph.D.
|
|
Course content
|
Lectures: The first lecture: History of database systems, overview on current as well historic data models. Multilayer database architecture overview. 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 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. The seventh and eighth lecture: SQL data definition language (creation of a new database and database objects, constraints, foreign keys, primary keys) The night and tenth lecture: SQL data manipulation language (basics commands for data manipulation in relational databases, advanced data manipulation techniques and commands) The eleventh lecture: advanced topics in SQL (complicated SQL commands, nested commands, left, right, outer, inner joins) The twelfth lecture: overview on indexes and data structures used in databases for indexing. The main advantages on disadvantages of different index types are discussed, SQL command for indexes creation are also given. The thirteenth and fourteenth lecture: Server site programming, stored procedures, triggers. The fifteenth lecture: Invited lecture by a selected expert in the database system field from a commercial field. Seminars: Overview on file organizations used for data storage. Normalization process is explained on selected examples Conceptual schema modeling (Case studio) - ERD model Functional modeling (Case studio) - DFD model UML basics, UML approaches for modeling databases SQL DDL introduction, creation of several database objects, constraints and experimental verification of expected behavior SQL DML, at the beginning simple commands for data manipulation in relational database, followed by more complicated and sophisticated commands SQL server site programming principles, stored procedure, triggers Note that MS SQL Server 2005 has bee
|
|
Learning activities and teaching methods
|
Monological explanation (lecture, presentation,briefing)
- Class attendance
- 56 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.
Students will acquire further knowledge 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.
|
|
Prerequisites
|
Unspecified
|
|
Assessment methods and criteria
|
Combined examination
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.
-
CONOLLY, T., BEGG, C., HOLOWCZAK, R. Mistrovství - databáze. Profesionální průvodce tvorbou efektivních databází. Computer Press, Brno, 2009. ISBN 978-80-251-2328-7.
-
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.
|