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 (Midterm exam)
Week 9 - Theoretical
Preparing a Query with Related Tables
Week 10 - Theoretical
Preparing a Query with Related Tables
Week 11 - Theoretical
Preparing a Query with Related Tables
Week 12 - Theoretical
Using DML Queries
Week 13 - Theoretical
Create a form
Week 14 - Theoretical
Create a form
Assessment Methods and Criteria
Type of AssessmentCountPercent
Assignment1%10
Quiz1%10
Midterm Examination1%20
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory140228
Assignment1314
Quiz1314
Midterm Examination1617
Final Examination1617
TOTAL WORKLOAD (hours)50
Contribution of Learning Outcomes to Programme Outcomes