Computer Engineering (English) Preview
Bachelor	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF-LLL: Level 6

Course Introduction and Application Information

Course Code:

COE307

Course Name:

Database Management Systems

Semester:

Fall

Course Credits:

ECTS

Language of instruction:

English

Course Condition:

Does the Course Require Work Experience?:

Type of course:

Compulsory Courses

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:

Doç. Dr. BAHMAN ARASTEH ABBASABAD

Course Lecturer(s):

Doç. Dr. Bahman Arasteh

Course Assistants:

Course Objective and Content

Course Objectives:

Design and implement a basic database system using a database management system (DBMS).
Create entity-relationship (ER) diagrams to represent data entities and their relationships.
Apply normalization techniques to ensure data integrity and reduce redundancy in a database.
Write SQL queries to retrieve and manipulate data from a database.
Manage transactions and ensure data consistency using SQL.
Optimize queries and improve the performance of a database using indexing and query optimization techniques.

Course Content:

This course covers the fundamental concepts and skills needed to manage data effectively using a database management system (DBMS). Students will learn about the entity-relationship (ER) model, relational model and data definition language, functional dependencies, SQL, transactions, concurrency control, file and disk management, recovery systems, indexing, and query processing and optimization. They will also learn about database normalization, indexing, and query optimization techniques to improve the performance of the databases.

Learning Outcomes

The students who have succeeded in this course;
1) Can apply database concepts, entities, tables and fields
2) Can model the data and design structural database
3) Can design and implement efficient queries using SQL
4) Can evaluate and improve the database security and can make the connection with the software application
5) Can normalize the database and improve database performance

Course Flow Plan

Week	Subject	Related Preparation
1)	Introduction to databases
2)	Relational Data Model - Relational Model
3)	Relational Data Model - Relational algebra
4)	Database design-ER Data Model
5)	Database design-ER Data Model
6)	SQL-Data definition language, Data Manipulation language
7)	SQL- Query language - Set operations
8)	Midterm Exam
9)	SQL-Subqueries- Set element test, Set comparison, Empty set test
10)	SQL-Grouping
11)	SQL-Constraints:Data-type,primary-key,second-key,not-null,column-constraints
12)	SQL-Stored procedures/functions
13)	Normalization
14)	Query optimization

Sources

Course Notes / Textbooks:	Database System Concepts" by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan
References:	ders notları

Course - Program Learning Outcome Relationship

Course Learning Outcomes	1	2	3	4	5
Program Outcomes
1) Adequate knowledge in mathematics, science, and computer engineering principles, both theoretical and practical, and the ability to apply this knowledge to complex engineering problems.
2) Ability to identify, formulate, and solve complex computer engineering problems using appropriate analysis and modeling techniques.	2	2
3) Ability to design and develop complex computer systems, devices, or products that meet specific requirements and operate under realistic constraints and conditions, using modern design methods.			2	2
4) Ability to develop, select and use modern techniques and tools used for the analysis and solution of complex computer engineering problems, and the ability to use information technologies effectively.		2	2	3	3
5) Ability to plan and conduct experiments, collect and analyze data, and interpret results in the study of complex computer engineering problems or research topics.
6) Ability to work effectively within and multidisciplinary teams; individual study skills.
7) Ability to communicate effectively orally and in writing; knowledge of at least one foreign language; ability to write effective reports and understand written reports, 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; ability to access information, to follow developments in science and technology and to renew continuously.
9) To act in accordance with ethical principles, professional and ethical responsibility; information on the standards used in engineering applications.
10) Information on business practices such as project management, risk management and change management; awareness of entrepreneurship and innovation; information about sustainable development.
11) Knowledge of the effects of computer engineering practices on health, environment and safety in the universal and social scale and the problems of the era reflected in computer engineering; awareness of the legal consequences of computer engineering solutions.

Course - Learning Outcome Relationship

No Effect	1 Lowest	2 Average	3 Highest

	Program Outcomes	Level of Contribution
1)	Adequate knowledge in mathematics, science, and computer engineering principles, both theoretical and practical, and the ability to apply this knowledge to complex engineering problems.
2)	Ability to identify, formulate, and solve complex computer engineering problems using appropriate analysis and modeling techniques.	2
3)	Ability to design and develop complex computer systems, devices, or products that meet specific requirements and operate under realistic constraints and conditions, using modern design methods.	2
4)	Ability to develop, select and use modern techniques and tools used for the analysis and solution of complex computer engineering problems, and the ability to use information technologies effectively.	3
5)	Ability to plan and conduct experiments, collect and analyze data, and interpret results in the study of complex computer engineering problems or research topics.
6)	Ability to work effectively within and multidisciplinary teams; individual study skills.
7)	Ability to communicate effectively orally and in writing; knowledge of at least one foreign language; ability to write effective reports and understand written reports, 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; ability to access information, to follow developments in science and technology and to renew continuously.
9)	To act in accordance with ethical principles, professional and ethical responsibility; information on the standards used in engineering applications.
10)	Information on business practices such as project management, risk management and change management; awareness of entrepreneurship and innovation; information about sustainable development.
11)	Knowledge of the effects of computer engineering practices on health, environment and safety in the universal and social scale and the problems of the era reflected in computer engineering; awareness of the legal consequences of computer engineering solutions.

Assessment & Grading

Semester Requirements	Number of Activities	Level of Contribution
Homework Assignments	1	% 15
Midterms	1	% 30
Final	1	% 55
total		% 100
PERCENTAGE OF SEMESTER WORK		% 45
PERCENTAGE OF FINAL WORK		% 55
total		% 100

Workload and ECTS Credit Calculation

Activities	Number of Activities	Workload
Course Hours	14	42
Application	14	28
Study Hours Out of Class	14	42
Midterms	1	20
Final	1	20
Total Workload		152