TÜRKÇE
ENGLISH
Information
| Unit | ADANA VOCATIONAL SCHOOL |
| Code | BPP219 |
| Name | Database-II |
| Term | 2019-2020 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 |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Doç. Dr. MESUT ÖZONUR |
| Course Instructor |
Doç. Dr. MESUT ÖZONUR
(Güz)
(A Group)
(Ins. in Charge)
Doç. Dr. MESUT ÖZONUR (Güz) (B Group) (Ins. in Charge) |
Course Goal / Objective
Comprehend client / server database logic 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, Simple Joining the Table, Other Joining the Table, Sub Queries, Data Manuplation Language, Database Objects.
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Have information about basic issues of client / server database |
| LO02 | Recognizes client / server database language. |
| LO03 | Understands the importance of database programming. |
| LO04 | Perform applications using client / server the 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 |
|---|
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Basic concepts | Reading and understanding of the issues before the course. | |
| 2 | Entity-Relationship Model | Reading and understanding of the issues before the course. | |
| 3 | Relational Database | Reading and understanding of the issues before the course. | |
| 4 | Normalization | Reading and understanding of the issues before the course. | |
| 5 | Relational Algebra | Reading and understanding of the issues before the course. | |
| 6 | SQL - Structured Query Language | Reading and understanding of the issues before the course. | |
| 7 | Basic SQL Transactions | Reading and understanding of the issues before the course. | |
| 8 | Mid-Term Exam | Multiple Choice, Text, True / False or Open Ended Exam | |
| 9 | Basic SQL Functions | Reading and understanding of the issues before the course. | |
| 10 | SQL Multiline Function | Reading and understanding of the issues before the course. | |
| 11 | Simple Joining the Table | Reading and understanding of the issues before the course. | |
| 12 | Other Joining the Table | Reading and understanding of the issues before the course. | |
| 13 | Sub Queries | Reading and understanding of the issues before the course. | |
| 14 | Data Manuplation Language | Reading and understanding of the issues before the course. | |
| 15 | Database Objects | Reading and understanding of the issues before the course. | |
| 16 | Term Exams | Multiple Choice, Text, True / False or Open Ended Exam | |
| 17 | Term Exams | Multiple Choice, Text, True / False or Open Ended Exam |
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 | 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 | ||