DEPARTMENT OF SOFTWARE ENGINEERING (ENGLISH)
Bachelor	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF-LLL: Level 6

Ders Genel Tanıtım Bilgileri

Course Code:

1400311005

Ders İsmi:

Database Systems

Ders Yarıyılı:

Fall

Ders Kredileri:

Theoretical	Practical	Credit	ECTS
3	0	3	6

Language of instruction:

Ders Koşulu:

Ders İş Deneyimini Gerektiriyor mu?:

Type of course:

Necessary

Course Level:

Bachelor

TR-NQF-HE:6. Master`s Degree

QF-EHEA:First Cycle

EQF-LLL:6. Master`s Degree

Mode of Delivery:

Face to face

Course Coordinator :

Dr.Öğr.Üyesi Recep DURANAY

Course Lecturer(s):

Dr.Öğr.Üyesi İmren YEŞİLYURT

Course Assistants:

Dersin Amaç ve İçeriği

Course Objectives:	The aim of this course is to provide students with proficiency in principles and subjects related to database management systems.
Course Content:	Design algorithms and applications; entity-relationship model; hierarchical, network, relational databases; query languages; relational algebra and computation; data dependencies; normal forms; consistency, integrity and security issues, term project.

Learning Outcomes

The students who have succeeded in this course;

Learning Outcomes

1 - Knowledge
Theoretical - Conceptual
2 - Skills
Cognitive - Practical
3 - Competences
Communication and Social Competence
Learning Competence
Field Specific Competence
Competence to Work Independently and Take Responsibility

Ders Akış Planı

Week	Subject	Related Preparation
1)	Introduction to Database Management Systems	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
2)	Entity-Relationship Model	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
3)	Generalization, Clustering, V-I Diagram Design	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
4)	Relational Algebra	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
5)	Query Processing	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
6)	Database Changing, Appearances	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
7)	SQL I	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
8)	MIDTERM	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
9)	SQL II	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
10)	Integrity Constraints	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
11)	Relational Database Design"	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
12)	Trigger and Procedures	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
13)	Network Based Application Design,	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
14)	XML ve XSLT	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
15)	Normalization, Normal Forms	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
16)	FINAL	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.

Sources

Course Notes / Textbooks:	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.
References:	Silberschatz, A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th Edition, McGraw-Hill, 2005.

Ders - Program Öğrenme Kazanım İlişkisi

Ders Öğrenme Kazanımları
Program Outcomes
1) Competent knowledge of mathematics, science and technology, and computer engineering; ability to apply this knowledge to engineering solutions.
2) Skills to design and conduct experiments, collect data, analyze and interpret results.
3) Ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; ability to apply modern design methods for this purpose.
4) Ability to develop, select and use modern techniques and tools required for analysis and solution of complex problems encountered in engineering practice; ability to use information technologies effectively.
5) Ability to design and conduct experiments, collect data, analyze and interpret results to investigate complex engineering problems or discipline-specific research topics.
6) Ability to work effectively in intra-disciplinary and multi-disciplinary teams; ability to work individually.
7) Ability to communicate effectively in Turkish, both orally and in writing; Knowledge of at least one foreign language; the ability to write and understand written reports effectively, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions.
8) Awareness of the necessity of lifelong learning; the ability to access information, to follow developments in science and technology, and to constantly renew oneself.
9) Acting in accordance with ethical principles, professional and ethical responsibility awareness; information about standards used in engineering applications.
10) Information about business life practices such as project management, risk management and change management; awareness of entrepreneurship, innovation; information about sustainable development.
11) Knowledge about the universal and social effects of engineering applications on health, environment and safety and the problems of the age reflected in the field of engineering; awareness of the legal consequences of engineering solutions.

Ders - Öğrenme Kazanımı İlişkisi

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Program Outcomes	Level of Contribution
1)	Competent knowledge of mathematics, science and technology, and computer engineering; ability to apply this knowledge to engineering solutions.
2)	Skills to design and conduct experiments, collect data, analyze and interpret results.
3)	Ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; ability to apply modern design methods for this purpose.
4)	Ability to develop, select and use modern techniques and tools required for analysis and solution of complex problems encountered in engineering practice; ability to use information technologies effectively.
5)	Ability to design and conduct experiments, collect data, analyze and interpret results to investigate complex engineering problems or discipline-specific research topics.
6)	Ability to work effectively in intra-disciplinary and multi-disciplinary teams; ability to work individually.
7)	Ability to communicate effectively in Turkish, both orally and in writing; Knowledge of at least one foreign language; the ability to write and understand written reports effectively, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions.
8)	Awareness of the necessity of lifelong learning; the ability to access information, to follow developments in science and technology, and to constantly renew oneself.
9)	Acting in accordance with ethical principles, professional and ethical responsibility awareness; information about standards used in engineering applications.
10)	Information about business life practices such as project management, risk management and change management; awareness of entrepreneurship, innovation; information about sustainable development.
11)	Knowledge about the universal and social effects of engineering applications on health, environment and safety and the problems of the age reflected in the field of engineering; awareness of the legal consequences of engineering solutions.

Öğrenme Etkinliği ve Öğretme Yöntemleri

Ölçme ve Değerlendirme Yöntemleri ve Kriterleri

Assessment & Grading

Semester Requirements	Number of Activities	Level of Contribution
total		%
PERCENTAGE OF SEMESTER WORK		% 0
PERCENTAGE OF FINAL WORK		%
total		%