GAZI UNIVERSITY INFORMATION PACKAGE - 2019 ACADEMIC YEAR

COURSE DESCRIPTION
DATA BASE MANAGEMENT SYSTEMS/5261308
Course Title: DATA BASE MANAGEMENT SYSTEMS
Credits 3 ECTS 8
Semester 1 Compulsory/Elective Elective
COURSE INFO
 -- LANGUAGE OF INSTRUCTION
  Turkish
 -- NAME OF LECTURER(S)
  Assist. Prof. Dr. Talip KELLEGÖZ
 -- WEB SITE(S) OF LECTURER(S)
  http://websitem.gazi.edu.tr/site/tkellegoz
 -- EMAIL(S) OF LECTURER(S)
  tkellegoz@gazi.edu.tr
 -- LEARNING OUTCOMES OF THE COURSE UNIT
Student who passed the course satisfactorily: 1-know data models and its importance in database systems.
2-know the concepts of concurrency control and transaction in database management systems.
3-Learn abstraction levels, data independence, log, and the architecture of database management systems.
4-Learn the phases of database design and how the conceptual database design is done.





 -- MODE OF DELIVERY
  This course is conducted in the mode of distance education.
 -- 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  Introduction
2. Week  Introduction of popular database management system softwares, sample applications for using them.
3. Week  Data and information, information systems, database, database management systems and database systems
4. Week  History of database management systems, Advantages and disadvantages of database management systems
5. Week  Data models
6. Week  Data models (continued), object-relational databases
7. Week  Abstraction levels, data independence
8. Week  Concurrency control
9. Week  Concurrency control (continued), Transaction
10. Week  Transaction (continued), backup, Log
11. Week  Mid-term exam
12. Week  The structure of database management systems
13. Week  database system users, database languages​​, classification of database management systems
14. Week  Introduction to database design, conceptual database design
15. Week  Conceptual database design (continued)
16. Week  Final exam
 -- RECOMMENDED OR REQUIRED READING
  -Sumathi, S., Esakkirajan, S. (2010) Fundamentals of Relational Database Management Systems, Springer-Verlag. -Elmasri, R., Navathe, S.B. (2004) Fundamentals of Datatabase Systems, Addison Wesley. -Rob, P., Coronel, C. (2007) Database Systems: Design, Implementation and Management, Thomson Course Technology. -Ramakrishnan, R., Gehrke, J. (2002) Database Management Systems, Mc Graw Hill. -Hoffer, J.A., Prescott, M.B., McFadden , F.R. (2007) Modern DatabaseManagement Systems, Prentice Hall.
 -- PLANNED LEARNING ACTIVITIES AND TEACHING METHODS
  Lecture, Question & Answer, Demonstration, Drill - Practise
 -- WORK PLACEMENT(S)
  Not Applicable
 -- ASSESSMENT METHODS AND CRITERIA
 
Quantity
Percentage
 Mid-terms
1
20
 Assignment
1
10
 Exercises
0
0
 Projects
0
0
 Practice
0
0
 Quiz
0
0
 Contribution of In-term Studies to Overall Grade  
30
 Contribution of Final Examination to Overall Grade  
70
 -- WORKLOAD
 Efficiency  Total Week Count  Weekly Duration (in hour)  Total Workload in Semester
 Theoretical Study Hours of Course Per Week
14
3
42
 Practising Hours of Course Per Week
0
 Reading
10
2
20
 Searching in Internet and Library
10
2
20
 Designing and Applying Materials
4
8
32
 Preparing Reports
1
15
15
 Preparing Presentation
1
4
4
 Presentation
1
4
4
 Mid-Term and Studying for Mid-Term
1
10
10
 Final and Studying for Final
1
34
34
 Other
3
4
12
 TOTAL WORKLOAD: 
193
 TOTAL WORKLOAD / 25: 
7.72
 ECTS: 
8
 -- COURSE'S CONTRIBUTION TO PROGRAM
NO
PROGRAM LEARNING OUTCOMES
1
2
3
4
5
1Rule the information technologies and systems used in the units of the Business, have enough knowledge on the system management.X
2Master the information systems and technologies used in the units of the Business, design the system regarding the needs of the Business.X
3Make the related analyses for an information system and know all of the processes at the analysis, design and implementation stages of the database that belongs to the system.X
4Be able to follow current developments in modern business techniques and technologies; especially information technologies, gain know how.X
5Follow current affairs and convey information about trends systematically.X
6Be aware of the social transformation especially in their own field and social, legal and moral responsbilities belongs to other work field.
7Understand the disciplines and the interaction between his discipline and other relational ones, regard the disciplines and interactions in team works.
8Develop their knowledge to the level of expertise which they obtained in license level.X
9Carry out a work which requires an expertness in this field.X
10Construct and perform an academic work in the field of Management Information Systems.X