TÜRKÇE
ENGLISH
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 |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Prof. Dr. SELMA AYŞE ÖZEL |
| Course Instructor |
1 2 |
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
Silberschatz, A., Korth, H.F., Sudarshan, S., Database System Concepts, Seventh Edition, McGraw-Hill, 2019. 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-world problems using an entity-relationship model and design databases based on this model. |
| LO02 | Be able to execute effective queries on databases to retrieve and analyze meaningful information. |
| LO03 | Be able to develop applications by integrating database management systems with programming languages. |
| LO04 | Be able to create high-performance queries through efficient and effective use of SQL. |
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. | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| PLO09 | Bilgi - Kuramsal, Olgusal | Knowledge of ethical principles, professional and ethical responsibility, and standards used in engineering practice. | |
| 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 | |
| 2 | Relational data model and entity-relationship diagrams. | Reading the lecture notes | |
| 3 | Refining database schema and normal forms. | Reading the lecture notes, homework assignment | |
| 4 | SQL DDL instructions. | Reading the lecture notes | |
| 5 | Relational algebra operators and query forming. | Reading the lecture notes, homework assignment | |
| 6 | Introduction to SQL DML instructions, query forming with the SELECT statement. | Reading the lecture notes | |
| 7 | Complex queries with the SELECT statement. | Reading the lecture notes | |
| 8 | Mid-Term Exam | Reading the lecture notes | |
| 9 | Defining the complex integrity rules using SQL, triggers and active databases. | Reading the lecture notes, homework assignment | |
| 10 | Database application development, using SQL with a programming language, dynamic SQL, stored procedures. | Reading the lecture notes | |
| 11 | Query processing: algorithms for relational algebra operators and their performance analysis. | Reading the lecture notes | |
| 12 | Query processing: query plan forming and query optimization. | Reading the lecture notes | |
| 13 | Transaction management. | Reading the lecture notes | |
| 14 | Concurrency control | Reading the lecture notes | |
| 15 | Database security | Reading the lecture notes | |
| 16 | Term Exams | Reading the lecture notes, solving example problems | |
| 17 | Term Exams | Reading the lecture notes, solving example problems |
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 | ||