GAZI UNIVERSITY INFORMATION PACKAGE - 2019 ACADEMIC YEAR

COURSE DESCRIPTION
DATABASE MANAGEMENT SYSTEMS/BM-302
Course Title: DATABASE MANAGEMENT SYSTEMS
Credits 4 ECTS 6
Semester 6 Compulsory/Elective Compulsory
COURSE INFO
 -- LANGUAGE OF INSTRUCTION
  Turkish
 -- NAME OF LECTURER(S)
  Assoc.Prof. Nursal ARICI
 -- WEB SITE(S) OF LECTURER(S)
  http://websitem.gazi.edu.tr/site/nursal
 -- EMAIL(S) OF LECTURER(S)
  nursal(at)gazi.edu.tr
 -- LEARNING OUTCOMES OF THE COURSE UNIT
Learning database systems, models and SQL language and gaining the skill of the practice
 -- 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  Components of database systems, Data Base Management Systems, (DBMS) functions, architecture
2. Week  Data independency, data models, conceptual models
3. Week  Object oriented models and relational data model.
4. Week  Convertion of conceptual schemas to relational schemas, relational algebra and relational calculation
5. Week  Connections, key types, functional dependency
6. Week  Normal forms, multi-value dependency and database design.
7. Week  Using SQL ; data description, relational questioning, data organization
8. Week  Using SQL with applications and update of designed database
9. Week  Midterm Exam
10. Week  Build up a process, characteristics of productivity, detection of probabilities, reliability degrees, synchronicities using SQL
11. Week  Faults and their solutions, protection degrees, distributed data storage, distributed data process, distributed data model
12. Week  Simultaneous control, homogeneous and heterogeneous solutions.
13. Week  File structures, index files, complex (hash) files, signature files
14. Week  Binary tree, multi-index files, variable compatible registered files.
15. Week  Applications
16. Week  Final
 -- RECOMMENDED OR REQUIRED READING
  - Silberschatz, A, (1997), Database System Concepts, McGraw-Hill - Yarımağan, Ü, (2000), Veritabanı Sistemleri, Akademi Kitabevi - Course notes
 -- PLANNED LEARNING ACTIVITIES AND TEACHING METHODS
  Lecture, Question & Answer, Demonstration, Drill - Practise
 -- WORK PLACEMENT(S)
  No
 -- ASSESSMENT METHODS AND CRITERIA
 
Quantity
Percentage
 Mid-terms
1
20
 Assignment
0
0
 Exercises
0
0
 Projects
1
10
 Practice
1
10
 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
3
42
 Practising Hours of Course Per Week
0
 Reading
0
 Searching in Internet and Library
0
 Designing and Applying Materials
0
 Preparing Reports
16
3
48
 Preparing Presentation
0
 Presentation
1
10
10
 Mid-Term and Studying for Mid-Term
1
8
8
 Final and Studying for Final
1
10
10
 Other
16
2
32
 TOTAL WORKLOAD: 
150
 TOTAL WORKLOAD / 25: 
6
 ECTS: 
6
 -- COURSE'S CONTRIBUTION TO PROGRAM
NO
 PROGRAM LEARNING OUTCOMES
1
2
3
4
5
1Gaining the necessary theoretical and applied knowledge on engineering, mathematics, and science, skills for determining, defining and formulating computer engineering problems.X
2Gaining the ability to choose and apply appropriate analysis, modeling and design methods in computer engineering problems.X
3Gaining the ability to design a system, process or product related to computer engineering for a specific given purpose, gaining the ability to apply modern design tools.X
4Gaining the ability to evaluate the issues of security, robustness, adaptability, economy, ecological problems and sustainability in engineering solutions under realistic constraints and conditions.X
5Gaining the ability of simulation, experimenting, design, interpreting results for analysis and solution of computer engineering problems. Gaining the ability of analyzing of data for real problems which are need of industry.X
6Gaining the ability to use contemporary techniques and tools, information technologies for engineering applications.X
7Gaining the ability to work efficiently as individual or in a group in computer engineering discipline or in interdisciplinary studies. Gaining the ability to act independently, to use initiative when needed, and to be creative.X
8Gaining the ability to communicate efficiently by expressing his/her opinions in Turkish verbally or in written form in a concise manner. Gaining ability to efficiently use at least a foreign language in his/her proficiency.X
9Gaining the ability to grasp the significance of the concepts in areas such as business entrepreneurship, innovation and gaining ability for planning and management of a project.X
10Gaining the ability of awareness about self-renewal concept by comprehending the necessity of lifelong learning.X
11Gaining the ability to have professional and ethical responsibility.X
12The development of personality such as self-confidence, undaunting in the face of difficulties, consistency and patience.X
13Awareness about problems concerning with social, economic, environmental, etc. in our age and realization of the engineering profession by keeping mind in the responsibility which is related the awareness.X