Education Information System

Course Information

Course Information

Course Title	Code	Language	Type	Semester	L+U Hour	Credits	ECTS
Database I	ABL3011	Turkish	Compulsory	3. Semester	3 + 1	4.0	4.0

Prerequisite Courses
Course Level	Associate
Mode of delivery	Face to face
Course Coordinator	Dr. Öğr. Üyesi Fatih İLKBAHAR
Instructor(s)	Dr. Öğr. Üyesi Fatih İLKBAHAR (Güz)
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

#	Öğrenme Kazanımı
1	Design database
2	Create database
3	Query database
4	Use Database management functions

Lesson Plan (Weekly Topics)

Week	Topics/Applications	Method
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

*Midterm and final exam dates are not specified in the 14-week course operation plan. Midterm and final exam dates are held on the dates specified in the academic calendar with the decision of the University Senate.

Relations with Education Attainment Program Course Competencies

Program Requirements	DK1	DK2	DK3	DK4

Recommended Sources

Ders Kitabı veya Notu	Ders Kitabı veya Ders Notu bulunmamaktadır.
Diğer Kaynaklar	Ozseven T., Database Managements Systems 1, Murathan Press,, Trabzon www.w3schools.com Databases and applications, Papatya Press

ECTS credits and course workload

ECTS credits and course workload		Quantity	Duration (Hour)	Total Workload (Hour)
Ders İçi	Class Hours	14	4	56
Ders Dışı	Preparation, After Class Study	14	4	56
Sınavlar	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
*AKTS = (Total Workload) / 25,5		ECTS Credit of the Course		25.5 4.0