GAZI UNIVERSITY INFORMATION PACKAGE - 2019 ACADEMIC YEAR

COURSE DESCRIPTION
Database Management Systems/BL306A
Course Title: Database Management Systems
Credits 3 ECTS 6
Semester 6 Compulsory/Elective Compulsory
COURSE INFO
 -- LANGUAGE OF INSTRUCTION
  Turkish
 -- NAME OF LECTURER(S)
  Instructor, Dr. Sibel SOMYÜREK
 -- WEB SITE(S) OF LECTURER(S)
  http://w3.gazi.edu.tr/~ssomyurek/
 -- EMAIL(S) OF LECTURER(S)
  somyurek@gmail.com
 -- LEARNING OUTCOMES OF THE COURSE UNIT
Defining database and database management systems
Developing databases(requirements analysis, conceptual modeling, logical modeling and physical modeling)
Questioning, modifying, adding and deleting data using the SQL language.
Creating and managing databases in MySQL
 -- MODE OF DELIVERY
  The mode of delivery of this course is face to face.
 -- PREREQUISITES AND CO-REQUISITES
  There is no prerequisite or co-requisite for this course.
 -- RECOMMENDED OPTIONAL PROGRAMME COMPONENTS
  There is no recommended optional programme component for this course.
 --COURSE CONTENT
1. Week  What is a database? Database samples
2. Week  The definition and functions of database management systems
3. Week  Phases to create a database- Requirement analysis
4. Week  Phases to create a database- Conceptual modeling
5. Week  Phases to create a database- Logical modeling
6. Week  Phases to create a database- Physical modeling
7. Week  Phases to create a database- Physical modeling
8. Week  Normalization
9. Week  Data Integrity
10. Week  UML
11. Week  Creating and managing databases in MySQL
12. Week  Creating and managing databases in MySQL
13. Week  Creating and managing databases in MySQL
14. Week  Creating and managing databases in MySQL
15. Week  
16. Week  
 -- RECOMMENDED OR REQUIRED READING
  Tokdemir, G. ve Çağıltay, N. E. (2010). Veritabanı Sistemleri Dersi. Seçkin Yayıncılık. Ankara. Köseoğlu, K. (2005). Veri Tabanı Mantığı. Şefik Matbaası. İstanbul Alokoç Burma, Z. (2005). Veritabanı Yönetim Sistemleri ve SQL / PL - SQL / T – SQL. Seçkin Yayıncılık. Ankara Kroenke, D. M. (2006). Database Processing:Fundamentals, Design, and Implementation.Pearson Education International. Singapore,Canada,Japan.
 -- PLANNED LEARNING ACTIVITIES AND TEACHING METHODS
  Anlatım, Soru-Yanıt, Gösterme, Uygulama - Alıştırma
 -- WORK PLACEMENT(S)
  Not Applicable
 -- ASSESSMENT METHODS AND CRITERIA
 
Quantity
Percentage
 Mid-terms
1
20
 Assignment
1
20
 Exercises
5
20
 Projects
0
0
 Practice
0
0
 Quiz
0
0
 Contribution of In-term Studies to Overall Grade  
40
 Contribution of Final Examination to Overall Grade  
60
 -- WORKLOAD
 Efficiency  Total Week Count  Weekly Duration (in hour)  Total Workload in Semester
 Theoretical Study Hours of Course Per Week
14
2
28
 Practising Hours of Course Per Week
14
2
28
 Reading
4
4
16
 Searching in Internet and Library
4
3
12
 Designing and Applying Materials
10
2
20
 Preparing Reports
2
5
10
 Preparing Presentation
2
3
6
 Presentation
3
1
3
 Mid-Term and Studying for Mid-Term
1
10
10
 Final and Studying for Final
1
15
15
 Other
0
 TOTAL WORKLOAD: 
148
 TOTAL WORKLOAD / 25: 
5.92
 ECTS: 
6
 -- COURSE'S CONTRIBUTION TO PROGRAM
NO
 PROGRAM LEARNING OUTCOMES
1
2
3
4
5
1Know up-to-date information and communication technologies and related concepts.
2Discuss methods of science.X
3Know effective use of information and communication technologies to maximize learning.X
4Know theories, methods, models and contemporary approaches to instructional technologies.
5Know developmental and cognitive characteristics and individula differences of learners.
6Know scientific base of information and communication technologies
7Know general and special instructional principles and methods.
8Know theoretical and technological base of distance education.
9Know how to plan and organize educational settings tecnologically.X
10Know the development of information and communication Technologies historically and culturally.
11Know educational material design and development principles.
12Know print and electronic resources in the field.
13Use the ways of accessing knowledge.X
14Plan and carry out social responsibility activities and plan and implement professional projects.
15Follow and implement innovative approaches in the field.X
16Use knowledge and skills in the field to generate creative solutions to educational problems.X
17Design and develop educational materials through information and communication Technologies.
18Use the professional knowledge and skills in the software development.X
19take responsibility and fulfills the task effectively in individual and group works.X
20Use history, foreign language, world knowledge and general teaching competencies