EP "Information Systems" 6В06102 Module 16: Databases in Information Systems

Module 16: Databases in Information Systems

Code

M16IS(Ba)

Module Elements

Compulsory Subject
Databases in Information Systems

Semester Number:

5

Person responsible for the module

T.V. Pyatkova

Lecturer:

Databases in Information Systems - T.V. Pyatkova

Language:

Russian, Kazakh

Curriculum relation:

Information Systems (Ba)

Type of teaching / number of hours per week and per semester :

5 semester: hours per week – 10 (lectures -1; labs-3; independent work of students -6);
hours per semester  –150.

Workload:

Teaching Load: 60 hours
Extracurricular Classes: 90 hours
Total: 150 hours

Credit Points:

5 ECTS

Conditions for Examinations:

For admission to the exam, the student must score at least 50 points out of 100 available for the subject

Recommended Conditions:

This module is based on the knowledge gained by students in previous undergraduate subjects: Database Systems, Basics of Information Systems, Profound Language Learning

Expected Learning Outcomes:

Know the theoretical basics of databases, principles of database development and tools to work with them.

Be able to develop databases for solving practical problems; use a systematic approach in the study, design and operation of information systems; develop algorithms for a real systems functioning and implementing them.

Possess the skills in database design and development, building a logical database model and physical database model; work in popular DBMS;

Demonstrate the ability to work with SQL query language and with DBMS of Visual FoxPro and MS Access.

Intendend use/applicability

Modules: Automation and Designing, Applied Aspects of Information Systems

Content:

Databases in Information Systems

Database information systems. History of genesis and development of databases. General information about the data. The concept of building a database. Basics of database theory. Theory of relational databases. The integrity of relational data. Relational algebra. Normal forms of relationships. Normal forms of high orders. Database development. Database design. Database design automation. Transactions and database integrity. Database software.

Examination Form, module mark:

Databases in Information Systems -  written examination
Module mark: the result of the exam Databases in Information Systems

Technical/Multimedia Facilities:

Multimedia system.
IT room.

Study Materials:

1. G. A. Miroshnichenko Relational Databases: Practical Methods of Optimal Solutions. - SPb: BHV, 2015. - 400 p.: with pictures
2. V. Y. Tumanov. Basics of Relational Database Design: Textbook. - M.: Binom, 2008. - 420 p.: with pictures
3. K. Henderson. Professional guide to SQL. SPb: Piter, 2015 – 620 p.
4. A.D. Khomonenko, V. M. Tsygankov, M. G Maltsev. Databases: Textbook for Higher Education Institutions. M.: Binom-Press, 2012 – 736 p.
5. S. N. Semkin, A. N. Semkin. Basics of Information Security of Information Processing Facilities. – Moscow: Akademiya Publishing center, 2013. – 432 p.
6. P. N. Devyanin, O. O. Michalskiy et al. Comprehensive Information Protection in Computer Systems. Yekaterinburg, 2013. – 132c.
7. O.R. Laponina. Theoretical Basics of Computer Security: Textbook for Universities – Moscow: TELEKOM, 2014. – 180 p.
8. Y.V. Shevchuk, N. S. Kolyeva. Programming in C++. - Almaty: Evero, 2014. - 272 p.

Date of last amendment

20.01.2020