- Code
- CMP 402
- Name
- Database Management Systems
- Semester
- 2
- Lecture hours
- 3.00
- Seminar hours
- 1.00
- Laborator hours
- 0.00
- Credits
- 3.50
- ECTS
- 6.00
- Description
-
The course "Database Management Systems" focuses on the theoretical and practical principles of designing, developing, and managing database systems. It covers data models, SQL, normalization, indexing, transactions, concurrency control, and recovery management.
- Objectives
-
To understand basic database concepts and DBMS architecture. To effectively use SQL for data manipulation and querying. To apply normalization for efficient schema design. To understand transaction mechanisms and concurrency control. To analyze performance and indexing structures.
- Java
- Tema
- 1
- - Extended entity relationship model (EER model) - Entity clusters - Using them to represent multiple entities and relationships
- 2
- - Convenient primary key features - How to select these keys - Use of flexible solutions for special cases of data modeling
- 3
- - Relational operators UNION, UNION ALL, INTERSECT and MINUS - How to use JOIN advanced SQL syntax - Different types of subquery and related query
- 4
- - SQL functions - Using them to manipulate dates, texts and other data - Create and use updatable views
- 5
- - Triggers and stored procedures - Their creation and use - Creating embedded SQL
- 6
- - Exercises in SQL - Practical examples
- 7
- - Project I
- 8
- - Adapting the design of the database to the information system where it belongs - Systems Development Life Cycle (SDLC) - Development of information systems within the framework of SDLC
- 9
- - Evaluate and review databases in the Database Life Cycle (DBLC) framework - How the evaluation and review is performed within the SDLC and DBLC frameworks - Database design strategies
- 10
- - Basic concepts for regulating database performance (tuning) - How DBMS processes SQL queries - The importance of indexes in processing SQL code
- 11
- - Types of decisions a query optimizer should make - Common Practices for Writing Efficient SQL Code - How to formulate queries and adjust the DBMS for optimal performance
- 12
- - Various technologies to connect to the database - Using intermediaries to integrate databases with the Internet - Plug-ins and extensions for browsers
- 13
- - Services provided by Web application servers - What is XML and its importance in the development of Web databases - Cloud services features
- 14
- - SQL data services and the impact on reducing costs for data management - Exercises
- 15
- - Project II
- 16
- Final Exam
- 1
- Students will master database systems concepts and structures.
- 2
- They will be able to create, normalize, and manipulate data using SQL.
- 3
- They will understand transaction management and concurrency challenges.
- 4
- They will evaluate system performance and proper indexing strategies.
- Quantity Percentage Total percent
- Midterms
- 0 0% 0%
- Quizzes
- 0 0% 0%
- Projects
- 1 30% 30%
- Term projects
- 0 0% 0%
- Laboratories
- 0 0% 0%
- Class participation
- 0 0% 0%
- Total term evaluation percent
- 30%
- Final exam percent
- 70%
- Total percent
- 100%
- Quantity Duration (hours) Total (hours)
- Course duration (including exam weeks)
- 16 4 64
- Off class study hours
- 14 3 42
- Duties
- 1 40 40
- Midterms
- 0 0 0
- Final exam
- 1 4 4
- Other
- 0 0 0
- Total workLoad
- 150
- Total workload / 25 (hours)
- 6.00
- ECTS
- 6.00