GAZI UNIVERSITY INFORMATION PACKAGE - 2019 ACADEMIC YEAR

COURSE DESCRIPTION
DATA BASE SYSTEMS AND PROGRAMS/İST-322
Course Title: DATA BASE SYSTEMS AND PROGRAMS
Credits 3 ECTS 5
Semester 6 Compulsory/Elective Elective
COURSE INFO
 -- LANGUAGE OF INSTRUCTION
  Turkish
 -- NAME OF LECTURER(S)
  Assoc.Prof.Dr.Bülent ALTUNKAYNAK
 -- WEB SITE(S) OF LECTURER(S)
  http://websitem.gazi.edu.tr/site/bulenta
 -- EMAIL(S) OF LECTURER(S)
  bulenta@gazi.edu.tr
 -- LEARNING OUTCOMES OF THE COURSE UNIT
Learning the structure and properties of a database .
Enhancing the ability to use information in the databases in real life.







 -- MODE OF DELIVERY
  The modes of delivery of this course are face to face and lab. application.
 -- PREREQUISITES AND CO-REQUISITES
  There is no prerequisite or co-requisite for this course.
 -- RECOMMENDED OPTIONAL PROGRAMME COMPONENTS
  Visual C
 --COURSE CONTENT
1. Week  Basic concepts
2. Week  Data modeling
3. Week  Access (Base)
4. Week  SQL
5. Week  MySQL
6. Week  Data Manipulation Language (DML)
7. Week  Data Definition Language (DDL)
8. Week  Data Control Language (DCL)
9. Week  MIDTERM EXAM.
10. Week  Connecting table
11. Week  Sub queries
12. Week  Reports
13. Week  SQL Server
14. Week  ORACLE
15. Week  ASP.NET and PHP
16. Week  FINAL EXAM
 -- RECOMMENDED OR REQUIRED READING
  Çağıltay, N.E., Tokdemir, G., “Veritabanı Sistemleri Dersi:Teoriden Pratiğe”, Seçkin Yayınevi, 2010. Daşdemir, Y., “Veri Tabanı Yönetim Sistemleri”, Türkmen Kitabevi, 2004. Şen, N.O. “Oracle: Sql, Sql*Plus,Pl/Sql ve Veri Tabanı Yönetimi”, Beta Yayınları, 2002.
 -- PLANNED LEARNING ACTIVITIES AND TEACHING METHODS
  Lecture and Lab. Application.
 -- WORK PLACEMENT(S)
  No
 -- ASSESSMENT METHODS AND CRITERIA
 
Quantity
Percentage
 Mid-terms
1
30
 Assignment
1
5
 Exercises
1
5
 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
3
42
 Practising Hours of Course Per Week
0
 Reading
3
1
3
 Searching in Internet and Library
6
3
18
 Designing and Applying Materials
3
5
15
 Preparing Reports
6
2
12
 Preparing Presentation
0
 Presentation
0
 Mid-Term and Studying for Mid-Term
3
5
15
 Final and Studying for Final
4
5
20
 Other
0
 TOTAL WORKLOAD: 
125
 TOTAL WORKLOAD / 25: 
5
 ECTS: 
5
 -- COURSE'S CONTRIBUTION TO PROGRAM
NO
PROGRAM LEARNING OUTCOMES
1
2
3
4
5
11. The statistical textbooks which include latest information about statistics, equipment and other resources supported by scientific approach on undergraduate level have theoretical and practical knowledge.X
22. Statisticians by using knowledge and skills acquired at bachelor degree level model, analyze, and interpret datasets.X
33. Statisticians identify and analyze the problems with current developments in statistic and also develop solutions based upon researches and proofs.X
44. Statisticians apply theoretical and practical knowledge acquired in Statistics at bachelor degree level to the current problems.X
55. Statisticians have the ability to use computer software and computing technology at the certain level required by statistics field.X
66. Statisticians take responsibility at disciplinary and interdisciplinary studies as an individual or a team member.X
77. Statisticians must have knowledge and ability to follow development in the field of Statistics, and must develop life long-learning attitudes.X
88. By using a foreign language, statistician can keep track of every statistical information, and communicate with colleagues.X
99. Applying the statistical knowledge in the professional sense, statistician has social, scientific, and ethical values.X
1010. A statistician must have the ability to social sensitivity and socialization.X
1111. During the process of inference, a statistician uses time efficiently with the analytical thinking ability.X