| Course Title | Code | Semester | L+U Hour | Credits | ECTS |
|---|---|---|---|---|---|
| Database I | ABL3011 | 3. Semester | 3 + 1 | 4.0 | 4.0 |
| Prerequisites | None |
| Language of Instruction | Turkish |
| Course Level | Associate |
| Course Type | |
| Mode of delivery | Face to face |
| Course Coordinator |
Lect. Erdi YALÇIN |
| Instructor(s) |
Erdi YALÇIN |
| Assistants | |
| Goals | To teach concepts about design and creating databases, query data and using DBMS functions |
| Course Content | Database concept, conponents of databases, DDL, queries, DBMS programs |
| Learning Outcomes |
- Design database - Create database - Query database - Use Database management functions |
| Week | Topics | Learning Methods |
|---|---|---|
| 1. Week | Database analysis, Normalization | |
| 2. Week | Normalization | |
| 3. Week | Normalization | |
| 4. Week | Installing DBMS, design and create tables | |
| 5. Week | Design and create tables and setting properties | |
| 6. Week | Design and create tables, setting properties | |
| 7. Week | Create queries and query types | |
| 8. Week | Create query and query types, queries on related tables | |
| 9. Week | Queries on related tables | |
| 10. Week | DML queries | |
| 11. Week | DML queries, Creating user queries | |
| 12. Week | Creating vievs, Creating triggers, | |
| 13. Week | Creating triggers, Creating sub-queries | |
| 14. Week | Creating Transactions, creating indexes |
| Ozseven T., Database Managements Systems 1, Murathan Press,, Trabzon |
| www.w3schools.com |
| Databases and applications, Papatya Press |
| Program Requirements | Contribution Level | DK1 | DK2 | DK3 | DK4 | Measurement Method |
|---|
| 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 | 4 | 56 |
| Midterm 1 | 1 | 1 | 1 |
| Midterm 2 | 1 | 1 | 1 |
| Homework 1 | 2 | 2 | 4 |
| Homework 2 | 2 | 2 | 4 |
| Quiz 1 | 1 | 1 | 1 |
| Quiz 2 | 1 | 1 | 1 |
| Final | 2 | 1 | 2 |
| Practice | 1 | 1 | 1 |
| Practice End-Of-Term | 1 | 1 | 1 |
| Total Workload | 128 | ||
| ECTS Credit of the Course | 4.0 | ||
