GASTRONOMY AND CULINARY ARTS
Bachelor	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF-LLL: Level 6

Ders Genel Tanıtım Bilgileri

Course Code:

SEN2104

Ders İsmi:

Database Management Systems

Ders Yarıyılı:

Spring
Fall

Ders Kredileri:

Theoretical	Practical	Credit	ECTS
3	2	4	7

Language of instruction:

English

Ders Koşulu:

Ders İş Deneyimini Gerektiriyor mu?:

Type of course:

Non-Departmental Elective

Course Level:

Bachelor

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

QF-EHEA:First Cycle

EQF-LLL:6. Master`s Degree

Mode of Delivery:

Hybrid

Course Coordinator :

Dr. Öğr. Üyesi TAMER UÇAR

Course Lecturer(s):

Course Assistants:

Dersin Amaç ve İçeriği

Course Objectives:

The students will have the ability to analyze and design databases using the entity-relationship model. They will have the ability to define database querying techniques such as relational algebra and SQL. Besides these topics, the students will have the ability to identify relational database design approaches, indexing, query processing, and query optimization. Students will be able to define basic data analysis and data mining concepts.

Course Content:

The course content is composed of entity-relationship model, relational data model, relational algebra, SQL, relational database design, indexing, query processing, query optimization, data analysis and data mining related topics.

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
2)	Entity-Relationship Model
3)	Introduction to Relational Data Model
4)	Relational Algebra
5)	Relational Algebra
6)	Applying Relational Algebra Principles to Database Design and Practice
7)	Structured Query Language (SQL)
8)	Structured Query Language (SQL)
9)	Relational Database Design
10)	Relational Database Design
11)	Relational Database Design
12)	Indexing and Query Processing
13)	Query Processing and Query Optimization
14)	Data Analysis and Data Mining

Sources

Course Notes / Textbooks:	Database System Concepts (6th Edition), Abraham Silberschatz, Henry Korth and S. Sudarshan, ISBN-13: 978-0073523323 Fundamentals of Database Systems (7th Edition), Ramez Elmasri and Shamkant Navathe, ISBN-13: 978-0133970777
References:	-

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

Ders Öğrenme Kazanımları
Program Outcomes
1) - Possess advanced level theoretical and practical knowledge supported by textbooks with updated information, practice equipments and other resources.
2) Use of advanced theoretical and practical knowledge within the field. -Interpret and evaluate data, define and analyze problems, develop solutions based on research and proofs by using acquired advanced knowledge and skills within the field.
3) Inform people and institutions, transfer ideas and solution proposals to problems in written and orally on issues in the field. - Share the ideas and solution proposals to problems on issues in the field with professionals and non-professionals by the support of qualitative and quantitative data. -Organize and implement project and activities for social environment with a sense of social responsibility. -Monitor the developments in the field and communicate with peers by using a foreign language at least at a level of European Language Portfolio B1 General Level. -Use informatics and communication technologies with at least a minimum level of European Computer Driving License Advanced Level software knowledge.
4) Evaluate the knowledge and skills acquired at an advanced level in the field with a critical approach. -Determine learning needs and direct the learning. -Develop positive attitude towards lifelong learning.
5) Act in accordance with social, scientific, cultural and ethic values on the stages of gathering, implementation and release of the results of data related to the field. - Possess sufficient consciousness about the issues of universality of social rights, social justice, quality, cultural values and also, environmental protection, worker's health and security.
6) Conduct studies at an advanced level in the field independently. - Take responsibility both as a team member and individually in order to solve unexpected complex problems faced within the implementations in the field. - Planning and managing activities towards the development of subordinates in the framework of a project

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

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

	Program Outcomes	Level of Contribution
1)	- Possess advanced level theoretical and practical knowledge supported by textbooks with updated information, practice equipments and other resources.	2
2)	Use of advanced theoretical and practical knowledge within the field. -Interpret and evaluate data, define and analyze problems, develop solutions based on research and proofs by using acquired advanced knowledge and skills within the field.	4
3)	Inform people and institutions, transfer ideas and solution proposals to problems in written and orally on issues in the field. - Share the ideas and solution proposals to problems on issues in the field with professionals and non-professionals by the support of qualitative and quantitative data. -Organize and implement project and activities for social environment with a sense of social responsibility. -Monitor the developments in the field and communicate with peers by using a foreign language at least at a level of European Language Portfolio B1 General Level. -Use informatics and communication technologies with at least a minimum level of European Computer Driving License Advanced Level software knowledge.	5
4)	Evaluate the knowledge and skills acquired at an advanced level in the field with a critical approach. -Determine learning needs and direct the learning. -Develop positive attitude towards lifelong learning.	3
5)	Act in accordance with social, scientific, cultural and ethic values on the stages of gathering, implementation and release of the results of data related to the field. - Possess sufficient consciousness about the issues of universality of social rights, social justice, quality, cultural values and also, environmental protection, worker's health and security.	3
6)	Conduct studies at an advanced level in the field independently. - Take responsibility both as a team member and individually in order to solve unexpected complex problems faced within the implementations in the field. - Planning and managing activities towards the development of subordinates in the framework of a project	3

Öğ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
Quizzes	3	% 20
Project	1	% 15
Midterms	1	% 25
Final	1	% 40
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 60
PERCENTAGE OF FINAL WORK		% 40
Total		% 100