Information Package / Course Catalogue
Database - I
Course Code: BPR110
Course Type: Required
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 3
Prt.: 1
Credit: 4
Lab: 0
ECTS: 4
Objectives of the Course

Teaching the basics of database design. Developing databases, building querries, using database managerial functions

Course Content

database needs assesment, installing database tools, preparing forms and setting their functions, building querries and using various querries, doing transaction operations, writing index querries

Name of Lecturer(s)
Ins. Erkan GÜLER
Learning Outcomes
1.designing databases
2.developing databases
3.building querries in databases
4.using managerial functions of databases
5.Knows the general structure, advantages and disadvantages of Classical File System
6.Knows the basic concepts of database
7.Knows the data base systems and data models
8.Know the basic properties of relational database, key, relationship types
9.Knows database manager, application programmer, normal user tasks, knows database internal operations
10.Add, update or delete records using SQL commands
11.Perform basic queries on records using SQL commands.
Recommended or Required Reading
1.Visual Basic ve Database (Arter Yayıncılık)
Weekly Detailed Course Contents
Week 1 - Theoretical
database needs assessment
Week 2 - Theoretical
normalization
Week 3 - Theoretical
normalization
Week 4 - Theoretical
Installing database tools
Week 5 - Theoretical
building tables and setting their properties
Week 6 - Theoretical
building tables and setting their properties
Week 7 - Theoretical
building querries and using their types
Week 8 - Theoretical
building querries and using their types, building querries with related tables (midterm exam)
Week 9 - Theoretical
building querries with related tables
Week 10 - Theoretical
using DML querries
Week 11 - Theoretical
building user querries
Week 12 - Theoretical
writing view querries
Week 13 - Theoretical
building triggering queries
Week 14 - Theoretical
doing transactions and building index querries
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory140342
Lecture - Practice140114
Laboratory80432
Midterm Examination1516
Final Examination1516
TOTAL WORKLOAD (hours)100
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
PÇ-11
OÇ-1
3
3
3
3
3
3
3
3
3
3
3
OÇ-2
2
2
2
1
1
1
2
2
1
1
1
OÇ-3
3
2
2
2
2
2
2
2
2
1
1
OÇ-4
2
2
2
2
2
2
2
2
2
2
2
OÇ-5
3
2
3
2
3
3
3
1
1
1
2
OÇ-6
3
2
2
3
3
2
2
2
2
2
2
OÇ-7
2
2
2
2
3
3
3
1
1
2
3
OÇ-8
3
1
1
2
2
2
3
2
2
3
2
OÇ-9
3
2
2
3
3
3
3
3
1
1
1
OÇ-10
2
2
2
3
3
3
3
2
2
1
2
OÇ-11
4
3
3
4
4
4
3
3
5
3
3
Adnan Menderes University - Information Package / Course Catalogue
2026