Information Package / Course Catalogue
| Course Code | : YZO104 |
| Course Type | : Required |
| Couse Group | : Short Cycle (Associate's Degree) |
| Education Language | : Turkish |
| Work Placement | : N/A |
| Theory | : 1 |
| Prt. | : 1 |
| Credit | : 2 |
| Lab | : 0 |
| ECTS | : 5 |
The objective of this course is to introduce students to the fundamental concepts, design principles, and management techniques of database systems. Topics covered include database design based on the relational database model, SQL query languages, data integrity, and security. The goal is to develop students' skills in effectively designing, managing, and optimizing database systems.
This course will cover the design, implementation, and management of databases. Fundamental principles such as data modeling, normalization, data integrity, and security within the relational database model will be examined, and database management systems and effective data management processes will be emphasized.
| Assoc. Prof. Özel SEBETCİ |
| 1. | Makes sample queries about SQL statements. |
| 2. | Creates a database query. |
| 3. | Can perform database-related operations and auxiliary operations. |
| 4. | Can create database. |
| 5. | Can manage database. |
| 1. | Elmasri, R., & Navathe, S. B. (2020). Fundamentals of Database Systems (7th Edition). Pearson. |
| Type of Assessment | Count | Percent |
|---|---|---|
| Midterm Examination | 1 | %40 |
| Final Examination | 1 | %60 |
| Activities | Count | Preparation | Time | Total Work Load (hours) |
|---|---|---|---|---|
| Lecture - Theory | 14 | 2 | 1 | 42 |
| Lecture - Practice | 14 | 1 | 1 | 28 |
| Project | 3 | 6 | 5 | 33 |
| Midterm Examination | 1 | 10 | 1 | 11 |
| Final Examination | 1 | 10 | 1 | 11 |
| TOTAL WORKLOAD (hours) | 125 | |||
PÇ-1 | PÇ-2 | PÇ-3 | PÇ-4 | PÇ-5 | PÇ-6 | PÇ-7 | PÇ-8 | PÇ-9 | PÇ-10 | PÇ-11 | PÇ-12 | |
OÇ-1 | 5 | 5 | 4 | 4 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 |
OÇ-2 | 5 | 4 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 |
OÇ-3 | 3 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 4 | 5 |
OÇ-4 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 5 | 5 | 5 | 4 |
OÇ-5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4 | 5 | 4 | 5 | 4 |