Database management system
Description: Data models: hierarchical, network and relational. Database design; basic design principles. Description of databases. The logical and physical structure of databases. Database structures design tools; Classification and comparative characteristics, basic concepts of the DBMS. Principles and methods of data manipulation.
Amount of credits: 5
Пререквизиты:
- Information and Communication Technologies (in english)
Course Workload:
| Types of classes | hours |
|---|---|
| Lectures | 15 |
| Practical works | |
| Laboratory works | 30 |
| SAWTG (Student Autonomous Work under Teacher Guidance) | 30 |
| SAW (Student autonomous work) | 75 |
| Form of final control | Exam |
| Final assessment method |
Component: University component
Cycle: Profiling disciplines
Goal
- To acquire theoretical knowledge and practical skills in database design and modeling, as well as master the basic operators of the T-SQL language.
Objective
- study the main stages of data base design;
- acquire skills in conceptual database design;
- acquire skills in logical design and database modeling;
- implementation of machine design of a database in the MS SQL SERVER DBMS;
- implementation of mechanisms to ensure the integrity of databases;
- using T-SQL statements to manipulate data;
- creation of simple and nested SQL queries in the subject area;
Learning outcome: knowledge and understanding
- Knowledge of basic terminology. Ability to describe domain entities (OBDs), their attributes and relationships between them
- Knowledge of the syntax of the SQL language. Ability to create database objects (tables, views), write queries to data
- Knowledge of the main characteristics and functionality of the DBMS
Learning outcome: applying knowledge and understanding
- Ability to analyze the subject area, draw up an infological model and datalogical (conceptual) database schema, determine integrity constraints and data access rights
- Ability to create software elements of the database (triggers, functions, procedures)
- Ability to use indexes and other ways of organizing data to speed up data access.
- Ability to choose data types for fields, set integrity constraints. Knowledge of the transaction mechanism and the ability to use it
Learning outcome: formation of judgments
- about the variety of modern DBMS, their areas of application and features;
- about the main unresolved to date problems arising in the creation and use of databases.
- about the trends and prospects of development of modern DBMS;
Learning outcome: communicative abilities
- development and improvement of students' communication skills;
- development of skills for participation in a constructive dialogue about trends and prospects for the development of modern DBMS and the variety of modern DBMS, their areas of application and features
Learning outcome: learning skills or learning abilities
- the formation of skills in the field of databases for the implementation of engineering and research work;
- development of database design skills for specific business processes;
- the ability to promote, within academic and professional contexts, technological, social or cultural development for the building of a knowledge-based society
Teaching methods
- lectures and online lectures, laboratory exercises using slides and other multimedia tools.
Assessment of the student's knowledge
Teacher oversees various tasks related to ongoing assessment and determines students' current performance twice during each academic period. Ratings 1 and 2 are formulated based on the outcomes of this ongoing assessment. The student's learning achievements are assessed using a 100-point scale, and the final grades P1 and P2 are calculated as the average of their ongoing performance evaluations. The teacher evaluates the student's work throughout the academic period in alignment with the assignment submission schedule for the discipline. The assessment system may incorporate a mix of written and oral, group and individual formats.
| Period | Type of task | Total |
|---|---|---|
| 1 rating | Lab 1 | 0-100 |
| Lab 2 | ||
| Lab 3 | ||
| Midterm control 1 | ||
| 2 rating | Lab 4 | 0-100 |
| Lab 5 | ||
| Lab 6 | ||
| Midterm control 2 | ||
| Total control | Exam | 0-100 |
The evaluating policy of learning outcomes by work type
| Type of task | 90-100 | 70-89 | 50-69 | 0-49 |
|---|---|---|---|---|
| Excellent | Good | Satisfactory | Unsatisfactory |
Evaluation form
The student's final grade in the course is calculated on a 100 point grading scale, it includes:
- 40% of the examination result;
- 60% of current control result.
The final grade is calculated by the formula:
| FG = 0,6 | MT1+MT2 | +0,4E |
| 2 |
Where Midterm 1, Midterm 2are digital equivalents of the grades of Midterm 1 and 2;
E is a digital equivalent of the exam grade.
Final alphabetical grade and its equivalent in points:
The letter grading system for students' academic achievements, corresponding to the numerical equivalent on a four-point scale:
| Alphabetical grade | Numerical value | Points (%) | Traditional grade |
|---|---|---|---|
| A | 4.0 | 95-100 | Excellent |
| A- | 3.67 | 90-94 | |
| B+ | 3.33 | 85-89 | Good |
| B | 3.0 | 80-84 | |
| B- | 2.67 | 75-79 | |
| C+ | 2.33 | 70-74 | |
| C | 2.0 | 65-69 | Satisfactory |
| C- | 1.67 | 60-64 | |
| D+ | 1.33 | 55-59 | |
| D | 1.0 | 50-54 | |
| FX | 0.5 | 25-49 | Unsatisfactory |
| F | 0 | 0-24 |
Topics of lectures
- Basic concepts of databases
- Stages of database design
- Conceptual (infological) stage of database design
- The logical stage of database design
- Structure, operations, constraints of data models
- Types of database models
- Restoration of the relation of the relational database model
- The machine stage of MS SQL Server database database design
- Ensuring database integrity in MS SQL Server
- Basics of SQL structured query language
- Types of SQL commands
- Organization of data output with the help of select command tools
- Select the installed commands
- Creating procedures stored on MS SQL Server
- Creating custom functions in MS SQL Server
Key reading
- Стружкин Н. П., Годин В. В. Базы данных: проектирование: учебник для вузов. Москва: Юрайт, 2021
- Нестеров С. А. Базы данных: учебник и практикум для вузов. Москва: Юрайт, 2021
- Советов Б. Я., Цехановский В. В., Чертовской В. Д. - БАЗЫ ДАННЫХ 3-е изд., пер. и доп. Учебник для прикладного бакалавриата - М.:Издательство Юрайт - 2019 - 420с. - ISBN: 978-5-534-07217-4 - Текст электронный // ЭБС ЮРАЙТ - URL: https://urait.ru/book/bazy-dannyh-431947
- Карпова Т.С. - Базы данных: модели, разработка, реализация - Национальный Открытый Университет "ИНТУИТ" - 2016 - 403с. - ISBN: - Текст электронный // ЭБС ЛАНЬ - URL: https://e.lanbook.com/book/100575
- Федорова Г.Н.Основы проектирования баз данных.- М.:Академия,2020
- Илюшечкин В.М. Основы использования и проектирования баз данных: учебник.-М.: Юрайт,2017
Further reading
- Паутов, А. Документация на MySQL [Электрон. ресурс] – Режим доступа: http://www.proklondike.com/books/dbmysql/dbmysql_pautov_mysql_docs.html – Дата доступа: 01.09.2021
- Кириллов В.В., Громов Г.Ю. Структурированный язык запросов (SQL) [Электрон. ресурс]: Учебное пособие. – Режим доступа: http://www.citforum.ru/database/sql_kg/index.shtml – Дата доступа: 01.09.2021.
- Швецов В.И. - Базы данных - Национальный Открытый Университет "ИНТУИТ" - 2016 - 218с. - ISBN: - Текст электронный // ЭБС ЛАНЬ - URL: https://e.lanbook.com/book/100576
