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 |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör.Dr. ADNAN GÖKTEN |
| Course Instructor |
1 2 |
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 | The database knows the concepts and relational database. |
| LO02 | Knows the principles of database design. |
| LO03 | Makes correct associations between tables |
| LO04 | Recognizes the basic database programs. |
| LO05 | Database control, access, and knows to use administrative tools. |
| LO06 | Uses ms access program effectively |
| LO07 | Uses SQL language efficiently |
| LO08 | Knows the query types |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Gains basic, current and applied knowledge about Computer Technologies. | 4 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Gains knowledge about occupational health and safety, environmental awareness, and quality processes. | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Has knowledge of basic electronic components comprising computer hardware and their operations. | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Has 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ı | Has the ability to solve 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 | Öğretim Yöntemleri: Anlatım |
| 2 | The database and a relational database, the basic concepts. | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 3 | Table structure and fields. | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 4 | Area characteristics and to determine the types of data, comparison of different databases. | preparation is not required | Öğretim Yöntemleri: Anlatım |
| 5 | Access database program part 1 | preparation is not required | Öğretim Yöntemleri: Anlatım |
| 6 | Access database program part 2 | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 7 | Application works with the Access database program. | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | Ölçme Yöntemleri: Performans Değerlendirmesi, Yazılı Sınav |
|
| 9 | Introduction to SQL. | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 10 | SQL queries. part 1 | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama, Anlatım |
| 11 | SQL queries. part 2 | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 12 | SQL queries. part 3 | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 13 | Implementation activities | preparation is not required | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 14 | Implementation activities. part 1 | preparation is not required | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 15 | Implementation activities. part 2 | preparation is not required | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 16 | Term Exams | Ölçme Yöntemleri: Yazılı Sınav |
|
| 17 | Term Exams | Ö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 | ||