TÜRKÇE
ENGLISH
Information
| Code | BPP222 |
| Name | DATA BASE II |
| Term | 2022-2023 Academic Year |
| Semester | 4. Semester |
| Duration (T+A) | 3-1 (T-A) (17 Week) |
| ECTS | 4 ECTS |
| National Credit | 3.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. Ömer Tuğrul KURDOĞLU |
| Course Instructor |
Öğr. Gör. Alişan AKTAY
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
The client / server discusses database logic and discusses client / server features.
Course Content
Basic concepts, Entity-Relationship Model, Relational Database, Normalization, Relational Algebra, SQL, Basic SQL Transactions, Basic SQL Functions, SQL Multiline Function, Tables and properties in data bases
Course Precondition
None
Resources
Instructor Lecture Notes
Notes
All resources prepared for the course.
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Have knowledge of client / server-enabled database basics. |
| LO02 | Can use any database application program |
| LO03 | Knows different databases. |
| LO04 | Sql Server also uses the commands used. |
| LO05 | Creates, associates and implements Sql commands in the database. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | explains the basic and scientific concepts related to computer technologies. | 4 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Explains the hardware structures and the functions and functions of the electronic circuit elements that make up these hardware structures | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Uses basic concepts in the field of computer technologies and Office programs and various package programs | 4 |
| PLO04 | Bilgi - Kuramsal, Olgusal | He/She has the ability to apply and solve problems in the field of computer programming by developing algorithms with software languages and utilities. | |
| PLO05 | Bilgi - Kuramsal, Olgusal | Explain the basic concepts of computer hardware structures, make simple software installations and various hardware configurations, | |
| PLO06 | Bilgi - Kuramsal, Olgusal | designs basic database systems and database programs. | 5 |
| PLO07 | Bilgi - Kuramsal, Olgusal | Uses basic graphic and animation programs used to design interfaces on web pages | 3 |
| PLO08 | Bilgi - Kuramsal, Olgusal | Explains and designs network systems, their types and makes simple installation examples. | |
| PLO09 | Bilgi - Kuramsal, Olgusal | Knows and uses internet technologies and develops server-side internet applications. | 3 |
| PLO10 | Bilgi - Kuramsal, Olgusal | Knows various computer programming languages (Delphi, Visual Basic, C++ etc.). | 3 |
| PLO11 | Bilgi - Kuramsal, Olgusal | He/she can carry out and conclude a basic study related to his/her field independently or in disciplined teams | 4 |
| PLO12 | Bilgi - Kuramsal, Olgusal | Perceives and uses new technologies in the field with the necessity of lifelong learning | |
| PLO13 | Bilgi - Kuramsal, Olgusal | He/She knows a foreign language (professional foreign language) at A2 level, sufficient for the applications in her field. | |
| PLO14 | Bilgi - Kuramsal, Olgusal | Able to communicate verbally and in writing by using Turkish effectively. Asks questions, makes observations, thinks critically and constructively, abides by the principles of academic honesty, is entrepreneurial. | |
| PLO15 | Bilgi - Kuramsal, Olgusal | Shares designs and applications related to computer technologies with colleagues, can clearly explain this information to other people | |
| PLO16 | Bilgi - Kuramsal, Olgusal | She/He is conscious and knowledgeable about Atatürk's Principles and the History of the Revolution. | |
| PLO17 | Bilgi - Kuramsal, Olgusal | It is aware of occupational health and safety, environment and ethical values within the framework of global and social values. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | The targets, aims of lesson and basic definitions, concepts | there is no need for any preparation | Öğretim Yöntemleri: Anlatım |
| 2 | Entity-Relationship Model | there is no need for any preparation | Öğretim Yöntemleri: Anlatım |
| 3 | Relational Database | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 4 | Normalization | there is no need for any preparation | Öğretim Yöntemleri: Anlatım |
| 5 | Relational Algebra | there is no need for any preparation | Öğretim Yöntemleri: Anlatım |
| 6 | SQL CODES | there is no need for any preparation | Öğretim Yöntemleri: Anlatım |
| 7 | Basic SQL Transactions | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | Mid-Term Exam | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Basic SQL Functions | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 10 | SQL Multiline Function | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 11 | Simple Joining the Table | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 12 | Other Joining the Table | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 13 | Sub Queries | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 14 | Data Manuplation Language | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 15 | Database Objects | there is no need for any preparation | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 16 | Term Exams | Final Exam | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | 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 | 4 | 56 |
| 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 | 8 | 8 |
| Final Exam | 1 | 16 | 16 |
| Total Workload (Hour) | 108 | ||
| Total Workload / 25 (h) | 4,32 | ||
| ECTS | 4 ECTS | ||