Information Package / Course Catalogue
Database Management Systems
Course Code: BPR188
Course Type: Non Departmental Elective
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 2
Prt.: 0
Credit: 2
Lab: 0
ECTS: 2
Objectives of the Course

Ability to design, create, query and form databases.

Course Content

To design database, forms and queries in database management system.

Name of Lecturer(s)
Learning Outcomes
1.Understanding database design
2.Understanding how to create a database
3.Understanding how to query the database
4.Comprehending form creation
5.To be able to design and implement databases in accordance with rules and standards under realistic constraints and conditions.
6.To be able to use SQL applications to create database applications and use database applications according to the needs of engineering problems.
Recommended or Required Reading
1.Database Management Systems II Turgut Özseven Murathan Yayın
Weekly Detailed Course Contents
Week 1 - Theoretical
Database Needs Analysis
Week 2 - Theoretical
Normalization
Week 3 - Theoretical
Normalization
Week 4 - Theoretical
Setting Up Database Tools
Week 5 - Theoretical
Creating Tables and Specifying Properties
Week 6 - Theoretical
Creating Query and Using Types
Week 7 - Theoretical
Creating Query and Using Types
Week 8 - Theoretical
Creating Query and Using Types
Week 9 - Intermediate Exam
Midterm exam
Week 10 - Theoretical
Preparing a Query with Related Tables
Week 11 - Theoretical
Preparing a Query with Related Tables
Week 12 - Theoretical
Preparing a Query with Related Tables
Week 13 - Theoretical
Using DML Queries
Week 14 - Theoretical
Create a form
Week 15 - Theoretical
Create a form
Week 16 - Final Exam
Final exam
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%30
Final Examination1%70
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory140228
Assignment1055
Term Project1055
Midterm Examination1516
Final Examination1516
TOTAL WORKLOAD (hours)50
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
OÇ-2
OÇ-3
OÇ-4
OÇ-5
OÇ-6
Adnan Menderes University - Information Package / Course Catalogue