TÜRKÇE
ENGLISH
Information
| Code | BLP257 |
| Name | Database -II |
| Term | 2023-2024 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 | ||