TOROS ÜNİVERSİTESİ
Bilgi Paketi Ders Kataloğu

Course Information

DATABASES
Code	Semester	Theoretical	Practice	National Credit	ECTS Credit
		Hour / Week
CSE309	Fall	2	2	3	4

Prerequisites and co-requisites	None
Language of instruction	English
Type	Elective
Level of Course	Bachelor's
Lecturer	Asst. Prof. Mehmet Ali AKTAŞ
Mode of Delivery	Face to Face
Suggested Subject	None
Professional practise ( internship )	None
Objectives of the Course	This course is intended to give students a solid background in databases, with a focus on relational database management systems.
Contents of the Course	Topics include data modeling, database design theory, data definition and manipulation languages, storage and indexing techniques, query processing and optimization, concurrency control and recovery, and database programming interfaces.

Learning Outcomes of Course

#	Learning Outcomes
1	To be able to learn structured query language, database objects and data types.
2	To be able to understand structured query language commands.
3	To be able to learn how to open, modify delete tables in the structured query language.
4	To be able to understand administrative functions in the structured query language.
5	To be able to learn the programming logic in a client/server featured database.
6	To be able to prepare an interface in a client/server featured database.
7	To be able to prepare reports in a client/server featured database.

Course Syllabus

#	Subjects	Teaching Methods and Technics
1	Introduction to database systems, fundamentals	Lecture, discussion, presentation
2	Relational model	Lecture, discussion, presentation
3	Relational algebra	Lecture, discussion, presentation
4	Database design in E/R model	Lecture, discussion, presentation
5	Database design theory	Lecture, discussion, presentation
6	SQL: Basics	Lecture, discussion, presentation
7	1. Mid Term Exam	Exam
8	SQL: Subqueries, aggregation	Lecture, discussion, presentation
9	SQL: NULL’s outerjoints	Lecture, discussion, presentation
10	SQL: Modifications, constraints, triggers	Lecture, discussion, presentation
11	SQL: Views, indexes	Lecture, discussion, presentation
12	More database design thoery	Lecture, discussion, presentation
13	Data integration, warehousing, mining	Lecture, discussion, presentation
14	Final Exam	Exam
15
16

Course Syllabus

#	Material / Resources	Information About Resources	Reference / Recommended Resources

Method of Assessment

#	Weight	Work Type	Work Title
1	40%	Mid-Term Exam	Mid-Term Exam
2	60%	Final Exam	Final Exam

Relationship between Learning Outcomes of Course and Program Outcomes

#	Learning Outcomes	Program Outcomes	Method of Assessment
1	To be able to learn structured query language, database objects and data types.	1͵3	1͵2
2	To be able to understand structured query language commands.	1͵3	1͵2
3	To be able to learn how to open, modify delete tables in the structured query language.	1͵3	1͵2
4	To be able to understand administrative functions in the structured query language.	1͵3	1͵2
5	To be able to learn the programming logic in a client/server featured database.	1͵3	1͵2
6	To be able to prepare an interface in a client/server featured database.	1͵3	1͵2
7	To be able to prepare reports in a client/server featured database.	1͵3	1͵2

PS. The numbers, which are shown in the column Method of Assessment, presents the methods shown in the previous table, titled as Method of Assessment.

Work Load Details

#	Type of Work	Quantity	Time (Hour)	Work Load
1	Course Duration	14	4	56
2	Course Duration Except Class (Preliminary Study, Enhancement)	14	2	28
3	Presentation and Seminar Preparation	0	0	0
4	Web Research, Library and Archival Work	0	0	0
5	Document/Information Listing	0	0	0
6	Workshop	0	0	0
7	Preparation for Midterm Exam	0	0	0
8	Midterm Exam	1	2	2
9	Quiz	1	5	5
10	Homework	0	0	0
11	Midterm Project	0	0	0
12	Midterm Exercise	0	0	0
13	Final Project	0	0	0
14	Final Exercise	0	0	0
15	Preparation for Final Exam	1	2	2
16	Final Exam	1	2	2
				95