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
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 aim 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.