|
Lecturer(s)
|
-
Kopeček Pavel, Doc. Ing. CSc.
-
Hořejší Petr, Doc. Ing. Ph.D.
|
|
Course content
|
The course is intended to give students a good insight into the following areas: data and information in compurer integrated manufacturing, logical data structure (linear, hierarchical, network, relational), physical data structure (organization of storage disk, data storing, data access, data searching), data organization, data definition languages, data manipulation languages, SQL, multi-user access, architecture of database systems (client - server), examples of database systems (Informix, Oracle, MS SQL serve, dBase), data modelling, E-R-A Diagrams, principle of distributed database systems. During their training in the laboratory students gain experience of a selected database system. 1. Introduction. Basic concepts. Data, information and database systems. 2. Data structures. Objects. Components. 3. Building IS using database technology. Conceptual modeling, functional and data modeling, conceptual and database schema. 4. E-R conceptual model, data normalization. 5. Database models. Relational model - RDBS. Transformation of KS to RDBS. 6. Relational algebra. SQL. 7. Data structures in engineering and SQL (eg BOM). 8. Multidimensional database modeling. Data warehouses. Denormalization of data. OLAP. 9. Knowledge discovery in databases. Datamining in marketing. 10. Data organization. Multi-user data access. Transactions, data locking. 11. Database system architecture (File-Server, Client Server, Distributed Databases, Application Integration) 12. Object-relational, object-oriented and special database systems. Web databases, XML databases. 13. Characteristics and brief characteristics of some commercially used DBMS.
|
|
Learning activities and teaching methods
|
Lecture with practical applications, E-learning, One-to-One tutorial, Laboratory work, Individual study
- Contact hours
- 78 hours per semester
- Preparation for formative assessments (2-20)
- 20 hours per semester
- Preparation for an examination (30-60)
- 30 hours per semester
- Undergraduate study programme term essay (20-40)
- 30 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| understand what algorithmization is |
| have basic knowledge of working with files |
| master any 3rd generation procedural language |
| understand what object-oriented programming technology is |
| Skills |
|---|
| be able to work with MS Office tools (Word, Excel, Access) |
| control PC work |
| be able to write and debug a simple form program application in a higher language |
| be able to create simple SQL queries in Access |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| know what data warehouses, data markets, and what knowledge is |
| know the principle of electronic signature and data encryption |
| know methods of ensuring program reliability and data security |
| know the basic architectures of database management systems |
| Skills |
|---|
| design data models based on data analysis |
| to implement a simple database system |
| create programs in C # environment with SQL server in the background |
| manipulate databases using SQL |
| Competences |
|---|
| N/A |
| N/A |
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| E-learning |
| Individual study |
| One-to-One tutorial |
| Interactive lecture |
| Skills |
|---|
| Laboratory work |
| Individual study |
| Competences |
|---|
| One-to-One tutorial |
| Interactive lecture |
| assessment methods |
|---|
| Knowledge |
|---|
| Combined exam |
| Test |
| Individual presentation at a seminar |
| Skills |
|---|
| Seminar work |
| Competences |
|---|
| Combined exam |
|
Recommended literature
|
-
Holub, Vojtěch; Kopeček, Pavel. Objektové myšlení a objektová analýza. [Plzeň] : SmartMotion, 2013. ISBN 978-80-87539-52-1.
-
Hotek, Mike. Microsoft SQL Server 2008 : krok za krokem. Vyd. 1. Brno : Computer Press, 2009. ISBN 978-80-251-2466-6.
-
Lacko, Luboslav. Databáze: datové sklady, OLAP a dolování dat : s příklady v SQL Serveru a Oracle. Vyd. 1. Brno : Computer Press, 2003. ISBN 80-7226-969-0.
-
Laurenčík, Marek. SQL : podrobný průvodce uživatele. Praha : Grada Publishing, 2018. ISBN 978-80-271-0774-2.
-
Rauch, Jan; Šimůnek, Milan. Dobývání znalostí z databází, LISp-Miner a GUHA. Vydání první. 2014. ISBN 978-80-245-2033-9.
-
Stanek, William R. Microsoft SQL Server 2012 : kapesní rádce administrátora. 1. vyd. Brno : Computer Press, 2013. ISBN 978-80-251-3797-0.
-
Ulrych, Zdeněk. Databázové programování ve VB.NET. [Plzeň] : SmartMotion, 2013. ISBN 978-80-87539-48-4.
|