TÜRKÇE
ENGLISH
Information
| Unit | CEYHAN VOCATIONAL SCHOOL |
| Code | BLP257 |
| Name | Database -II |
| Term | 2021-2022 Academic Year |
| Semester | 3. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 4 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 | Öğr. Gör. BERİN YENİ |
| Course Instructor |
Öğr. Gör. BERİN YENİ
(Güz)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
To give the development and basic concepts of database, and database design logic, to have the ability to create database using database management system application program (SQL Server) SQL (Structural Query Language), to process and query ability.
Course Content
Basic properties of classic file system, advantages and disadvantages, general structure and properties of database systems
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Defines/explains basic concepts about database. |
| LO02 | Defines/explains database design processes (spread sheet, normalization, association etc). |
| LO03 | Installs and uses necessary platforms for database management as appropriate to their purpose. |
| LO04 | Data manipulation and query by using SQL language. |
| LO05 | Makes necessary query works on database with structural query language (SQL) as appropriate to their purpose. |
| LO06 | Defines/explains database management (back up, safety etc.) processes. |
| LO12 | . |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Defines computer software and hardware. | 2 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Defines the data required to solve problems in the field of Computer Technologies and Programming. | 3 |
| PLO03 | Bilgi - Kuramsal, Olgusal | Recognizes word processor, spreadsheet, presentation, database and various software. | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Makes coding, internet and network makes the installation of devices. | |
| PLO05 | Bilgi - Kuramsal, Olgusal | Have sufficient knowledge of Turkish and foreign languages. | |
| PLO06 | Bilgi - Kuramsal, Olgusal | Evaluates and supervises the performances of the employees under their responsibility | |
| PLO07 | Bilgi - Kuramsal, Olgusal | Detects software and simple hardware failures in the computer and solves problems that do not require expertise | 4 |
| PLO08 | Bilgi - Kuramsal, Olgusal | Use appropriate techniques with verbal, numerical and graphical expression | |
| PLO09 | Bilgi - Kuramsal, Olgusal | Creates computer technology related design and applications with team work and presents to related people and institutions | 3 |
| PLO10 | Bilgi - Kuramsal, Olgusal | Gain analytical and numerical thinking skills and contribute to national economy by using knowledge and skills related to the field in accordance with regulations | |
| PLO11 | Bilgi - Kuramsal, Olgusal | Provides professional connections in the public and private sector business areas and uses appropriate tools in the social and professional field in the decision-making process | |
| PLO12 | Beceriler - Bilişsel, Uygulamalı | Conduct research using the Internet and various communication technologies | |
| PLO13 | Beceriler - Bilişsel, Uygulamalı | Demonstrate the ability to learn and learn independently in the field of Computer Technologies and Programming | |
| PLO14 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Conducts teamwork in accordance with the basic concepts of human relations and entrepreneurship | |
| PLO15 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Have knowledge about Atatürk's Principles and Revolution History | |
| PLO16 | Yetkinlikler - Öğrenme Yetkinliği | Demonstrate the ability to identify problems and find solutions to unforeseen situations in work in the field of Computer Technologies | 4 |
| PLO17 | Yetkinlikler - Öğrenme Yetkinliği | Takes part in software, hardware and network discoveries |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to Database Systems. | Developing sample application the computer lab | |
| 2 | Normalization, Entity-Relationship Data Modeling, ER Diagrams and Sample Application. | Developing sample application the computer lab | |
| 3 | Introduction to SQL | Developing sample application the computer lab | |
| 4 | data types, field properties, | Developing sample application the computer lab | |
| 5 | SQL Structured Query Language, SELECT statement | Developing sample application the computer lab | |
| 6 | SQL Structured Query Language, SELECT statement | Developing sample application the computer lab | |
| 7 | UNION and JOIN operations | Developing sample application the computer lab | |
| 8 | Mid-Term Exam | Developing sample application the computer lab | |
| 9 | Midterm Exam | Repetition and Midterm Exam | |
| 10 | CREATE TABLE, INSERT INTO, UPDATE statements | Developing sample application the computer lab | |
| 11 | DELETE, DROP statements | Developing sample application the computer lab | |
| 12 | Make the calculation of the areas of SQL. | Developing sample application the computer lab | |
| 13 | Make the calculation of the areas of SQL. Select, update, delete, insert, cross-queries. | Developing sample application the computer lab | |
| 14 | Functions. | Developing sample application the computer lab | |
| 15 | Trigger Object and applications. | Developing sample application the computer lab | |
| 16 | Term Exams | Repetition and Final Exam | |
| 17 | Term Exams | Repetition and Final 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 | 3 | 42 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 2 | 2 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 7 | 7 |
| Final Exam | 1 | 18 | 18 |
| Total Workload (Hour) | 111 | ||
| Total Workload / 25 (h) | 4,44 | ||
| ECTS | 4 ECTS | ||