| Course Title | Code | Language | Type | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|---|---|
| - | AYP1107 | Turkish | Compulsory | 1. Semester | 3 + 1 | 4.0 | 5.0 |
| Prerequisite Courses | |
| Course Level | Associate |
| Mode of delivery | Face-to-Face |
| Course Coordinator | Öğr. Gör. Erdi YALÇIN |
| Instructor(s) | Öğr. Gör. Erdi YALÇIN (Güz) |
| 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 |
| Week | Topics/Applications | Method |
|---|---|---|
| 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 |
| Ders Kitabı veya Notu | Ders Kitabı veya Ders Notu bulunmamaktadır. |
|---|---|
| Diğer Kaynaklar |
|
| Güz Dönemi | |||
| Responsible Personnel | Grup | Evaluation Method | Percentage |
|---|---|---|---|
| Öğr. Gör. Erdi YALÇIN | Vize | 30.00 | |
| Öğr. Gör. Erdi YALÇIN | Ödev | 20.00 | |
| Öğr. Gör. Erdi YALÇIN | Final | 50.00 | |
| Toplam | 100.00 | ||
