TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| Code | BL120 |
| Name | Database-I |
| Term | 2019-2020 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 3-1 (T-A) (17 Week) |
| ECTS | 5 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. Dr. ADNAN GÖKTEN |
| Course Instructor |
Öğr. Gör. Dr. ADNAN GÖKTEN
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
Recognition database and relational database concepts, to design the database, the database control, access and use administrative tools, to develop the ability to use the SQL language.
Course Content
TThe database and relational database concept, design, normalization and the use of SQL language.
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | The database knows the concepts and relational database. |
| LO02 | Knows the principles of database design. |
| LO03 | Make the correct associations between the tables |
| LO04 | Recognizes the basic database programs. |
| LO05 | Database control, access, and knows to use administrative tools. |
| LO06 | Effectively use the MS Access program. |
| LO07 | Efficiently use the SQL language. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Lists basic, current and applied knowledge about Computer Technologies. | 4 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Remembers knowledge about occupational health and safety, environmental awareness, and quality processes. | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Lists basic electronic components comprising computer hardware and their operations. | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Remembers the knowledge about Atatürk's Principles and History of Revolution. | |
| PLO05 | Beceriler - Bilişsel, Uygulamalı | Keeps track of current developments and applications in computer programming, and utilizes them effectively. | 2 |
| PLO06 | Beceriler - Bilişsel, Uygulamalı | Solves problems in the field of computer programming. | 3 |
| PLO07 | Beceriler - Bilişsel, Uygulamalı | Creates algorithms and data structures, and performs mathematical calculations. | 3 |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | Explains and implements web programming technologies. | |
| PLO09 | Beceriler - Bilişsel, Uygulamalı | Performs database design and management. | 5 |
| PLO10 | Beceriler - Bilişsel, Uygulamalı | Tests software and resolves errors. | |
| PLO11 | Beceriler - Bilişsel, Uygulamalı | Can utilize software and package programs in the field of computer programming. | |
| PLO12 | Beceriler - Bilişsel, Uygulamalı | Explains, designs and installs network systems. | |
| PLO13 | Beceriler - Bilişsel, Uygulamalı | Uses word processor, spreadsheet, presentation programs. | |
| PLO14 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Can effectively present thoughts on computer technologies through written and verbal communication, expressing them clearly and comprehensibly. | |
| PLO15 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Takes responsibility as a team member to solve unforeseen complex problems encountered in practical applications of computer programming. | |
| PLO16 | Yetkinlikler - Öğrenme Yetkinliği | Has awareness in career management and lifelong learning. | |
| PLO17 | Yetkinlikler - Alana Özgü Yetkinlik | Has societal, scientific, cultural, and ethical values in the collection, application, and announcement of results related to computer technologies. | |
| PLO18 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Follows developments in the field using a foreign language and communicates with colleagues. | |
| PLO19 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Can effectively communicate in Turkish both in written and oral forms. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Access to the database. | preparation is not required | |
| 2 | The database and a relational database, the basic concepts. | preparation is not required | |
| 3 | Table structure and fields. | preparation is not required | |
| 4 | Area characteristics and to determine the types of data, comparison of different databases. | preparation is not required | |
| 5 | Access database program part 1 | preparation is not required | |
| 6 | Access database program part 2 | preparation is not required | |
| 7 | Application works with the Access database program. | preparation is not required | |
| 8 | Mid-Term Exam | ||
| 9 | Introduction to SQL. | preparation is not required | |
| 10 | SQL queries. part 1 | preparation is not required | |
| 11 | SQL queries. part 2 | preparation is not required | |
| 12 | SQL queries. part 3 | preparation is not required | |
| 13 | Implementation activities | preparation is not required | |
| 14 | Implementation activities. part 1 | preparation is not required | |
| 15 | Implementation activities. part 2 | preparation is not required | |
| 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 | 3 | 42 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 1 | 1 | 1 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 8 | 8 |
| Final Exam | 1 | 16 | 16 |
| Total Workload (Hour) | 123 | ||
| Total Workload / 25 (h) | 4,92 | ||
| ECTS | 5 ECTS | ||