| Course Name | Code | Semester | T+U Hours | Credit | ECTS |
|---|---|---|---|---|---|
| Database Management Systems | ENF 532 | 0 | 3 + 0 | 3 | 6 |
| Precondition Courses | |
| Recommended Optional Courses | |
| Course Language | Turkish |
| Course Level | yuksek_lisans |
| Course Type | Optional |
| Course Coordinator | Doç.Dr. İHSAN HAKAN SELVİ |
| Course Lecturers | Doç.Dr. İHSAN HAKAN SELVİ, |
| Course Assistants | |
| Course Category | |
| Course Objective | As computers becoming indispensable parts of our lives, data and databases gathers more importance everyday. The main goal of the course is to teach the basics of database(data storage), how to use, design and make sample applications. In addition to teach students about the concepts of a database, data modeling and logical design which enables them to store and efficiently manage the relational data that can be encountered in many areas of daily life; to teach students about Structured Query Language (SQL) which allows them to define and manipulate data in a database and to provide students to develop database applications using Microsoft Access, Microsoft SQL Server or MYSQL, the three relational database management systems which have widespread use. |
| Course Content | Definitions and basic concepts, entity-relation model, Relational Data Model, Relational Algebra and Calculation, Structural Query Language, Functional dependence and normalization, Database Recovery, Database Security, Object Oriented Database, |
| # | Course Learning Outcomes | Teaching Methods | Assessment Methods |
|---|---|---|---|
| 1 | Recognize database management systems | Lecture, | Testing, |
| 2 | Make the models of database with entity-relation diagrams. | Lecture, Drilland Practice, | Testing, Homework, |
| 3 | Structured Query Language (SQL) to learn the structure and codes | Lecture, Drilland Practice, Motivations to Show, Lab / Workshop, Project Based Learning, | Testing, Homework, Project / Design, |
| 4 | SQL codes with the create database, create tables and queries | Case Study, Lab / Workshop, Project Based Learning, | Testing, Homework, Project / Design, |
| 5 | Apply the rules of Database Normalization | Lecture, Question-Answer, Case Study, | Testing, Homework, Project / Design, |
| 6 | Install and use the database management systems | Lecture, Lab / Workshop, | Testing, Homework, Project / Design, |
| Week | Course Topics | Preliminary Preparation |
|---|---|---|
| 1 | Historical Evolution of Database Management Systems | |
| 2 | Data Modeling, The Entity-Relationship Model (ER Model) | |
| 3 | Relational Data Model and Relational Database Constraints, Relationship Types : 1-1, 1-N, N-M Relationships | |
| 4 | Relational Algebra and Calculation | |
| 5 | Rules of Database Normalization | |
| 6 | Introduction to Structured Query Language (SQL) and Data Definition Language (DDL) | |
| 7 | Create Queries with SQL Data Manipulation Languages (DML) | |
| 8 | Create Queries with SQL Data Manipulation Languages (DML) | |
| 9 | Complex Queries | |
| 10 | Complex Queries | |
| 11 | Application Development with Database Management Systems | |
| 12 | Application Development with Database Management Systems | |
| 13 | Distributed Databases | |
| 14 | Object Oriented Databases and Database Connection Through User Applications |
| Resources | |
|---|---|
| Course Notes | |
| Course Resources | |
| Order | Program Outcomes | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | X | ||||||
| 2 | X | ||||||
| 3 | X | ||||||
| 4 | X | ||||||
| 5 | X | ||||||
| 6 | X | ||||||
| 8 | X | ||||||
| 8 | X | ||||||
| 9 | X | ||||||
| Evaluation System | |
|---|---|
| Semester Studies | Contribution Rate |
| 1. Ödev | 100 |
| Total | 100 |
| 1. Yıl İçinin Başarıya | 40 |
| 1. Final | 60 |
| Total | 100 |
| ECTS - Workload Activity | Quantity | Time (Hours) | Total Workload (Hours) |
|---|---|---|---|
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 3 | 48 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 2 | 32 |
| Mid-terms | 1 | 10 | 10 |
| Assignment | 2 | 15 | 30 |
| Final examination | 1 | 20 | 20 |
| Total Workload | 140 | ||
| Total Workload / 25 (Hours) | 5.6 | ||
| dersAKTSKredisi | 6 | ||