BPP219 Database-II

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

Information

Code BPP219
Name Database-II
Term 2024-2025 Academic Year
Semester 3. 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 Yüz Yüze Öğretim
Catalog Information Coordinator Doç. Dr. MESUT ÖZONUR
Course Instructor Doç. Dr. MESUT ÖZONUR (A Group) (Ins. in Charge)
Doç. Dr. MESUT ÖZONUR (B Group) (Ins. in Charge)


Course Goal / Objective

In this course, it is aimed to design, create and query relational databases, to use database administrative functions, to understand client/server database logic and to design client/server database.

Course Content

Basic concepts, Entity-Relationship Model, Relational Database, Normalization, Relational Algebra, SQL, Basic SQL Transactions, Basic SQL Functions, SQL Multiline Function, Simple Joining the Table, Other Joining the Table, Sub Queries, Data Manuplation Language, Database Objects.

Course Precondition

NA

Resources

Beaulieu, A. (2009), Learning SQL: Master SQL Fundamentals

Notes

Özonur, M. (2005) Database Management Systems 2 Lecture Notes


Course Learning Outcomes

Order Course Learning Outcomes
LO01 Understands the basics of client/server database.
LO02 Recognizes client / server database language.
LO03 Explains the concepts of relational algebra and normalization.
LO04 It makes applications using client/server-enabled database language.
LO05 Uses any database application program.
LO06 Designs client / server database applications in different subjects.


Relation with Program Learning Outcome

Order Type Program Learning Outcomes Level
PLO01 Yetkinlikler - İletişim ve Sosyal Yetkinlik Communicates 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 3
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.
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 Have basic knowledge about entrepreneurship, career management and lifelong learning.
PLO21 Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği Has environmental awareness, environmental sensitivity, basic knowledge about waste storage and safety.


Week Plan

Week Topic Preparation Methods
1 Basic concepts Examining the course information package. Öğretim Yöntemleri:
Anlatım, Soru-Cevap
2 Entity-Relationship Model Reading and understanding the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Alıştırma ve Uygulama
3 Relational Database Reading and understanding the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Alıştırma ve Uygulama
4 Normalization Reading and understanding the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Alıştırma ve Uygulama
5 Relational Algebra Reading and understanding the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Alıştırma ve Uygulama
6 SQL - Structured Query Language Reading and understanding the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap
7 Basic SQL Transactions 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 Basic SQL Functions Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
10 SQL Multiline Function Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
11 Simple Joining the Table Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
12 Other Joining the Table Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
13 Sub Queries Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
14 Data Manuplation Language Reading and practicing the subject before the lesson. Öğretim Yöntemleri:
Anlatım, Soru-Cevap, Gösterip Yaptırma
15 Database Objects 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 0 0 0
Mid-term Exams (Written, Oral, etc.) 1 5 5
Final Exam 1 10 10
Total Workload (Hour) 85
Total Workload / 25 (h) 3,40
ECTS 3 ECTS

Update Time: 06.05.2024 02:34