TÜRKÇE
ENGLISH
Information
| Code | BLP152 |
| Name | Database -I |
| Term | 2022-2023 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 2.5 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. BERİN YENİ |
| Course Instructor |
Öğr. Gör. BERİN YENİ
(A Group)
(Ins. in Charge)
Öğr. Gör. BERİN YENİ (B Group) (Ins. in Charge) |
Course Goal / Objective
To give students ability to design and create database, make queries and use databse management functions.
Course Content
Basic properties of classic file system, advantages and disadvantages, general structure and properties of database systems
Course Precondition
None
Resources
Microsoft Acces 2016, Osman Gürkan, Nirvana Yayınları
Notes
MEGEP Ders notları
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Explain the concepts of data and database |
| LO02 | Illustrate and use relational model concepts |
| LO03 | Uses Microsoft Access |
| LO04 | Prepares query with related tables |
| LO05 | Can creates Form and Report |
| LO06 | To list the rules and constraints of normal forms. |
| LO07 | Changing the properties of objects and forms. |
| LO08 | Creating and using the type of query. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Takes part in planning related to computer software and hardware | 3 |
| PLO02 | Bilgi - Kuramsal, Olgusal | Students will be able to define, collect and use the data necessary for the solution of well-defined problems in Computer Technologies and Programming. demonstrate that he / she can use the theoretical knowledge, knowledge and skills required in practical applications | 3 |
| PLO03 | Bilgi - Kuramsal, Olgusal | Word processor, spreadsheet, presentation, database and installs and uses various software | 4 |
| 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. | 3 |
| PLO06 | Bilgi - Kuramsal, Olgusal | Evaluates and supervises the performances of the employees under their responsibility | 3 |
| PLO07 | Bilgi - Kuramsal, Olgusal | Detects software and simple hardware failures in the computer and solves problems that do not require expertise | |
| 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 | 4 |
| 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 | |
| PLO17 | Yetkinlikler - Öğrenme Yetkinliği | Takes part in software, hardware and network discoveries |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Basic properties of classic file system, advantages and disadvantages, general structure and properties of database systems | Developing sample application the computer lab | Öğretim Yöntemleri: Anlatım, Gösteri, Benzetim, Örnek Olay |
| 2 | Entry into the database, database and data modeling, DBMS types and concepts | Developing sample application the computer lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Benzetim, Problem Çözme |
| 3 | E-R model, the presence of a set of assets, attributes, relations concepts, relationship types | Developing sample application the computer lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösteri, Örnek Olay |
| 4 | Relational database | Developing sample application the computer lab | Öğretim Yöntemleri: Soru-Cevap, Benzetim, Problem Çözme |
| 5 | Key areas, foreign key, descriptive qualities, to be converted to the correlation table | Developing sample application the computer lab | Öğretim Yöntemleri: Anlatım, Örnek Olay, Problem Çözme |
| 6 | Creating tables in MS Access application, field types, relationship identification, reporting, | Developing sample application the computer lab | Öğretim Yöntemleri: Anlatım, Tartışma, Alıştırma ve Uygulama, Benzetim, Örnek Olay, Problem Çözme |
| 7 | Creating query in MS Access application, | Developing sample application the computer lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama, Problem Çözme |
| 8 | Mid-Term Exam | Developing sample application the computer lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Bireysel Çalışma, Problem Çözme |
| 9 | Repetition and Midterm Exam | Repetition and Midterm Exam | Ölçme Yöntemleri: Yazılı Sınav |
| 10 | Database objects | Developing sample application the computer labDeveloping sample application the computer lab | Öğretim Yöntemleri: Anlatım, Örnek Olay |
| 11 | Data analysis and multiple tables | Developing sample application the computer labDeveloping sample application the computer lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Tartışma, Örnek Olay, Problem Çözme |
| 12 | Prepare a query with related tables | Developing sample application the computer labDeveloping sample application the computer lab | Öğretim Yöntemleri: Soru-Cevap, Alıştırma ve Uygulama, Benzetim, Problem Çözme |
| 13 | Form appliation | Developing sample application the computer labDeveloping sample application the computer lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Gösteri, Problem Çözme |
| 14 | Operations on Forms | Developing sample application the computer labDeveloping sample application the computer lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Alıştırma ve Uygulama, Örnek Olay |
| 15 | User access and control | Developing sample application the computer labDeveloping sample application the computer lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap, Alıştırma ve Uygulama |
| 16 | Term Exams | Repetition and Final Exam | Ölçme Yöntemleri: Yazılı Sınav |
| 17 | Term Exams | Repetition and Final Exam | Ö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 | 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 | 12 | 12 |
| Final Exam | 1 | 18 | 18 |
| Total Workload (Hour) | 116 | ||
| Total Workload / 25 (h) | 4,64 | ||
| ECTS | 5 ECTS | ||