CEN350 Database Management Systems

5 ECTS - 3-0 Duration (T+A)- 6. Semester- 3 National Credit

Information

Code CEN350
Name Database Management Systems
Term 2024-2025 Academic Year
Semester 6. Semester
Duration (T+A) 3-0 (T-A) (17 Week)
ECTS 5 ECTS
National Credit 3 National Credit
Teaching Language İngilizce
Level Lisans Dersi
Type Normal
Mode of study Yüz Yüze Öğretim
Catalog Information Coordinator Prof. Dr. SELMA AYŞE ÖZEL
Course Instructor
1 2
Prof. Dr. SELMA AYŞE ÖZEL (A Group) (Ins. in Charge)


Course Goal / Objective

The objective of this course is to introduce students to how to design, develop and implement efficient databases for real life applications. To effectively use SQL language.

Course Content

Overview of database systems. Database design and E/R diagrams. The relational model. Integrity constraints over relations. Creating and modifying relations using SQL DDL. Schema refinement and normal forms. Relational Algebra and efficient query forming using relatinal algebra operators. Writing queries, constraints and triggers using SQL. Views. Database application development. Algorithms for relational operators. Evaluating relational operators. A typical relational query optimizer. Transaction management. Concurrency control. Crash recovery.

Course Precondition

none

Resources

R.Ramakrishnan, J.Gehrke, "Database Management Systems", McGraw Hill, 2003.

Notes

Any reference to SQL


Course Learning Outcomes

Order Course Learning Outcomes
LO01 Be able to model real life data using entity-relationship model and to make preliminary work for computer solution development.
LO02 Be able to create databases using entity relationship model.
LO03 Be able to write and implement efficient queries to process data in a database.
LO04 Be able to apply usage of database management systems with programming languages.
LO05 Be able to write efficient queries to process data in a database.
LO06 Be able to use the SQL language efficiently.


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Bilgi - Kuramsal, Olgusal Adequate knowledge of mathematics, science and related engineering disciplines; ability to use theoretical and applied knowledge in these fields in solving complex engineering problems. 3
PLO02 Bilgi - Kuramsal, Olgusal Ability to identify, formulate and solve complex engineering problems; ability to select and apply appropriate analysis and modeling methods for this purpose. 5
PLO03 Bilgi - Kuramsal, Olgusal Ability to design a complex system, process, device or product to meet specific requirements under realistic constraints and conditions; ability to apply modern design methods for this purpose. 3
PLO04 Bilgi - Kuramsal, Olgusal Ability to select and use modern techniques and tools necessary for the analysis and solution of complex problems encountered in engineering practice; ability to use information technologies effectively. 4
PLO05 Bilgi - Kuramsal, Olgusal Ability to design and conduct experiments, collect data, analyze and interpret results to investigate complex engineering problems or discipline-specific research topics.
PLO06 Bilgi - Kuramsal, Olgusal Ability to work effectively in interdisciplinary and multidisciplinary teams; individual working skills. 3
PLO07 Bilgi - Kuramsal, Olgusal Ability to communicate effectively verbally and in writing; knowledge of at least one foreign language; ability to write effective reports and understand written reports, prepare design and production reports, make effective presentations, and give and receive clear and understandable instructions. 4
PLO08 Bilgi - Kuramsal, Olgusal Awareness of the necessity of lifelong learning; ability to access information, follow developments in science and technology, and constantly renew oneself. 3
PLO09 Bilgi - Kuramsal, Olgusal Knowledge of ethical principles, professional and ethical responsibility, and standards used in engineering practice. 3
PLO10 Bilgi - Kuramsal, Olgusal Knowledge of business practices such as project management, risk management and change management; awareness of entrepreneurship and innovation; knowledge of sustainable development.
PLO11 Bilgi - Kuramsal, Olgusal Knowledge of the effects of engineering practices on health, environment and safety in universal and social dimensions and the problems of the age reflected in the field of engineering; awareness of the legal consequences of engineering solutions.


Week Plan

Week Topic Preparation Methods
1 Basic concepts and definitions for databases. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
2 Relational data model and entity-relationship diagrams. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
3 Refining database schema and normal forms. Reading the lecture notes, homework assignment Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
4 SQL DDL instructions. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
5 Relational algebra operators and query forming. Reading the lecture notes, homework assignment Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
6 Introduction to SQL DML instructions, query forming with the SELECT statement. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
7 Complex queries with the SELECT statement. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
8 Mid-Term Exam Reading the lecture notes Ölçme Yöntemleri:
Yazılı Sınav
9 Defining the complex integrity rules using SQL, triggers and active databases. Reading the lecture notes, homework assignment Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
10 Database application development, using SQL with a programming language, dynamic SQL, stored procedures. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama
11 Query processing: algorithms for relational algebra operators and their performance analysis. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Soru-Cevap
12 Query processing: query plan forming and query optimization. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Soru-Cevap
13 Transaction management. Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Soru-Cevap
14 Concurrency control Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Soru-Cevap
15 Database security Reading the lecture notes Öğretim Yöntemleri:
Anlatım, Soru-Cevap
16 Preparation to final exam Reading the lecture notes Öğretim Yöntemleri:
Soru-Cevap
17 Term Exams Reading the lecture notes, solving example problems Ölçme Yöntemleri:
Yazılı Sınav


Student Workload - ECTS

Works Number Time (Hour) Workload (Hour)
Course Related Works
Class Time (Exam weeks are excluded) 14 3 42
Out of Class Study (Preliminary Work, Practice) 14 3 42
Assesment Related Works
Homeworks, Projects, Others 0 0 0
Mid-term Exams (Written, Oral, etc.) 1 12 12
Final Exam 1 18 18
Total Workload (Hour) 114
Total Workload / 25 (h) 4,56
ECTS 5 ECTS

Update Time: 11.05.2024 05:48