Computer Engineering
Course Details
KTO KARATAY UNIVERSITY
Mühendislik ve Doğa Bilimleri Fakültesi
Programme of Computer Engineering
Course Details
Mühendislik ve Doğa Bilimleri Fakültesi
Programme of Computer Engineering
Course Details
| Course Code | Course Name | Year | Period | Semester | T+A+L | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| 05050004 | Database Management Systems | 3 | Autumn | 5 | 3+0+2 | 4 | 5 |
| Course Type | Compulsory |
| Course Cycle | Bachelor's (First Cycle) (TQF-HE: Level 6 / QF-EHEA: Level 1 / EQF-LLL: Level 6) |
| Course Language | Turkish |
| Methods and Techniques | - |
| Mode of Delivery | Face to Face |
| Prerequisites | - |
| Coordinator | - |
| Instructor(s) | Assoc. Prof. Ali ÖZTÜRK |
| Instructor Assistant(s) | - |
Course Instructor(s)
| Name and Surname | Room | E-Mail Address | Internal | Meeting Hours |
|---|---|---|---|---|
| Assoc. Prof. Ali ÖZTÜRK | A-127 | [email protected] | 0 | Thursday 14.00-15.00 |
Course Content
Verilerin mantıksal organizasyonu, problem tanımı, varlık ve ilişki kavramları, öznitelikler, varlık-ilişki (ER) veri modellemesi, problem tanımlama ifadelerinden ER diyagramlarının elde edilmesi, ER diyagramlarının SQL tablolarına çevrilmesi, ilişkisel cebir, birlik, bölme, kesişme, filtreleme işlemler, veri tanımlama ve sorgulama dilleri, temel SQL veri işleme ve veri tanımlama komutları, tekli masa ve çok masalı sorgulamalar, bölümleme.
Objectives of the Course
To learn how to use and design database management systems and how to develop database applications.
Contribution of the Course to Field Teaching
| Basic Vocational Courses | |
| Specialization / Field Courses | X |
| Support Courses | X |
| Transferable Skills Courses | |
| Humanities, Communication and Management Skills Courses |
Relationships between Course Learning Outcomes and Program Outcomes
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Program Learning Outcomes | Level |
|---|---|---|
| P3 | 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 | 5 |
| P4 | Ability to develop, select and use modern techniques and tools for the analysis and solution of complex problems encountered in engineering applications; ability to use information technologies effectively | 5 |
Course Learning Outcomes
| Upon the successful completion of this course, students will be able to: | |||
|---|---|---|---|
| No | Learning Outcomes | Outcome Relationship | Measurement Method ** |
| O1 | Using and selecting the necessary tools for database system management and programming. | P.3.14 | 1,7 |
| O2 | Knowledge of database management systems and relational database concepts. | P.4.8 | 1 |
| O3 | Database design and drawing database diagrams. | P.4.9 | 1 |
| O4 | Database programming language knowledge. (SQL) | P.4.10 | 1 |
| O5 | Knowledge of database system control and management. | P.4.11 | 1 |
| O6 | Database backup and restore information. | P.4.12 | 1,7 |
| ** Written Exam: 1, Oral Exam: 2, Homework: 3, Lab./Exam: 4, Seminar/Presentation: 5, Term Paper: 6, Application: 7 | |||
Weekly Detailed Course Contents
| Week | Topics |
|---|---|
| 1 | Introduction to databases |
| 2 | Intro to ER Model |
| 3 | Relational Model: Relational Algebra, Relational Calculus |
| 4 | Query Languages: SQL |
| 5 | Basic SQL data manipulation and data definition commands |
| 6 | Design of Relational databases |
| 7 | Midterm |
| 8 | Peformance Modelling, Database Tuning |
| 9 | File and System Structures: file organization |
| 10 | Indexing and Sorting |
| 11 | Query-Processing |
| 12 | Transaction Management |
| 13 | Exam |
Textbook or Material
| Resources | Database Management Systems, by Raghu Ramakrishnan and Johannes Gehrke, (2007) |
Evaluation Method and Passing Criteria
| In-Term Studies | Quantity | Percentage |
|---|---|---|
| Attendance | - | - |
| Laboratory | - | - |
| Practice | - | - |
| Course Specific Internship (If Any) | 4 | 20 (%) |
| Homework | - | - |
| Presentation | - | - |
| Projects | - | - |
| Quiz | - | - |
| Midterms | 1 | 30 (%) |
| Final Exam | 1 | 50 (%) |
| Total | 100 (%) | |
ECTS / Working Load Table
| Quantity | Duration | Total Work Load | |
|---|---|---|---|
| Course Week Number and Time | 14 | 3 | 42 |
| Out-of-Class Study Time (Pre-study, Library, Reinforcement) | 14 | 3 | 42 |
| Midterms | 1 | 18 | 18 |
| Quiz | 0 | 0 | 0 |
| Homework | 0 | 0 | 0 |
| Practice | 0 | 0 | 0 |
| Laboratory | 3 | 6 | 18 |
| Project | 0 | 0 | 0 |
| Workshop | 0 | 0 | 0 |
| Presentation/Seminar Preparation | 0 | 0 | 0 |
| Fieldwork | 0 | 0 | 0 |
| Final Exam | 1 | 30 | 30 |
| Other | 0 | 0 | 0 |
| Total Work Load: | 150 | ||
| Total Work Load / 30 | 5 | ||
| Course ECTS Credits: | 5 | ||
Course - Learning Outcomes Matrix
| Relationship Levels | ||||
| Lowest | Low | Medium | High | Highest |
| 1 | 2 | 3 | 4 | 5 |
| # | Learning Outcomes | P3 | P4 |
|---|---|---|---|
| O1 | Using and selecting the necessary tools for database system management and programming. | 2 | 4 |
| O2 | Knowledge of database management systems and relational database concepts. | 1 | 5 |
| O3 | Database design and drawing database diagrams. | 3 | 2 |
| O4 | Database programming language knowledge. (SQL) | 1 | 5 |
| O5 | Knowledge of database system control and management. | 2 | 3 |
| O6 | Database backup and restore information. | 2 | 5 |