TÜRKÇE
ENGLISH
Information
| Code | BPP252 |
| Name | Database and Management |
| Term | 2023-2024 Academic Year |
| Semester | 4. 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. Alişan AKTAY |
| Course Instructor |
Öğr. Gör. Alişan AKTAY
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
The development and basic concepts of the database, its history, database design logic, Database Management System Application program (SQL Server) using SQL (Structural Query Language) to create a database, data processing and query ability.
Course Content
General information about database and data users Database systems concepts and architectures SQL and SQL programming techniques Relational algebra, relational analysis and entity-relationship (ER) model Object and object-relational databases UML and XML Functional dependencies and smoothing of relational databases Relational database design algorithms Paging, file structures, hash function and indexing for files Query processing and optimization Database security and database recovery techniques Distributed databases
Course Precondition
None
Resources
Database Logic - Kerem Köseoğlu Database Management Systems 2 - Turgut Özseven
Notes
Anadolu University lecture notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Defines/explains basic concepts about database. |
| LO02 | Defines/explains database design processes (spread sheet, normalization, association etc). |
| LO03 | Installs and uses necessary platforms for database management as appropriate to their purpose. |
| LO04 | Data manipulation and query by using SQL language. |
| LO05 | Makes necessary query works on database with structural query language (SQL) as appropriate to their purpose. |
| LO06 | Defines/explains database management (back up, safety etc.) processes. |
| LO07 | Understanding new developments and trends in databases |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | explains the basic and scientific concepts related to computer technologies. | |
| PLO02 | Bilgi - Kuramsal, Olgusal | Explains the hardware structures and the functions and functions of the electronic circuit elements that make up these hardware structures | |
| PLO03 | Bilgi - Kuramsal, Olgusal | Uses basic concepts in the field of computer technologies and Office programs and various package programs | 2 |
| PLO04 | Bilgi - Kuramsal, Olgusal | He/She has the ability to apply and solve problems in the field of computer programming by developing algorithms with software languages and utilities. | 2 |
| PLO05 | Bilgi - Kuramsal, Olgusal | Explain the basic concepts of computer hardware structures, make simple software installations and various hardware configurations, | |
| PLO06 | Bilgi - Kuramsal, Olgusal | designs basic database systems and database programs. | 5 |
| PLO07 | Bilgi - Kuramsal, Olgusal | Uses basic graphic and animation programs used to design interfaces on web pages | |
| PLO08 | Bilgi - Kuramsal, Olgusal | Explains and designs network systems, their types and makes simple installation examples. | |
| PLO09 | Bilgi - Kuramsal, Olgusal | Knows and uses internet technologies and develops server-side internet applications. | |
| PLO10 | Bilgi - Kuramsal, Olgusal | Knows various computer programming languages (Delphi, Visual Basic, C++ etc.). | |
| PLO11 | Bilgi - Kuramsal, Olgusal | He/she can carry out and conclude a basic study related to his/her field independently or in disciplined teams | |
| PLO12 | Bilgi - Kuramsal, Olgusal | Perceives and uses new technologies in the field with the necessity of lifelong learning | |
| PLO13 | Bilgi - Kuramsal, Olgusal | He/She knows a foreign language (professional foreign language) at A2 level, sufficient for the applications in her field. | |
| PLO14 | Bilgi - Kuramsal, Olgusal | Able to communicate verbally and in writing by using Turkish effectively. Asks questions, makes observations, thinks critically and constructively, abides by the principles of academic honesty, is entrepreneurial. | |
| PLO15 | Bilgi - Kuramsal, Olgusal | Shares designs and applications related to computer technologies with colleagues, can clearly explain this information to other people | |
| PLO16 | Bilgi - Kuramsal, Olgusal | She/He is conscious and knowledgeable about Atatürk's Principles and the History of the Revolution. | |
| PLO17 | Bilgi - Kuramsal, Olgusal | It is aware of occupational health and safety, environment and ethical values within the framework of global and social values. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to Database Systems. | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım |
| 2 | Normalization, Entity-Relationship Data Modeling, ER Diagrams and Sample Application. | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 3 | Introduction to SQL | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 4 | Data types, field properties | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Soru-Cevap |
| 5 | SQL Structured Query Language, SELECT statement | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 6 | SELECT query and join | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 7 | UNION and JOIN operations | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 8 | Mid-Term Exam | Repetition and Midterm Exam | Ölçme Yöntemleri: Proje / Tasarım |
| 9 | Application | Repetition | Öğretim Yöntemleri: Alıştırma ve Uygulama |
| 10 | CREATE TABLE, INSERT INTO, UPDATE statements | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 11 | DELETE, DROP statements | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 12 | Make the calculation of the areas of SQL. | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 13 | Make the calculation of the areas of SQL. Select, update, delete, insert, cross-queries. | Make the calculation of the areas of SQL. Select, update, delete, insert, cross-queries. | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 14 | Functions | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, Alıştırma ve Uygulama |
| 15 | Trigger Object and applications. | Developing application programs in the Computer Lab | Öğretim Yöntemleri: Anlatım, 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 | 4 | 56 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 4 | 56 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 5 | 5 |
| Final Exam | 1 | 10 | 10 |
| Total Workload (Hour) | 127 | ||
| Total Workload / 25 (h) | 5,08 | ||
| ECTS | 5 ECTS | ||