DATABASE MANAGEMENT
Course Overview 
Level of study	Bachelor Degree/ Master Degree 	
Workload	ECTS: 		2
Total Hours:	72
Contact Hours:	
•	Lectures:	24
•	Labs:		32
•	Seminars:	16	
Course Code		
Semester	Summer	
Prerequisites	Informatics, Programming, 	
Course Objectives	The main goal - to prepare students for research and design activity.	
Learning Outcomes	By the end of the course the students will know:
•	principles database construction. 
•	the main data models.
•	the relational data management languages.
•	SQL  relational data management language 
The students will be able to:
•	apply methods of database design for specific implementation areas;
•	develop object-oriented model of subject area.
The students will have the experience in:
•	application of scientific and mathematical knowledge in solution of scientific and engineering problems in the field of informatics and computer science;
•	effective work both as  an individual and  a member of an interdisciplinary and international team in solution of innovative engineering problems;
- self-study activities, continuous self-improvement in engineering, teaching activities.	
Syllabus	Topic 1. Evolution of database concept (lectures 2)
Topic 2. Database Analysis and design(lectures 4)
Topic 3. SQL and Query Optimization (lectures 6).
Topic 4. Stored Procedures, Triggers  and  Indexes (lectures 4)
Topic 5. Transaction management and Concurrency control (lectures 4)
Topic 6. Advanced Database Management Topics (lectures 6)	
Labs	Lab 1.  Modeling Data in the Organization (labs 4)
Lab 2.  Logical and Physical Database Design and Performance (labs 4)
Lab 3.  Data Modeling Tools and Notation (labs 4).
Lab 4.  SQL an Query Optimization (labs 6)
Lab 5.  Stored Procedures, Triggers  and  Indexes (labs 4)
Lab 6.  Data and Database Administration (labs 6)
Lab 7.  Object-Oriented Data Modeling (labs 4)	
Projects	There will be also a semester-long project in this course	
Assessment	30% - in-class tests.
30% - semester-long project.
40% - oral exam	
Resources	1.	Thuraisingham, Bhavani. Database and Applications Security. Integrating Information Security and Data Management / B. Thuraisingham. — New York: Auerbach Publications, 2005. — 619 p.: ил. — Библиография в конце глав. — Index: p. 599-619. — ISBN 0-8493-2224-3.
2.	Date. 1999. Introduction to database system: [translation from English.] /the 6th edition. Kiev; М.; St. Petersburg: «Williams» publishing, page 848.
3.	T. Konnolly. 2000. Databases: design, implementation and support. Theory and practice: [translation from English.] / Т. Konnolly, К. Begg, А. Strachan. The 2nd edition. М.: «Williams» publishing, page 1120.
4.	D. Khomonenko. 2002. Databases: textbook for high schools /А. D. Khomonenko, V. M. Tsygankov, M. G. Maltsev; ed. by А.D. Khomonenko. The 2nd edition – St. Petersburg: KORONA print, page 672.
5.	Chudinov. 2000 Databases. Workbook. – Тomsk, 
6.	Educational materials of Dept. of Optimization system management.	
Instructors	Mokina Elena  Evgenyevna 
Senior Teacher
Optimization System Control Department
Institute of Cybernetics
http://portal.tpu.ru/SHARED/a/ALISANDRA/eng