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
- LO-1Ability to use SQL, DML, DDL, DCL languages effectively
- LO-2To be able to realize logical table designs in physical database environment (using SQL and database manager tools).
- LO-3Ensuring the transition from conceptual database design to logical table design.
- LO-4To be able to design a conceptual database (ER diagram) by analyzing a given business model.
- 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
| Week | Topic | Preparation / method |
|---|---|---|
| 1 | Basic information in DBMS | |
| 2 | Data Models, Entity-Relationship Model, Relationship Types, Key Types, Strong and Weak Entity Sets | |
| 3 | Conversion of Entity-Relationship Charts to DBMS | |
| 4 | Introduction to SQL, using SELECT statement (Creating Tables and Queries in Access) | |
| 5 | Multi-Table Queries | |
| 6 | DML and Complex Queries | |
| 7 | Normalization | |
| 8 | Midterm | |
| 9 | MS SQL Server | |
| 10 | Data Definition Language | |
| 11 | Introduction to TSQL | |
| 12 | User Management Operations in SQL Server | |
| 13 | MySQL Database Managament System | |
| 14 | Access to DBMS with Programming Languages | |
| 15 | Final Exam First Week | |
| 16 | Final 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
- 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.
- 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
- 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.
- 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.
- 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.
- PO-6F. Ability to work effectively as a team member in intra-disciplinary and multi-disciplinary teams, ability to work individually.
- 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.
- 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.
- PO-9I. Information about compliance with ethical principles, professional and ethical responsibility and standards used in engineering practices.
- 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.
- 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-1 | LO-2 | LO-3 | LO-4 | LO-5 | |
|---|---|---|---|---|---|
| PO-1 | 3 | 3 | 3 | 3 | 3 |
| PO-2 | 4 | 4 | 4 | 4 | 4 |
| PO-3 | 4 | 4 | 4 | 4 | 4 |
| PO-4 | 3 | 3 | 3 | 3 | 3 |
| PO-5 | 4 | 4 | 4 | 4 | 4 |
| PO-6 | 1 | 1 | 1 | 1 | 1 |
| PO-7 | 1 | 1 | 1 | 1 | 1 |
| PO-8 | 2 | 2 | 2 | 2 | 2 |
| PO-9 | 1 | 1 | 1 | 1 | 1 |
| PO-10 | 1 | 1 | 1 | 1 | 1 |
| PO-11 | 1 | 1 | 1 | 1 | 1 |
ECTS workload
| Activity | Count | Hours | Total |
|---|---|---|---|
| Project Preparation and Presentation | 1 | 28 | 28 |
| Midterm Exam 2 | 1 | 20 | 20 |
| Final Exam | 1 | 30 | 30 |
| Out of class studying hours (prestudy, reinforcement) | 14 | 2 | 28 |
| Course duration(including the exam week: total course hours) | 16 | 3 | 48 |
| Total workload | 154 | ||
| Total workload / 30 | 5 | ||
| ECTS credit | 5 | ||