Course Name Code Semester T+U Hours Credit ECTS
Database Management Systems SWE 207 3 3 + 0 3 5
Precondition Courses
Recommended Optional Courses
Course Language English
Course Level Bachelor's Degree
Course Type Compulsory
Course Coordinator Dr.Öğr.Üyesi GÖZDE YOLCU ÖZTEL
Course Lecturers
Course Assistants
Course Category
Course Objective

In this information age, data management is a core activity for any organization. Accurate, relevant, and timely information is the key to good decision making and good decision making is the key to organizational survival. The main goal of this course is to teach the students how database management systems can be designed and managed.

Course Content

Database Systems, Data Models, Entity Relationship Model, Relational Database Model, Extended Entity Relationship Model, Relational Algebra, Structured Query Language (SQL), Advanced SQL, Normalization and Performance Tuning, SQL Programming, Database Security, Other Database Models

# Course Learning Outcomes Teaching Methods Assessment Methods
1 Learns database management systems Lecture, Question-Answer, Discussion, Testing, Project / Design,
2 Models by using entity relationship diagram Lecture, Question-Answer, Discussion, Drilland Practice, Project Based Learning, Testing, Homework, Project / Design,
3 Learn realtional database Lecture, Discussion, Drilland Practice, Project Based Learning, Testing, Homework, Project / Design,
4 Queries by using SQL Lecture, Discussion, Drilland Practice, Project Based Learning, Testing, Homework, Project / Design,
5 Learng performance optimization Lecture, Discussion, Drilland Practice, Testing,
6 Manages database management systems Lecture, Discussion, Drilland Practice, Project Based Learning, Testing, Project / Design,
Week Course Topics Preliminary Preparation
Resources
Course Notes
Course Resources

1. Carlos Coronel, Steven Morris, and Peter Rob, Database Systems: Design, Implementation, and Management, Cengage Learning.
2. http://www.postgresql.org/docs/manuals/
3. https://www.valentina-db.com/en/valentina-studio-overview
4. https://www.lucidchart.com/

Order Program Outcomes Level of Contribution
1 2 3 4 5
1 To have sufficient foundations on engineering subjects such as science and discrete mathematics, probability/statistics; an ability to use theoretical and applied knowledge of these subjects together for engineering solutions.
2 An ability to determine, describe, formulate and solve engineering problems; for this purpose, an ability to select and apply proper analytic and modeling methods,al background in describing, formulating, modeling and analyzing the engineering problem, with a consideration for appropriate analytical solutions in all necessary situations.
3 An ability to select and use modern techniques and tools for engineering applications; an ability to use information technologies efficiently.
4 An ability to analyze a system, a component or a process and design a system under real limits to meet desired needs; in this direction, an ability to apply modern design methods.
5 An ability to design, conduct experiment, collect data, analyze and comment on the results and consciousness of becoming a volunteer on research.
6 Understanding, awareness of administration, control, development and security/reliability issues about information technologies.
7 An ability to work efficiently in multidisciplinary teams, self confidence to take responsibility.
8 An ability to present himself/herself or a problem with oral/written techniques and have efficient communication skills; know at least one extra language.
9 An awareness about importance of lifelong learning; an ability to update his/her knowledge continuously by means of following advances in science and technology.
10 Understanding, practicing of professional and ethical responsibilities, an ability to disseminate this responsibility on society.
11 An understanding of project management, workplace applications, health issues of laborers, environment and job safety; an awareness about legal consequences of engineering applications.
12 An understanding universal and local effects of engineering solutions; awareness of entrepreneurial and innovation and to have knowledge about contemporary problems.
Evaluation System
Semester Studies Contribution Rate
Total 0
Total 0
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 14 3 42
Hours for off-the-classroom study (Pre-study, practice) 14 1 14
Mid-terms 1 10 10
Assignment 2 8 16
Project / Design 1 23 23
Final examination 1 15 15
Total Workload 120
Total Workload / 25 (Hours) 4.8
dersAKTSKredisi 5