Charles Explorer logo
🇬🇧

Database and information systems

Class at Faculty of Education |
OB1319301

Syllabus

Principles of Database Systems

History of data processing, manual approach, mass data processing, database

Database technology, database management systems

Characteristics of data in databases

Architectures DB systems, data protection, user access

Database models

Conceptual modeling,

Entity-relational conceptual model

Relationships between entities 1:1, 1: N, M: N

Database design

ER diagrams, entities, relationships, identifying of keys

Data flow diagrams (DFD)

Data types and attributes properties

Database Normalization

Normal forms database schemas and relationships

Criteria for the design of a relational database schema

Decomposition and Synthesis

Discussion on the standardization and its importance

SQL for data manipulation

Commands for creating databases and entities, and their elimination

Change the name and entity type attributes

Commands for record a change of values and eliminate

Queries for the structure and opening a recordset

Advanced SQL queries

NoSQL, and Object-Oriented Systems

The specifics of each database systems, the possibility to use

NoSQL systems principles

Relational, object-relational and object-oriented systems comparsion 

Managing database server

Important parameters of the server and their configuration

User management database, configuration of access rights

System functions for server management

Annotation

The focus of this subject is to introduce students to the problems of database systems, their theories and principles of database design. The course has several views on database technology, the main emphasis is on data modeling and data analysis.

The course deals with various problems with access to data architecture, relational data model, ER model, normalization, data warehousing, distributed databases and knowledge bases. In the practical part, students practice their theoretical knowledge of designing and implementing database transformations of data models into relational database schema based on SQL standards.

The course is also familiar with the basic operations manager database servers and their users access and other services, security and automatic data backup ..