BLP152 Database -I

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

Information

Code BLP152
Name Database -I
Term 2024-2025 Academic Year
Semester 2. Semester
Duration (T+A) 2-1 (T-A) (17 Week)
ECTS 5 ECTS
National Credit 2.5 National Credit
Teaching Language Türkçe
Level Ön Lisans Dersi
Type Normal
Mode of study Yüz Yüze Öğretim
Catalog Information Coordinator Öğr. Gör. BERİN YENİ
Course Instructor
1 2
Öğr. Gör. BERİN YENİ (A Group) (Ins. in Charge)


Course Goal / Objective

To give students ability to design and create database, make queries and use databse management functions.

Course Content

Basic properties of classic file system, advantages and disadvantages, general structure and properties of database systems

Course Precondition

None

Resources

Microsoft Acces 2016, Osman Gürkan, Nirvana Yayınları

Notes

MEGEP Ders notları


Course Learning Outcomes

Order Course Learning Outcomes
LO01 Explain the concepts of data and database
LO02 Illustrate and use relational model concepts
LO03 Uses Microsoft Access
LO04 Prepares query with related tables
LO05 Can creates Form and Report
LO06 To list the rules and constraints of normal forms.
LO07 Changing the properties of objects and forms.
LO08 Creating and using the type of query.


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Bilgi - Kuramsal, Olgusal Takes part in planning related to computer software and hardware 3
PLO02 Bilgi - Kuramsal, Olgusal Students will be able to define, collect and use the data necessary for the solution of well-defined problems in Computer Technologies and Programming. demonstrate that he / she can use the theoretical knowledge, knowledge and skills required in practical applications 3
PLO03 Bilgi - Kuramsal, Olgusal Word processor, spreadsheet, presentation, database and installs and uses various software 4
PLO04 Bilgi - Kuramsal, Olgusal Makes coding, internet and network makes the installation of devices
PLO05 Bilgi - Kuramsal, Olgusal Have sufficient knowledge of Turkish and foreign languages. 3
PLO06 Bilgi - Kuramsal, Olgusal Evaluates and supervises the performances of the employees under their responsibility 3
PLO07 Bilgi - Kuramsal, Olgusal Detects software and simple hardware failures in the computer and solves problems that do not require expertise
PLO08 Bilgi - Kuramsal, Olgusal Use appropriate techniques with verbal, numerical and graphical expression
PLO09 Bilgi - Kuramsal, Olgusal Creates computer technology related design and applications with team work and presents to related people and institutions 4
PLO10 Bilgi - Kuramsal, Olgusal Gain analytical and numerical thinking skills and contribute to national economy by using knowledge and skills related to the field in accordance with regulations
PLO11 Bilgi - Kuramsal, Olgusal Provides professional connections in the public and private sector business areas and uses appropriate tools in the social and professional field in the decision-making process
PLO12 Beceriler - Bilişsel, Uygulamalı Conduct research using the Internet and various communication technologies
PLO13 Beceriler - Bilişsel, Uygulamalı Demonstrate the ability to learn and learn independently in the field of Computer Technologies and Programming
PLO14 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği Conducts teamwork in accordance with the basic concepts of human relations and entrepreneurship
PLO15 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği Have knowledge about Atatürk's Principles and Revolution History
PLO16 Yetkinlikler - Öğrenme Yetkinliği Demonstrate the ability to identify problems and find solutions to unforeseen situations in work in the field of Computer Technologies
PLO17 Yetkinlikler - Öğrenme Yetkinliği Takes part in software, hardware and network discoveries


Week Plan

Week Topic Preparation Methods
1 Basic properties of classic file system, advantages and disadvantages, general structure and properties of database systems Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Gösteri, Benzetim, Örnek Olay
2 Entry into the database, database and data modeling, DBMS types and concepts Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Benzetim, Problem Çözme
3 E-R model, the presence of a set of assets, attributes, relations concepts, relationship types Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösteri, Örnek Olay
4 Relational database Developing sample application the computer lab Öğretim Yöntemleri:
Soru-Cevap, Benzetim, Problem Çözme
5 Key areas, foreign key, descriptive qualities, to be converted to the correlation table Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Örnek Olay, Problem Çözme
6 Creating tables in MS Access application, field types, relationship identification, reporting, Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Tartışma, Alıştırma ve Uygulama, Benzetim, Örnek Olay, Problem Çözme
7 Creating query in MS Access application, Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama, Problem Çözme
8 Mid-Term Exam Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Bireysel Çalışma, Problem Çözme
9 Repetition and Midterm Exam Repetition and Midterm Exam Ölçme Yöntemleri:
Yazılı Sınav
10 Database objects Developing sample application the computer labDeveloping sample application the computer lab Öğretim Yöntemleri:
Anlatım, Örnek Olay
11 Data analysis and multiple tables Developing sample application the computer labDeveloping sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Tartışma, Örnek Olay, Problem Çözme
12 Prepare a query with related tables Developing sample application the computer labDeveloping sample application the computer lab Öğretim Yöntemleri:
Soru-Cevap, Alıştırma ve Uygulama, Benzetim, Problem Çözme
13 Form appliation Developing sample application the computer labDeveloping sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösteri, Problem Çözme
14 Operations on Forms Developing sample application the computer labDeveloping sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Alıştırma ve Uygulama, Örnek Olay
15 User access and control Developing sample application the computer labDeveloping sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Alıştırma ve Uygulama
16 Term Exams Repetition and Final Exam Ölçme Yöntemleri:
Yazılı Sınav
17 Term Exams Repetition and Final Exam Ö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 3 42
Assesment Related Works
Homeworks, Projects, Others 1 2 2
Mid-term Exams (Written, Oral, etc.) 1 12 12
Final Exam 1 18 18
Total Workload (Hour) 116
Total Workload / 25 (h) 4,64
ECTS 5 ECTS

Update Time: 06.05.2024 07:32