| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Database Management Systems | ENM205 | 3. Semester | 3 + 0 | 3.0 | 4.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Undergraduate |
| Course Type | |
| Mode of delivery | |
| Course Coordinator |
Assist. Prof. Dr. Serdar KIRIŞOĞLU |
| Instructors |
Serdar KIRIŞOĞLU |
| Assistants | |
| Goals | To be able to define the concepts of database and database management systems, explain the functions of database management systems, to be able to realize the stages of database formation (requirement analysis, conceptual modeling, logical modeling and physical modeling) To be able to query, modify, add, delete data using SQL language Create and manage database in MySQL database management system |
| Course Content | Basic concepts, advantages and disadvantages of database, classical file system and database system, drawbacks of classical file systems, benefits of database system, basic features of database systems, data independence, data abstraction, data security, data integrity, data sharing, database system elements (database, database management system, hardware, software, users), database management system concept and architecture (external level, conceptual level, internal level and mappings), data models (hierarchical, network and relational), structural inquiry (SQL), commercial database systems, application development with MS access. |
| Learning Outcomes |
- 32/5000 To know the concepts of database, - To design a database - To be able to write queries using SQL query language - Ability to use functions, - Define rules - Ability to make authorizations |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Introduction to Database Management Systems | Verbal Expression |
| 2. Week | Database Concepts | Verbal Expression |
| 3. Week | Relational Database Concepts | Verbal Expression |
| 4. Week | Database Users and Design | Verbal Expression |
| 5. Week | Relational Database and Normalization | Verbal Expression Visual Presentation |
| 6. Week | T-Sql Data Manipulation Language | Visual Presentation Practice Verbal Expression |
| 7. Week | T-Sql Data Query Language | Visual Presentation Verbal Expression |
| 8. Week | T-Sql Data Definition Language | Visual Presentation Verbal Expression |
| 9. Week | Database Operations with Sql Server Management Studio | Visual Presentation Verbal Expression |
| 10. Week | Views | Visual Presentation Verbal Expression |
| 11. Week | Stored Procedures | Visual Presentation Verbal Expression |
| 12. Week | Triggers | Visual Presentation Verbal Expression |
| 13. Week | Sample Project 1 | Practice Visual Presentation Verbal Expression |
| 14. Week | Sample Project 2 | Visual Presentation Verbal Expression Practice |
| Textbook: R. Ramakrishnan, J. Gehrke, Database Management Systems-Third Edition, McGraw Hill, 2003. Supplementary Textbooks: • Y. Özkan, Database Systems. Alfa Printing Publishing Inc. , 2003. • Z. A. Burma, Database Management Systems (SQL / PL / SQL / T Sistem SQL), Seçkin Publishing, 2009. • Y. Daşdemir, Database management systems, Turkmen Bookstore, 2004. |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 | Measurement Method |
|---|---|---|---|---|---|---|---|---|
| PY1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | - |
| PY2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | - |
| PY3 | 2 | 2 | 2 | 2 | 3 | 1 | 2 | - |
| PY4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | - |
| PY5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | - |
| PY6 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | - |
| PY7 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | - |
| PY8 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | - |
| PY9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | - |
| 0 | 1 | 2 | 3 | 4 | 5 | |
|---|---|---|---|---|---|---|
| Course's Level of contribution | None | Very Low | Low | Fair | High | Very High |
| Method of assessment/evaluation | Written exam | Oral Exams | Assignment/Project | Laboratory work | Presentation/Seminar |
| Event | Quantity | Duration (Hour) | Total Workload (Hour) |
|---|---|---|---|
| Midterm 1 | 1 | 2.5 | 2.5 |
| Midterm 2 | 1 | 2.5 | 2.5 |
| Homework 1 | 1 | 10 | 10 |
| Homework 2 | 1 | 2.5 | 2.5 |
| Final | 1 | 10 | 10 |
| Practice | 2 | 10 | 20 |
| Practice End-Of-Term | 2 | 10 | 20 |
| Classroom Activities | 6 | 10 | 60 |
| Total Workload | 127.5 | ||
| ECTS Credit of the Course | 4.0 | ||
