BBZ204 Database Management Systems

6 ECTS - 3-1 Duration (T+A)- 4. Semester- 3 National Credit

Information

Code BBZ204
Name Database Management Systems
Term 2024-2025 Academic Year
Semester 4. Semester
Duration (T+A) 3-1 (T-A) (17 Week)
ECTS 6 ECTS
National Credit 3 National Credit
Teaching Language Türkçe
Level Belirsiz
Type Normal
Mode of study Yüz Yüze Öğretim
Catalog Information Coordinator Öğr. Gör. ERKAN KAYNAK
Course Instructor
1


Course Goal / Objective

The aim of this course is the development of databases, database design logic, designing, creating and querying relational databases using the visual interface of the database management system application program (MS Access), and the use of administrative functions.

Course Content

In this course, database and database management systems, database objects, database field properties, tables, queries, forms, reports, macros, modules are covered.

Course Precondition

None

Resources

Hendrick, T. (2022) Microsoft Access 2022: Complete Beginner to Expert Guide That Teaches Everything You Need to Know About Microsoft Access 2022 Including Tips - Tricks on Data Management

Notes

Özonur, M. (2005) Veritabanı Yönetim Sistemleri 1 Ders Notu


Course Learning Outcomes

Order Course Learning Outcomes
LO01 Explains database basics.
LO02 Understands the importance of database in programming.
LO03 It performs basic operations on the database.
LO04 Explains database object properties in detail.
LO05 Designs database objects.
LO06 It performs all kinds of data operations in the database.
LO07 Veritabanı ihtiyaçlarını analiz edebilir.
LO08 Tablo oluşturur ve özelliklerini belirler.


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Bilgi - Kuramsal, Olgusal Gain comprehensive knowledge of fundamental concepts, algorithms, and data structures in Computer Science. 4
PLO02 Bilgi - Kuramsal, Olgusal Learn essential computer topics such as software development, programming languages, and database management 4
PLO03 Bilgi - Kuramsal, Olgusal Understand advanced computer fields like data science, artificial intelligence, and machine learning. 3
PLO04 Bilgi - Kuramsal, Olgusal Acquire knowledge of topics like computer networks, cybersecurity, and database design. 3
PLO05 Beceriler - Bilişsel, Uygulamalı Develop skills in designing, implementing, and analyzing algorithms 4
PLO06 Beceriler - Bilişsel, Uygulamalı Gain proficiency in using various programming languages effectively
PLO07 Beceriler - Bilişsel, Uygulamalı Learn skills in data analysis, database management, and processing large datasets. 4
PLO08 Beceriler - Bilişsel, Uygulamalı Acquire practical experience through working on software development projects. 3
PLO09 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği Strengthen teamwork and communication skills.
PLO10 Yetkinlikler - Alana Özgü Yetkinlik Foster a mindset open to technological innovations. 2
PLO11 Yetkinlikler - Öğrenme Yetkinliği Encourage the capacity for continuous learning and self-improvement.
PLO12 Yetkinlikler - İletişim ve Sosyal Yetkinlik Enhance the ability to solve complex problems


Week Plan

Week Topic Preparation Methods
1 Database and Database Management Systems Examining the course information package. Öğretim Yöntemleri:
Anlatım, Soru-Cevap
2 Database Objects Reading and understanding of the issues before the course. Öğretim Yöntemleri:
Anlatım, Soru-Cevap
3 Database Field Properties Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
4 Tables - General Tab Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
5 Tables - Lookup Tab Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
6 Queries Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
7 Forms - Properties Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
8 Mid-Term Exam Studying the subjects by practice. Ölçme Yöntemleri:
Yazılı Sınav
9 Forms - Controls Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
10 Forms - Wizards Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
11 Reports - Sections Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
12 Reports - Main/Sub Report Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
13 Reports - Creating Graphic-Label Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
14 Macros Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
15 Modules Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
16 Term Exams Studying the subjects by practice. Ölçme Yöntemleri:
Yazılı Sınav
17 Term Exams Studying the subjects by practice. Ölçme Yöntemleri:
Yazılı Sınav


Student Workload - ECTS

Works Number Time (Hour) Workload (Hour)
Course Related Works
Class Time (Exam weeks are excluded) 14 3 42
Out of Class Study (Preliminary Work, Practice) 14 5 70
Assesment Related Works
Homeworks, Projects, Others 0 0 0
Mid-term Exams (Written, Oral, etc.) 1 14 14
Final Exam 1 24 24
Total Workload (Hour) 150
Total Workload / 25 (h) 6,00
ECTS 6 ECTS

Update Time: 08.06.2024 11:38