BLP257 Database -II

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

Information

Code BLP257
Name Database -II
Term 2024-2025 Academic Year
Semester 3. Semester
Duration (T+A) 2-1 (T-A) (17 Week)
ECTS 4 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 Öğr. Gör. BERİN YENİ (A Group) (Ins. in Charge)


Course Goal / Objective

To give the development and basic concepts of database, and database design logic, to have the ability to create database using database management system application program (SQL Server) SQL (Structural Query Language), to process and query ability.

Course Content

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

Course Precondition

The student must have taken the Database -I Course

Resources

Veritabanı Mantığı - Kerem Köseoğlu Veritabanı Yönetim Sistemleri 2 - Turgut Özseven

Notes

MEGEP


Course Learning Outcomes

Order Course Learning Outcomes
LO01 Defines/explains basic concepts about database.
LO02 Defines/explains database design processes (spread sheet, normalization, association etc).
LO03 Installs and uses necessary platforms for database management as appropriate to their purpose.
LO04 Data manipulation and query by using SQL language.
LO05 Makes necessary query works on database with structural query language (SQL) as appropriate to their purpose.
LO06 Defines/explains database management (back up, safety etc.) processes.


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 2
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
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.
PLO06 Bilgi - Kuramsal, Olgusal Evaluates and supervises the performances of the employees under their responsibility
PLO07 Bilgi - Kuramsal, Olgusal Detects software and simple hardware failures in the computer and solves problems that do not require expertise 4
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 3
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 4
PLO17 Yetkinlikler - Öğrenme Yetkinliği Takes part in software, hardware and network discoveries


Week Plan

Week Topic Preparation Methods
1 Introduction to Database Systems. Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Deney / Laboratuvar
2 Normalization, Entity-Relationship Data Modeling, ER Diagrams and Sample Application. Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Gösteri, Örnek Olay
3 Introduction to SQL Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama, Örnek Olay, Problem Çözme
4 Data types, field properties, Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama, Gösteri, Gösterip Yaptırma
5 SQL Structured Query Language, SELECT statement Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Örnek Olay, Problem Çözme
6 SQL Structured Query Language, SELECT statement-continue Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Gösterip Yaptırma, Deney / Laboratuvar
7 UNION and JOIN operations Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Alıştırma ve Uygulama, Gösterip Yaptırma, Deney / Laboratuvar
8 Mid-Term Exam Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Deney / Laboratuvar, Bireysel Çalışma, Problem Çözme
9 Application Repetition and Midterm Exam Öğretim Yöntemleri:
Anlatım
10 CREATE TABLE, INSERT INTO, UPDATE statements Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Benzetim, Bireysel Çalışma, Problem Çözme
11 DELETE, DROP statements Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Gösteri, Benzetim, Problem Çözme
12 Make the calculation of the areas of SQL. Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Örnek Olay, Deney / Laboratuvar, Problem Çözme
13 Make the calculation of the areas of SQL. Select, update, delete, insert, cross-queries. Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Tartışma, Örnek Olay
14 Functions Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösteri, Gösterip Yaptırma, Örnek Olay, Deney / Laboratuvar, Problem Çözme
15 Trigger Object and applications. Developing sample application the computer lab Öğretim Yöntemleri:
Anlatım, Benzetim, Örnek Olay
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 7 7
Final Exam 1 18 18
Total Workload (Hour) 111
Total Workload / 25 (h) 4,44
ECTS 4 ECTS

Update Time: 06.05.2024 07:33