TÜRKÇE
ENGLISH
Information
| Unit | KARAİSALI VOCATIONAL SCHOOL |
| Code | BPP222 |
| Name | DATA BASE II |
| Term | 2017-2018 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 |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. Ömer Tuğrul KURDOĞLU |
| Course Instructor |
Öğr. Gör. TACETTİN TORE
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
To comprehend the logic of client / server database and 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, Tables and properties in data bases
Course Precondition
Resources
Notes
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 | |
| 2 | Entity-Relationship Model | -there is no need for any preparation | |
| 3 | Relational Database | -there is no need for any preparation | |
| 4 | Normalization | -there is no need for any preparation | |
| 5 | Relational Algebra | -there is no need for any preparation | |
| 6 | SQL CODES | -there is no need for any preparation | |
| 7 | Basic SQL Transactions | -there is no need for any preparation | |
| 8 | Mid-Term Exam | - | |
| 9 | Basic SQL Functions | -there is no need for any preparation | |
| 10 | SQL Multiline Function | -there is no need for any preparation | |
| 11 | Simple Joining the Table | -there is no need for any preparation | |
| 12 | Other Joining the Table | -there is no need for any preparation | |
| 13 | Sub Queries | -there is no need for any preparation | |
| 14 | Data Manuplation Language | -there is no need for any preparation | |
| 15 | Database Objects | -there is no need for any preparation | |
| 16 | Term Exams | - | |
| 17 | Term Exams | - |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
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 | ||