DATABASE MANAGEMENT DERS TANITIM VE UYGULAMA BİLGİLERİ

Kodu	Dersin Adı	Yarıyıl	Süresi(T+U)	Kredisi	AKTS Kredisi
COM303	DATABASE MANAGEMENT	5	4	3	6

DERS BİLGİLERİ
Dersin Öğretim Dili :	İngilizce
Dersin Düzeyi	BACHELOR'S DEGREE, TYY: + 6.Level, EQF-LLL: 6.Level, QF-EHEA: First Cycle
Dersin Türü	Zorunlu
Dersin Veriliş Şekli	-
Dersin Koordinatörü	Assist.Prof. OĞUZHAN ÖZTAŞ
Dersi Veren Öğretim Üyesi/Öğretim Görevlisi
Ders Ön Koşulu	Yok

AMAÇ VE İÇERİK
Amaç:	To teach the students defining entities and relationships, modelling attributes and constraints, normalizing data model, constructing physical database from data models, defining the basics of relational database systems, developing applications through SQL queries.
İçerik:	Defining Entities and Relationships, Modelling Attributes and Constraints, Normalizing Data Model, Constructing Physical Database From Data Models, Defining The Basics Of Relational Database Systems, Indexing, Developing Applications Through SQL Queries, Developing Oracle Applications.

DERSİN ÖĞRENME ÇIKTILARI (Öğrenciler, bu dersi başarı ile tamamladıklarında aşağıda belirtilen bilgi, beceri ve/veya yetkinlikleri gösterirler.)
Define entities and relationships.
Construct data models.
Describe relational databases.
Construct physical databases.
Construct SQL queries.
Develops applications in Database Management System.

HAFTALIK DERS KONULARI VE ÖNGÖRÜLEN HAZIRLIK ÇALIŞMALARI
Hafta	Ön Hazırlık	Konular	Yöntem
1	-	Importance of data, data management, and data management systems	-
2	-	Defining the problem and gathering data	-
3	-	Introduction to relational databases	-
4	-	Relational database management systems	-
5	-	Data Models	-
6	-	Entity - Relationship Diagrams	-
7	-	Data Modeling and Normalization	-
8	-	MID-TERM EXAM	-
9	-	SQL: Data Definition Language	-
10	-	Simple SQL queries	-
11	-	Built-in SQL functions	-
12	-	Complex SQL queries	-
13	-	Triggers	-
14	-	Indexes and how to use them	-
15	-	Other data models: XML, Text, and multimedia	-
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

KAYNAKLAR
Database Systems using Oracle: A Simplified Guide to SQL and PL/SQL, Nilesh Shah, Pearson Prentice Hall, 2005
Database Systems: A Practical Approach to Design, Implementation and Management, Thomas M. Connolly, Carolyn E. Begg, Pearson, 2014

ÖLÇME VE DEĞERLENDİRME
Yarıyıl İçi Yapılan Çalışmaların Ölçme ve Değerlendirmesi	Etkinlik Sayısı	Katkı Yüzdesi	Açıklama

(0) Etkisiz	(1) En Düşük	(2) Düşük	(3) Orta	(4) İyi	(5) Çok İyi
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Explains the fundamental engineering concepts of computer science and relates them to the groundwork of computer science.

KNOWLEDGE
Factual
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Uses theoretical and practical knowledge coming from mathematics, probability, statistics and various other branches of life sciences, to find solutions to engineering problems.

SKILLS
Cognitive
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Determines the components and the underlying process of a system and designs an appropriate computational model under reasonable constraints.
2	Designs a computer-aided conceptual model with modern techniques.

SKILLS
Practical
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Determines, detects and analyzes the areas of computer science applications and develops appropriate solutions.
2	Identifies, models and solves computer engineering problems by applying appropriate analytical methods.
3	Determines and uses the necessary information technologies in an efficient way for engineering applications.

OCCUPATIONAL
Autonomy & Responsibility
	Program Yeterlilikleri/Çıktıları	Katkı Düzeyi
		0	1	2	3	4	5
1	Possess the responsibility and ability to design and conduct experiments for engineering problems by collecting, analyzing and interpreting data.
2	Possess the ability to conduct effective individual study.
3	Takes responsibility as a team work and contributes in an effective way.

DERSİN İŞ YÜKÜ VE AKTS KREDİSİ
Öğrenme-Öğretme Etkinlikleri İş Yükü
Öğrenme-Öğretme Etkinlikleri	Etkinlik(hafta sayısı)	Süresi(saat sayısı)	Toplam İş Yükü
Lecture & In-Class Activities	0	0	0
Preliminary & Further Study	0	0	0
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	0	0	0
Project Work	0	0	0
Seminar	0	0	0
Internship	0	0	0
Technical Visit	0	0	0
Web Based Learning	0	0	0
Implementation/Application/Practice	0	0	0
Practice at a workplace	0	0	0
Occupational Activity	0	0	0
Social Activity	0	0	0
Thesis Work	0	0	0
Field Study	0	0	0
Report Writing	0	0	0
Final Exam	0	0	0
Preparation for the Final Exam	0	0	0
Mid-Term Exam	0	0	0
Preparation for the Mid-Term Exam	0	0	0
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	0	0	0