| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Database Management Systems | BM309 | 5. Semester | 4 + 0 | 4.0 | 6.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Undergraduate |
| Course Type | |
| Mode of delivery | Face-to-Face |
| Course Coordinator |
Assoc. Prof. Dr. Fatih KAYAALP |
| Instructor(s) |
Fatih KAYAALP |
| Assistants | |
| Goals | Solving a problem and modeling the processes involved. (formal system analysis) To design a conceptual database using E-R (entity-relationship) diagrams. Identifying constraints, Implementing and executing database objects (table, constraint, index, etc.); Perform basic and advanced database operations using SQL and stored procedures/functions and triggers |
| Course Content | ER diagrams, Normalization, Relational Algebra, Database design and creation, Table, Procedure, Trigger etc. creation of database components, creation of basic and advanced reports with SQL |
| Learning Outcomes |
- Gain knowledge about the basic concepts of the database world - Have knowledge about database models and relational model - Gains knowledge of Relational Algebra infrastructure - Have knowledge about modeling the database with entity-relationship diagrams and creating the database schema from these models and can do it. - Gets knowledge about normalization and apply normalization operations on databases. - Can do CRUD operations on databases with SQL - Gets information about subqueries, grouping and join types in SQL; then can do advanced analysis on databases - Gets informaton about database components such as stored procedure, trigger, index, view etc. and can use them for advanced database operations |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Data and Database Concepts | |
| 2. Week | Entity-relationship model | |
| 3. Week | Relational Data Model | |
| 4. Week | Relational Algebra, Normalization | |
| 5. Week | Database Design | |
| 6. Week | SQL-Record operations | |
| 7. Week | SQL-Subqueries | |
| 8. Week | SQL-Join Operations | |
| 9. Week | Views | |
| 10. Week | Triggers | |
| 11. Week | Stored Procedures | |
| 12. Week | Indexes | |
| 13. Week | User Permissions, Backup/Restore | |
| 14. Week | Student Project Presentations |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | DK5 | DK6 | DK7 | DK8 | Measurement Method |
|---|---|---|---|---|---|---|---|---|---|---|
| PY1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 40,60 |
| PY2 | 2 | 0 | 3 | 4 | 3 | 3 | 3 | 2 | 2 | 40,60 |
| PY4 | 3 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 40,60 |
| PY5 | 3 | 3 | 3 | 3 | 0 | 3 | 3 | 3 | 3 | 40,60 |
| PY7 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 40,60 |
| PY8 | 2 | 0 | 0 | 0 | 5 | 5 | 3 | 3 | 3 | - |
| PY10 | 1 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 40,60 |
| 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) |
|---|---|---|---|
| Course Hours | 14 | 4 | 56 |
| Preparation, After Class Study | 14 | 1.5 | 21 |
| Research | 14 | 1 | 14 |
| Practice | 14 | 1 | 14 |
| Midterm 1 | 1 | 1.5 | 1.5 |
| Homework 1 | 1 | 31 | 31 |
| Final | 1 | 1.5 | 1.5 |
| Classroom Activities | 14 | 1 | 14 |
| Total Workload | 153 | ||
| ECTS Credit of the Course | 6.0 | ||
