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.

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.

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.

Database, SQL, DBMS, MS Access, Fuzzy sets, Fuzzy logic, Rule-based systems, Expert systems, Data mining, Hasse diagrem, Extraction of rules.