BPP114 Database-I

3 ECTS - 2-1 Duration (T+A)- 2. Semester- 2.5 National Credit

Information

Code BPP114
Name Database-I
Term 2024-2025 Academic Year
Semester 2. Semester
Duration (T+A) 2-1 (T-A) (17 Week)
ECTS 3 ECTS
National Credit 2.5 National Credit
Teaching Language Türkçe
Level Ön Lisans Dersi
Type Normal
Mode of study Uzaktan Öğretim
Catalog Information Coordinator Doç. Dr. MESUT ÖZONUR
Course Instructor
1 2
Doç. Dr. MESUT ÖZONUR (A Group) (Ins. in Charge)


Course Goal / Objective

The aim of this course is to develop databases, database design logic, database management system application program (MS Access) visual interface to design, create, query and use administrative functions of relational databases.

Course Content

Database and Database Managemet Systems, Database Objects, Features of Database Field, Tables, Queries, Forms, Reports, Macros, Modules

Course Precondition

NA

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) Database Management Systems 1 Lecture Notes


Course Learning Outcomes

Order Course Learning Outcomes
LO01 Explains the basics of database.
LO02 Understands the importance of database in programming.
LO03 Makes database applications.
LO04 Manages database applications.
LO05 Designs database applications on different subjects.
LO06 It does all kinds of data operations in the database.


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Yetkinlikler - İletişim ve Sosyal Yetkinlik ommunicates effectively with all partners on a sectoral basis.
PLO02 Bilgi - Kuramsal, Olgusal has the basic knowledge necessary to develop computer software, to establish algorithm, sequential and simultaneous flow logic 2
PLO03 Yetkinlikler - Alana Özgü Yetkinlik Designs systems for fundamental problems in microcontrollers, embedded systems and analog/digital electronics.
PLO04 Yetkinlikler - Alana Özgü Yetkinlik Uses basic software related to information and communication technologies, specific to his profession. 2
PLO05 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği Applies the software and hardware developments in the field of Computer Programming independently. 2
PLO06 Bilgi - Kuramsal, Olgusal Explains the necessary methods for solving well-defined problems in the field of Computer Technologies and Programming.
PLO07 Bilgi - Kuramsal, Olgusal Has the basic knowledge level required to develop software specific to web, mobile and other electronic platforms.
PLO08 Beceriler - Bilişsel, Uygulamalı Develops software for desktop and other environments.
PLO09 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği Takes an active role in project development processes, independently or as part of a group, within a planned project. 2
PLO10 Bilgi - Kuramsal, Olgusal Knows project planning, development and implementation processes.
PLO11 Yetkinlikler - Alana Özgü Yetkinlik Performs data storage, editing, querying, etc. operations in computer and network environment. 5
PLO12 Yetkinlikler - Alana Özgü Yetkinlik It has the ability to solve unpredictable hardware and software problems.
PLO13 Beceriler - Bilişsel, Uygulamalı Codes software components that have been analyzed and the algorithm has been prepared.
PLO14 Bilgi - Kuramsal, Olgusal Knows the methods to be used in software development.
PLO15 Yetkinlikler - Öğrenme Yetkinliği Constantly follows current innovations and developments in the field of information technologies. 2
PLO16 Yetkinlikler - İletişim ve Sosyal Yetkinlik Communicates verbally and in writing in a foreign language.
PLO17 Yetkinlikler - İletişim ve Sosyal Yetkinlik It has the phenomenon of the necessity of moral and ethical behaviors related to the information technology profession.
PLO18 Yetkinlikler - Alana Özgü Yetkinlik Has the necessary awareness of occupational safety in her field.
PLO19 Beceriler - Bilişsel, Uygulamalı It uses operating systems with administrative features.
PLO20 Bilgi - Kuramsal, Olgusal Has basic knowledge of entrepreneurship.


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 2 28
Assesment Related Works
Homeworks, Projects, Others 1 2 2
Mid-term Exams (Written, Oral, etc.) 1 5 5
Final Exam 1 10 10
Total Workload (Hour) 87
Total Workload / 25 (h) 3,48
ECTS 3 ECTS

Update Time: 16.05.2024 12:19