Course: Databases Creation

« Back
Course title Databases Creation
Course code MTI/DAT
Organizational form of instruction Lecture + Lesson
Level of course Master
Year of study not specified
Semester Summer
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory-optional
Form of instruction Face-to-face
Work placements Course does not contain work placement
Recommended optional programme components None
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.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Textile Engineering Study plan (Version): Quality Control (2012) Category: Special and interdisciplinary fields - Recommended year of study:-, Recommended semester: Summer
Faculty: Faculty of Textile Engineering Study plan (Version): Quality Control (12) Category: Special and interdisciplinary fields - Recommended year of study:-, Recommended semester: Summer