TÜRKÇE
ENGLISH
Information
| Code | BL120 |
| Name | Database-I |
| Term | 2023-2024 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 | 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 | Explain the basic scientific concepts related to Computer Technologies. | 4 |
| PLO02 | Beceriler - Bilişsel, Uygulamalı | Can use algorithmic thinking & planning approaches in programming. | |
| PLO03 | Beceriler - Bilişsel, Uygulamalı | uses word processor, spreadsheet, presentation programs. | |
| PLO04 | Bilgi - Kuramsal, Olgusal | Has the ability to solve problems in the field of computer programming. | |
| PLO05 | Bilgi - Kuramsal, Olgusal | Knows the basic electronic parts of computer hardware and their functioning. | |
| PLO06 | Beceriler - Bilişsel, Uygulamalı | Basic level Database Systems, client/server software and implements | 5 |
| PLO07 | Beceriler - Bilişsel, Uygulamalı | In Computer Technologies, students use graphical programs used in interface design and 3D modeling in web pages at basic level. | |
| PLO08 | Beceriler - Bilişsel, Uygulamalı | Explains, designs and installs network systems. | |
| PLO09 | Yetkinlikler - Alana Özgü Yetkinlik | Uses Internet technologies, develops server-side working internet applications. | 3 |
| PLO10 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Can carry out a basic study related to the field independently or in disciplined teams | |
| PLO11 | Yetkinlikler - Öğrenme Yetkinliği | Can do resource research and obtain information from database in order to follow the developments in the field with the necessity of lifelong learning. | |
| PLO12 | Bilgi - Kuramsal, Olgusal | Knows a foreign language which is sufficient for the applications in the field. | |
| PLO13 | Bilgi - Kuramsal, Olgusal | To be able to communicate effectively in written and oral Turkish. | |
| PLO14 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | He/she can clearly explain the designs and applications related to computer technologies to his colleagues, superiors, others who are related to the field or not. | |
| PLO15 | Bilgi - Kuramsal, Olgusal | Has knowledge about Atatürk's Principles and History of Revolution. | |
| PLO16 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | It is aware of occupational health and safety, environmental and ethical values within the framework of global and social values. |
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 | ||