Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024

Database and Knowledge Systems

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
2371090 Z,ZK 5 2P+2C Czech
Garant předmětu:
Vladimír Hlaváč
Lecturer:
Vladimír Hlaváč
Tutor:
Vladimír Hlaváč
Supervisor:
Department of Instrumentation and Control Engineering
Synopsis:

Basic data models. Types and examples of database systems. Management of database systems. Design of database systems - examples. Programming techniques. Language SQL. Fundamentals of programming in database system MS ACCESS.

Introduction in knowledge-based systems. Examples of applying knowledge-based systems in Engineering.

Rule-based and expert systems.

Fuzzy set theory. Computations with fuzzy sets. Fuzzy logic.

Requirements:
Syllabus of lectures:

P1. Introduction. General operations with information provided in database systems. ISO-8859 and UTF8.

P2. E - R diagrams, relational diagrams. Integrity constraints for relationships defined in the DBS.

P3. RDBMS models. Relational database systems. Client/server systems. Codd's rules for relational DBMS. Set and relational operations in a relational database system. Normalization of databases.

P4, P5. Database application programming languages. Structured query language - SQL.

P6. Classic database programs for personal computers. Client/server systems, work with MS Access.

P7. NOSQL databases.

P8. Advanced SQL. Stored functions, triggers.

P9. Simple database applications on the web: Forms, php language.

P10. Simple database applications on the web: A simple application.

P11. Rule-based and expert systems.

P12. Fuzzy sets. Fuzzy set operations. Fuzzyfication and computing with fuzzy variables. Fuzzy logic. Use of fuzzy logic.

P13. Other examples of using databases.

Syllabus of tutorials:

C1. Introduction into course.

C2. E-R diagram of an application

C3. SQL 1.

C4. SQL 2. Assignment of semestral tasks.

C5. SQL 3.

C6. Programming in MS ACCESS.

C7. Programming in data-base using SQL..

C8. Advanced SQL. Webhosting.

C9. Dynamic html page.

C10. Html generated from an SQL server response.

C11. Expert systems.

C12. Fuzzy sets.

C13. Testing of semester tasks. Conclusion of the semester.

Study Objective:

P1. Introduction. General operations with information provided by data-base systems., P2. E - R conceptual model. Limitations for relations defined in DBS., P3.Models of Data-base System Management. Relational data-base systems. Codd, Characteristics (rules) for relational data-base systems. Set and relation operations in, relation data-base system., P4. Architectures of Database System Management in personal computers. Systems, „client/server“., P5. Data-base application program languages. Structured language - SQL., P6. Programming in the system MS Access., P7. Programming in the system of ORACLE-type.., P8. Data-based and Knowledge-Based systems. Operations with knowledge. Decision and, Control paradigms. Operations with uncertainties. Theory of fuzzy sets., P9. Operations with fuzzy sets. Fuzzy numbers and computing with fuzzy numbers., Linguistic variable., P10. Fuzzy logic. Compositional rule and fuzzy inference. Types of fuzzy implications and, their properties., P11. Rule-based systems. (Examples.), P12. Types and kinds of knowledge representation. Expert system - modular structure., Inference engine and its co-operations with knowledge-base. System ETS., P13. Expert systems - examples (FELExpert, TRACER, XCON/XSELL, KEE, NEST,, G2)., P14. Future of database and knowledge systems. Conclusions of lectures.

Study materials:
Note:
Time-table for winter semester 2023/2024:
Time-table is not available yet
Time-table for summer semester 2023/2024:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Wed
roomT4:C1-308
Hlaváč V.
14:15–16:45
(lecture parallel1)
Dejvice
Laboratoř 12110.3 - 308
roomT4:C1-308
Hlaváč V.
16:45–17:30
(parallel nr.1)
Dejvice
Laboratoř 12110.3 - 308
Thu
Fri
The course is a part of the following study plans:
Data valid to 2024-06-22
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet2780206.html