TÜRKÇE
ENGLISH
Information
| Unit | ADANA VOCATIONAL SCHOOL |
| Code | BPP219 |
| Name | Database-II |
| Term | 2017-2018 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. MEHMET TEKDAL (Güz) (B Group) (Ins. in Charge) Doç. Dr. MESUT ÖZONUR (Güz) (C 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, 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 | Explains the fundamentals of client/server databases. |
| 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 | 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 | ||