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