Skip to content

Database Management

Çorlu Faculty of EngineeringComputer Engineering (E.P.)

Code
BMB207
Term
2026-2027 Fall Semester
Theory
3
Prac.-Lab
0-0
Credit
3
AKTS
5
Course type
Required
Level
Bachelor
Language
Turkish
Category
Basic vocational courses
Prerequisites (recommended)
-
Lecturer
Associate Professor Dr. AHMET SAYGILI

Course objective

Learning basic operations in database management systems and training students who can use different database systems.

Learning outcomes

  1. LO-1Ability to use SQL, DML, DDL, DCL languages effectively
  2. LO-2To be able to realize logical table designs in physical database environment (using SQL and database manager tools).
  3. LO-3Ensuring the transition from conceptual database design to logical table design.
  4. LO-4To be able to design a conceptual database (ER diagram) by analyzing a given business model.
  5. LO-5Learning basic database queries

Course content

General information about Database Management Systems. Components of Database Management Systems, Entity-Relationship data model and extended relationship data model, relationship data model and relationship algebra, SQL, Relational database design: normalization. Establishing the Database System, Structured Query Language (Simple Queries, Grouping Analysis, Complex Queries), Data Processing Language (Insert, Delete and Update data with Insert, Delete and Update statements), Data Definition Language (Creating, modifying and disappearing database objects to be).

Weekly topics

WeekTopicPreparation / method
1Basic information in DBMS
2Data Models, Entity-Relationship Model, Relationship Types, Key Types, Strong and Weak Entity Sets
3Conversion of Entity-Relationship Charts to DBMS
4Introduction to SQL, using SELECT statement (Creating Tables and Queries in Access)
5Multi-Table Queries
6DML and Complex Queries
7Normalization
8Midterm
9MS SQL Server
10Data Definition Language
11Introduction to TSQL
12User Management Operations in SQL Server
13MySQL Database Managament System
14Access to DBMS with Programming Languages
15Final Exam First Week
16Final Exam Second Week

Sources and materials

Lecture notes
Lecture note documents shared after the lesson
Other sources
1- Veri tabanı temelleri,Tamer Şahiner, Seçkin Yayıncılık
2- Veri tabanı Tasarımı İlişkisel Veri Modeli ve Uygulamaları, Dr. Ali Nizam, Papatya Yayıncılık
3- Veri tabanı Sistemleri Dersi, (Teoriden Pratiğe), Seçkin Yayıncılık, Gül Tokdemir, Nergiz Ercil Çağıltay
4- Veri Tabanı Sistemleri-, Kalıpsız Oya, Der Yayınevi, 2001.
5- Database System Concepts-, Silberschatz, Korth, Sudarshan, 4th Edition, McGraw Hill, 2002
Documents
Documents to be shared through the ADYS system
Assignments
Using the basic knowledge of the database taught in the course in various projects
Exams
It will be announced on the website at the beginning of the term.

Assessment

  • Ödev 1 %10
  • Arasınav 1 %30
  • Dönem Sonu Sınavı %60

Relation to programme outcomes

  1. PO-1A. Sufficient knowledge of subjects specific to mathematics, science and computer engineering discipline; the ability to use theoretical and applied knowledge in these areas to solve complex engineering problems specific to the computer engineering field.
  2. PO-2B. Ability to define, formulate and solve complex engineering problems related to the field of computer engineering; the ability to select and apply appropriate analysis and modeling methods for this purpose
  3. PO-3C. The ability to design a complex system, process or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for these purposes.
  4. PO-4D. Ability to select and use modern techniques and tools required for analysis and solution of complex problems encountered in computer engineering applications; the ability to use information technologies effectively.
  5. PO-5E. Ability to design experiments, conduct experiments, collect data, analyze and interpret results to investigate complex problems or discipline-specific research topics encountered in the field of computer engineering.
  6. PO-6F. Ability to work effectively as a team member in intra-disciplinary and multi-disciplinary teams, ability to work individually.
  7. PO-7G. Ability to communicate effectively in oral and written form; Knowledge of at least one foreign language; the 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. PO-8H. Awareness of the necessity of lifelong learning; the ability to access information, to follow developments in science and technology, and to constantly renew himself or herself.
  9. PO-9I. Information about compliance with ethical principles, professional and ethical responsibility and standards used in engineering practices.
  10. PO-10J. Information about business life practices such as project management, risk management and change management in the field of computer engineering; awareness of entrepreneurship, innovation; information about sustainable development.
  11. PO-11K. Information about global and social effects of computer engineering applications on health, environment and safety and current problems in engineering; awareness of the legal consequences of computer engineering solutions.
LO-1LO-2LO-3LO-4LO-5
PO-133333
PO-244444
PO-344444
PO-433333
PO-544444
PO-611111
PO-711111
PO-822222
PO-911111
PO-1011111
PO-1111111

ECTS workload

ActivityCountHoursTotal
Project Preparation and Presentation12828
Midterm Exam 212020
Final Exam13030
Out of class studying hours (prestudy, reinforcement)14228
Course duration(including the exam week: total course hours)16348
Total workload154
Total workload / 305
ECTS credit5
Course form Open in new tab