Course Name Code Semester T+U Hours Credit ECTS
Database Management Systems BYP 209 3 2 + 1 3 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level onlisans
Course Type Compulsory
Course Coordinator Dr.Öğr.Üyesi OSMAN HAMDİ METE
Course Lecturers Dr.Öğr.Üyesi OSMAN HAMDİ METE,
Course Assistants
Course Category
Course Objective Development of database management systems(DBMS), basic concepts, DBMS application program(MS Access), visual interface and Structured Query Language(SQL), to have capability of creating, data processing, and searching of DBMS by using SQL
Course Content Traditional file systems, DBMS concepts, designing database, use of MS Access visual interface, designing tables, creating form, primary keys, relations, creating tables, entering, deleting, quering, and updating data by using SQL commands
# Course Learning Outcomes Teaching Methods Assessment Methods
1 To list advantages and disadvantages traditional file system structure, Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
2 To recognize main concepts of Databases Discussion, Question-Answer, Self Study, Lecture, Homework, Testing,
3 To describe sub systems Databases and data models Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
4 To manage of designing database systems Discussion, Question-Answer, Self Study, Lecture, Homework, Testing,
5 To Create database by using MS Access DBMS program Lecture, Self Study, Question-Answer, Discussion, Testing, Homework,
6 To Create tables by using visual interfaces of MS Access, builds relationships amond tables created Discussion, Question-Answer, Self Study, Lecture, Testing, Homework,
7 To Enter data into tables, crates form pages for updating and deleting Lecture, Question-Answer, Self Study, Discussion, Testing, Homework,
8 To Create queries by using visual interfaces at MS Access Discussion, Question-Answer, Self Study, Lecture, Testing, Homework,
9 To Create macros in MS Access, changes the attributes of MS Access Lecture, Self Study, Question-Answer, Discussion, Homework, Testing,
10 To Creat etables by SQL commands in MS Access Discussion, Question-Answer, Self Study, Lecture, Testing, Homework,
11 To add record to the table, updates records, deletes records. Lecture, Self Study, Question-Answer, Discussion, Homework, Testing,
12 To carry out quering interactions by using SQL commands at MS Access Discussion, Self Study, Question-Answer, Lecture, Testing, Homework,
Week Course Topics Preliminary Preparation
1 Basic attibutes of traditional file systems, advantages and disadvantages, general structures of database systems and their characteristics
2 Basic database concepts(table, field, and record), advantages of DBMS, Data Models, DB software, hardware infrastructure.
3 designing of database, normalisation processings, point to be considered during design process, case study
4 Installation of MS Access, usage of interface, creating database in MS Access environment
5 Creating tables by using wizard in MS Access visual interface, definition of key (primary key, candidate key and foreign key)
6 MS Access data types, creating tables in visual interface as desgn mode, field attributes, adding record to existent table, deleting field, and creating primary and candidate keys
7 Relation among tables by using MS Access visual interface (one by one and multiple), arrangement and delete of existent relations
8 Adding records by using data page mode, listing records, searching data in records, and creating form by means of wizard
9 Creating query by using wizard in MS Access, creating query by using design mode, usage of constraints in query, adding and deleting of fields in query design screen
10 Queries of adding, updating and deleting of records, activating of created queries
11 Creating form in design mode, toolbox, adding object to form page, checking attributes of objects
12 Creating macros in MS Access, adding macros to objects in form page, adding of starting form to MS Access application program
13 Basic characterictics of SQL, creating table by SQL commands in Query screen of MS Access
14 Adding record to the table, updating record, deleding record, and basic quering interactions by using SQL command in Query screen at MS Access
Resources
Course Notes
Course Resources
Order Program Outcomes Level of Contribution
1 2 3 4 5
1 X
2 X
3
4 X
5
6
7
8
9
10
11
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Kısa Sınav 15
1. Ödev 20
2. Kısa Sınav 15
Total 100
1. Yıl İçinin Başarıya 20
1. Final 80
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 3 48
Mid-terms 1 10 10
Quiz 2 5 10
Assignment 1 10 10
Final examination 1 10 10
Total Workload 136
Total Workload / 25 (Hours) 5.44
dersAKTSKredisi 5