Information Package / Course Catalogue
Databases and Information System
Course Code: ISL411
Course Type: Area Elective
Couse Group: First Cycle (Bachelor's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 3
Prt.: 0
Credit: 3
Lab: 0
ECTS: 5
Objectives of the Course

To understand database and relational database concepts, design and management and to learn the access and control methods for databases

Course Content

Concepts of File and Database, Data Models, Relational Database Model, Logical Database Design Data Definition and Query Language, Entity - Relation (ER) diagrams Relational Algebra Applications, normalization of Relational Database Design, Extended Entity-Relation diagrams, Data Storage Techniques, Security of Database System

Name of Lecturer(s)
Learning Outcomes
1.Explains basic functions of information systems.
2.Defines database management systems.
3.Applies data modeling process.
4.Manages data using SQL queries.
5.Evaluates data security and backup systems.
6.Analyzes the role of information systems in business processes.
Recommended or Required Reading
1.Kalıpsız Oya, Veri Tabanı Sistemleri, Der Yayınevi, 2001.
Weekly Detailed Course Contents
Week 1 - Theoretical
The aim of the course and
Week 2 - Theoretical
File and data base concepts
Week 3 - Theoretical
Data Models, Relational Data Model
Week 4 - Theoretical
Logical Database Design, Data Definition and Query Languages
Week 5 - Theoretical
Entity - Relationship (E-R) diagrams
Week 6 - Theoretical
Applications of Relational Algebra
Week 7 - Theoretical
Applications of Relational Algebra
Week 8 - Theoretical
Relational Database Design Normalization
Week 9 - Theoretical
Extended Entity-Relationship Diagrams
Week 10 - Theoretical
Data Storage Techniques
Week 11 - Theoretical
Data Storage Techniques
Week 12 - Theoretical
Database Systems Security
Week 13 - Theoretical
Data Warehouse
Week 14 - Theoretical
Data Mining
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory142370
Midterm Examination125126
Final Examination128129
TOTAL WORKLOAD (hours)125
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
PÇ-10
OÇ-1
2
2
2
2
2
1
1
1
1
1
OÇ-2
1
1
1
1
2
1
1
2
1
1
OÇ-3
1
1
1
1
1
1
1
1
1
1
OÇ-4
1
1
1
1
1
1
1
1
1
1
OÇ-5
2
2
2
1
1
1
2
2
1
1
OÇ-6
1
2
1
2
1
2
1
2
1
2
Adnan Menderes University - Information Package / Course Catalogue
2026