TÜRKÇE
ENGLISH
Information
| Code | CEN350 |
| Name | Database Management Systems |
| Term | 2022-2023 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 |
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 | Has capability in the fields of mathematics, science and computer that form the foundations of engineering | 3 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Identifies, formulates, and solves engineering problems, selects and applies appropriate analytical methods and modeling techniques, | 5 |
| PLO03 | Bilgi - Kuramsal, Olgusal | Analyzes a system, its component, or process and designs under realistic constraints to meet the desired requirements,gains the ability to apply the methods of modern design accordingly. | 3 |
| PLO04 | Bilgi - Kuramsal, Olgusal | Ability to use modern techniques and tools necessary for engineering practice and information technologies effectively. | 4 |
| PLO05 | Bilgi - Kuramsal, Olgusal | Ability to design and to conduct experiments, to collect data, to analyze and to interpret results | |
| PLO06 | Bilgi - Kuramsal, Olgusal | Has ability to work effectively as an individual and in multi-disciplinary teams, take sresponsibility and builds self-confidence | 3 |
| PLO07 | Beceriler - Bilişsel, Uygulamalı | Can access information,gains the ability to do resource research and uses information resources | 4 |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | Awareness of the requirement of lifelong learning, to follow developments in science and technology and continuous self-renewal ability | 3 |
| PLO09 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Ability to communicate effectively orally and in writing, and to read and understand technical publications in at least one foreign language | 3 |
| PLO10 | Yetkinlikler - Öğrenme Yetkinliği | Professional and ethical responsibility, | |
| PLO11 | Yetkinlikler - Öğrenme Yetkinliği | Awareness about project management, workplace practices, employee health, environmental and occupational safety, and the legal implications of engineering applications, | |
| PLO12 | Yetkinlikler - Öğrenme Yetkinliği | Becomes aware of universal and social effects of engineering solutions and applications, entrepreneurship and innovation, and knowledge of contemporary issues |
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 | ||