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 |