Description:

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.

Contents:

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.

Seminar contents:

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.

Keywords:

Databases, knowledge systems, rule based systems, expert systems, fuzzy logic, SQL

Abbreviations used:

Semester:

• W ... winter semester (usually October - February)
• S ... spring semester (usually March - June)
• W,S ... both semesters

Mode of completion of the course:

• A ... Assessment (no grade is given to this course but credits are awarded. You will receive only P (Passed) of F (Failed) and number of credits)
• GA ... Graded Assessment (a grade is awarded for this course)
• EX ... Examination (a grade is awarded for this course)
• A, EX ... Examination (the award of Assessment is a precondition for taking the Examination in the given subject, a grade is awarded for this course)

Weekly load (hours per week):

• P ... lecture
• C ... seminar
• L ... laboratory
• R ... proseminar
• S ... seminar