Database and Knowledge Base Organization (курсова робота)

Major: System Analysis
Code of subject: 6.124.00.O.026
Credits: 2.00
Department: Information Systems and Networks
Lecturer: Ph.D., Associate Professor Veres Oleh Mykhailovych
Semester: 4 семестр
Mode of study: денна
Learning outcomes: • know the architecture of modern computer systems and computer networks.; • know and be able to apply database and knowledge management systems and information systems in practice; • design, implement, test, implement, support, operate software tools for working with data and knowledge in computer systems and networks.
Required prior and related subjects: • Discrete Mathematics; • Algorithmization and Programming; • System Аnalysis Мethodologies; • Information Systems Design.
Summary of the subject: Suggested topics: 1) Designing the database of the information system of the police department. 2) Designing the database of the information system of the police reference point. 3) Designing the database of the airline's information system. 4) Designing the database of the information system of the bus station. 5) Designing the database of the information system of the motor vehicle enterprise. 6) Designing the database of the information system of the car showroom (car sales). 7) Designing the database of the information system for the analysis of students' success. 8) Designing the database of the information system of accounting for the products of the manufacturer's company. 9) Designing the database of the information system of sea cargo transportation. 10) Designing the database of the information system for granting loans. 11) Designing the airport information system database. 12) Designing the library information system database (book accounting). 13) Designing the database of the library's information system (registration of readers). 14) Designing the library's information system database (staff). 15) Designing the database of the freight transportation information system. 16) Designing the database of the vet clinic information system. 17) Designing the database of the vet shelter information system. 18) Designing the database of the information system of the regional police department. 19) Designing the database of the information system for accounting of personal cars in the traffic police. 20) Designing the database of the HR department's information system.
Assessment methods and criteria: • Final control (100%, test): defense of the coursework.
Recommended books: 1) Берко А. Ю. Системи баз даних та знань. Книга 1. Організація баз даних та знань: підручник [для студ. вищ. навч. закл.] / Берко А. Ю., Верес О. М., Пасічник В.В. – 2-е вид. – Львів : „Магнолія 2006”, 2015. – 440 с. — (Серія «Комп’ютинґ»). 2) Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань: підручник [для студ. вищ. навч. закл.] 2-е вид.. – Львів:"Магнолія-2006", 2015.- 470 с.. 3) Пасічник В. В. Організація баз даних та знань. / В. В. Пасичник, В. А. Резніченко. – К.: Видавнича група BHV, 2006. – 384 с.К.Дейт. Введение в системы баз данных. 7-е изд.: Пер. с англ. –М.: Издательский дом „Вильямс”, 2001. –1072с.: ил.-Парал. тит. англ. 4) Date, Christopher John. An introduction to database systems. Pearson; 8th edition (July 22, 2003). – 1040 p.

Database and Knowledge Base Organization

Major: System Analysis
Code of subject: 6.124.00.O.025
Credits: 7.00
Department: Information Systems and Networks
Lecturer: Ph.D., Associate Professor Veres Oleh Mykhailovych
Semester: 4 семестр
Mode of study: денна
Learning outcomes: • know the architecture of modern computer systems and computer networks.; • know and be able to apply database and knowledge management systems and information systems in practice; • design, implement, test, implement, support, operate software tools for working with data and knowledge in computer systems and networks.
Required prior and related subjects: • Discrete Mathematics; • Algorithmization and Programming; • System Аnalysis Мethodologies; • Information Systems Design.
Summary of the subject: Information systems and information technology. Data modeling: System databases; data model; relational model; theory of normalization of relational data model. Query language: language SQL; language QBE. Design and protection of databases: database design; the integrity of the data; protection of databases; tranzakcijna processing databases. Classification databases: distributed database; parallel database; deductive databases; object-oriented database; database on the Internet; the knowledge base. The history of the development of database management systems. Means of description and modification of the database. Data search and selection tools. Data manipulation tools. Process control and management tools in the SQL language. The latest capabilities of modern DBMS.
Assessment methods and criteria: • Current control (40%): written reports on laboratory work, essay, oral examination; • Final control (60% exam): in written, verbally.
Recommended books: 1) Берко А. Ю. Системи баз даних та знань. Книга 1. Організація баз даних та знань: підручник [для студ. вищ. навч. закл.] / Берко А. Ю., Верес О. М., Пасічник В.В. – 2-е вид. – Львів : „Магнолія 2006”, 2015. – 440 с. — (Серія «Комп’ютинґ»). 2) Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань: підручник [для студ. вищ. навч. закл.] 2-е вид.. – Львів:"Магнолія-2006", 2015.- 470 с.. 3) Пасічник В. В. Організація баз даних та знань. / В. В. Пасичник, В. А. Резніченко. – К.: Видавнича група BHV, 2006. – 384 с.К.Дейт. Введение в системы баз данных. 7-е изд.: Пер. с англ. –М.: Издательский дом „Вильямс”, 2001. –1072с.: ил.-Парал. тит. англ. 4) Date, Christopher John. An introduction to database systems. Pearson; 8th edition (July 22, 2003). – 1040 p.