| Course Name | Code | Semester | T+U Hours | Credit | ECTS |
|---|---|---|---|---|---|
| Database Design and Applications | ISE 458 | 8 | 3 + 0 | 3 | 5 |
| Precondition Courses | |
| Recommended Optional Courses | |
| Course Language | Turkish |
| Course Level | Bachelor's Degree |
| Course Type | Optional |
| Course Coordinator | Dr.Öğr.Üyesi TUĞRUL TAŞCI |
| Course Lecturers | Dr.Öğr.Üyesi TUĞRUL TAŞCI, |
| Course Assistants | |
| Course Category | |
| Course Objective | to practically introduce today´s widely used database management system, and to teach the use, design and implementation are the main reasons of this course. |
| Course Content | design, modeling, management systems in databases, Oracle database and user interface, creating tables, insert, delete, update operations, Oracle APEX |
| # | Course Learning Outcomes | Teaching Methods | Assessment Methods |
|---|---|---|---|
| 1 | Recognizes Database management systems | Lecture, | Testing, |
| 2 | models the database entity-relationship diagrams | Lecture, Drilland Practice, | Testing, Homework, |
| 3 | Queries with SQL databases | Lecture, Drilland Practice, Project Based Learning, | Testing, Homework, Project / Design, |
| 4 | Defines the normalization steps | Lecture, Drilland Practice, Project Based Learning, | Testing, Homework, Project / Design, |
| 5 | able to use the sample Database Management System | Lecture, Drilland Practice, | Testing, Homework, |
| Week | Course Topics | Preliminary Preparation |
|---|---|---|
| 1 | Basic concepts of database, (installation, uninstallation) | |
| 2 | database design, modeling, and management systems | |
| 3 | Databases and Oracle database features | |
| 4 | Oracle database and using interface | |
| 5 | Create Oracle tables and registration process | |
| 6 | functions in Oracle. | |
| 7 | order, call records, update and delete operations in Oracle | |
| 8 | table design examples and query techniques. | |
| 9 | Midterm Exam | |
| 10 | Oracle APEX | |
| 11 | Oracle APEX | |
| 12 | Oracle APEX | |
| 13 | Oracle APEX | |
| 14 | Oracle APEX |
| Resources | |
|---|---|
| Course Notes | Materials used in the course |
| Course Resources | |
| Order | Program Outcomes | Level of Contribution | |||||
|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | |||
| 1 | X | ||||||
| 2 | X | ||||||
| 3 | X | ||||||
| 4 | X | ||||||
| 5 | X | ||||||
| 6 | X | ||||||
| 7 | X | ||||||
| 8 | X | ||||||
| 9 | X | ||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| Evaluation System | |
|---|---|
| Semester Studies | Contribution Rate |
| 1. Ödev | 100 |
| Total | 100 |
| 1. Yıl İçinin Başarıya | 50 |
| 1. Final | 50 |
| Total | 100 |
| ECTS - Workload Activity | Quantity | Time (Hours) | Total Workload (Hours) |
|---|---|---|---|
| Course Duration (Including the exam week: 16x Total course hours) | 16 | 3 | 48 |
| Hours for off-the-classroom study (Pre-study, practice) | 16 | 1 | 16 |
| Total Workload | 64 | ||
| Total Workload / 25 (Hours) | 2.56 | ||
| dersAKTSKredisi | 5 | ||