TÜRKÇE
ENGLISH
Information
| Code | BL120 |
| Name | Database-I |
| Term | 2024-2025 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 3-1 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 3 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
(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
None
Resources
Unpublished lecture notes
Notes
Mithat Uysal, Veri tabanı Sorgulama Dili ISBN-975-486-398-9
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Defines the concepts of database and relational database. |
| LO02 | Lists database design principles |
| LO03 | Explains correct associations between tables |
| LO04 | Explains basic database programs |
| LO05 | Explains how to use database auditing, access, and administrative tools |
| LO06 | Uses ms access program effectively |
| LO07 | Uses SQL language efficiently |
| LO08 | Lists the query types. |
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. | reading from relevant source | Öğretim Yöntemleri: Anlatım |
| 2 | The database and a relational database, the basic concepts. | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 3 | Table structure and fields. | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 4 | Area characteristics and to determine the types of data, comparison of different databases. | reading from relevant source | Öğretim Yöntemleri: Anlatım |
| 5 | Access database program part 1 | reading from relevant source | Öğretim Yöntemleri: Anlatım |
| 6 | Access database program part 2 | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 7 | Application works with the Access database program. | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | reading from relevant source | Ölçme Yöntemleri: Performans Değerlendirmesi, Yazılı Sınav |
| 9 | Introduction to SQL. | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 10 | SQL queries. part 1 | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama, Anlatım |
| 11 | SQL queries. part 2 | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 12 | SQL queries. part 3 | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 13 | Implementation activities | reading from relevant source | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 14 | Implementation activities. part 1 | reading from relevant source | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 15 | Implementation activities. part 2 | reading from relevant source | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 16 | Term Exams | reading from relevant source | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | reading from relevant source | Ölçme Yöntemleri: Yazılı Sınav |
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 | ||