| Course Name | Code | Semester | T+U Hours | Credit | ECTS |
|---|---|---|---|---|---|
| Database Management Systems | ISE 305 | 5 | 3 + 0 | 3 | 5 |
| Precondition Courses | |
| Recommended Optional Courses | |
| Course Language | Turkish |
| Course Level | Bachelor's Degree |
| Course Type | Compulsory |
| Course Coordinator | Arş.Gör.Dr. MUHAMMED KOTAN |
| Course Lecturers | Arş.Gör.Dr. MUHAMMED KOTAN, |
| 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. |
| Course Content | Definitions and basic concepts, entity-relation model, Relational Data Model, Relational Algebra and Calculation, Structural Query Language, Functional dependence and normalization, Transaction Management, Synchronism Control, Database Recovery, Database Security, Object Oriented Database, Database Programming and Internet Applications, Data Warehouse and Data Mining |
| # | Course Learning Outcomes | Teaching Methods | Assessment Methods |
|---|---|---|---|
| 1 | Recognizes database management systems | Lecture, Drilland Practice, Role Playing, | Testing, Homework, |
| 2 | Makes the models of database with entity-relation diagrams. | Lecture, Drilland Practice, Role Playing, Project Based Learning, | Testing, Homework, |
| 3 | Query databases with SQL | Lecture, Question-Answer, Drilland Practice, Project Based Learning, | Testing, Homework, |
| 4 | Understands database normalization steps | Lecture, Drilland Practice, Role Playing, Project Based Learning, | Testing, Project / Design, |
| Week | Course Topics | Preliminary Preparation |
|---|---|---|
| 1 | Introduction to Database Management Systems | |
| 2 | Entity-relation model | |
| 3 | Relational Data Model | |
| 4 | Relational Algebra and Calculation | |
| 5 | SQL | |
| 6 | SQL | |
| 7 | SQL | |
| 8 | Normalization | |
| 9 | Database Management System | |
| 10 | Database Management System | |
| 11 | Database Management System | |
| 12 | Web Database Applications | |
| 13 | Web Database Applications | |
| 14 | Web Database Applications |
| Resources | |
|---|---|
| Course Notes | Ramakrishnan . Gehrke,Database Management Systems, Third Edition, McGraw-Hill,2003. |
| Course Resources | 1.Yarımağan, Ü.,Veritabanı Sistemleri, Ankara, 2000. 2. C. J. Date, "An Introduction to Database Systems", Eight Edition, Addison-Wesley, 2004. |
| Order | Program Outcomes | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | X | ||||||
| 2 | X | ||||||
| 3 | X | ||||||
| 4 | X | ||||||
| 5 | X | ||||||
| 6 | |||||||
| 7 | X | ||||||
| 8 | |||||||
| 9 | X | ||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| Evaluation System | |
|---|---|
| Semester Studies | Contribution Rate |
| 1. Ara Sınav | 50 |
| 1. Kısa Sınav | 20 |
| 1. Ödev | 15 |
| 2. Ödev | 15 |
| 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 | 4 | 64 |
| Mid-terms | 1 | 5 | 5 |
| Quiz | 1 | 5 | 5 |
| Assignment | 2 | 5 | 10 |
| Final examination | 1 | 15 | 15 |
| Total Workload | 147 | ||
| Total Workload / 25 (Hours) | 5.88 | ||
| dersAKTSKredisi | 5 | ||