Home/ Majors directory/Software Engineering/Databases
Databases
Major: Software Engineering
Code of subject: 6.121.00.O.029
Credits: 5.00
Department: Software
Lecturer: Assoc.Prof. Pavych Nataliya
Semester: 5 семестр
Mode of study: денна
Завдання: К14. Ability to participate in software design, including modeling (formal description) of its structure, behavior and functioning processes
К15. Ability to develop architectures, modules and components of software systems
К19. Knowledge of data information models, ability to create software for data storage, extraction and processing
Learning outcomes: ПР07. To know and apply in practice the fundamental concepts, paradigms and basic principles of operation of language, instrumental and computational software engineering tools
ПР12. To apply effective approaches to software design in practice
ПР13. To know and apply methods of algorithm development, software design and data and knowledge structures
ПР15. To substantively choose programming languages and development technologies to solve the software development and maintenance problems
ПР17. To be able to apply methods of component-based software development
ПР18. To know and apply information technologies for data processing, storage and transmission
Required prior and related subjects: • previous: Algorithms and Data Structures
• following: Databases (Course work), Data Warehouses, Database Administration, Data Extraction and Processing
Summary of the subject: database architecture, data modeling, relational data model, SQL, query optimization and indexing, transaction management, database accessing
Опис: 1. Database systems: basic concepts, architecture, data models
2. Relational data model
3. SQL fundamentals
4. Logical design of relational databases
5. Indexes and query optimization
6. Business environments of database systems and non-relational databases
Assessment methods and criteria: • Current control: interviews and written reports for 11 laboratory tasks (45%)
• Final exam: written test, interview (50+5=55%)
Критерії оцінювання результатів навчання: • Maximum score for all laboratory tasks is 45, in particular
# 1 (SQL Server installation) - 1 point
#2 (Database disign and creation) - 7 points
#3 (DML language: Insert, Update, Delete) - 3 points
#4 (Single-table queries) - 3 points
#5 (Multi-table queries) - 3 points
# 6 (Algorithmic statements in SQL) - 4 points
#7 (Views) - 4 points
#8 (Transactions) - 7 points
#9 (Optimization) - 7 points
#10 (Stored procedures, functions) - 3 points
#11 (XML, JSON processing) - 3 points
Deadlines are set for each laboratory task.
Points for a laboratory task are assigned according to the calendar schedule and successful assessment. The assessment is considered successful (the maximum possible number of points according to the schedule) if the student shows the task implementation and presents a correctly prepared report, gives correct answers to the questions, and is able to make corrections in the laboratory work according to the teacher's request.
The total score for the current control is assigned before the session begins.
A student is considered non-certified in case of completing less than 50% of the tasks during the current control.
• Maximum score per exam is 55:
- written work/test - 50 points
- interview - 5 points
Порядок та критерії виставляння балів та оцінок: .
Recommended books: 1. Chris J. Date. Introduction to Database Systems, 8th Edition. – Pearson, 2017. – 1040 pages.
2. Itzik Ben-Gan. T-SQL Fundamentals (Developer Reference), 3rd Edition. – Microsoft Press, 2016. – 464 pages.
3. Dusan Petkovic. Microsoft SQL Server 2019: A Beginner's Guide, 7th Edition – McGraw Hill, 2020. – 864 pages.
Уніфікований додаток: .
Академічна доброчесність: .