TÜRKÇE
ENGLISH
Information
| Unit | KARAİSALI VOCATIONAL SCHOOL |
| Code | BPP222 |
| Name | DATA BASE II |
| Term | 2019-2020 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
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
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 |
|---|
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 | 20 |
| General Assessment | ||
| Midterm / Year Total | 100 | 20 |
| 1. Final Exam | - | 80 |
| 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 | ||