BPP252 Database and Management

5 ECTS - 3-1 Duration (T+A)- 4. Semester- 3 National Credit

Information

Code BPP252
Name Database and Management
Term 2024-2025 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
1 2
Öğ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

Update Time: 14.05.2024 02:34