|
Week
|
Topics
|
Study Metarials
|
|
1
|
Introduction: Database Concepts
|
R1
|
|
2
|
Database management system structure, function and features
|
R1
|
|
3
|
Data Models
|
R1
|
|
4
|
Relational database concepts
|
R1
|
|
5
|
Relational database design
|
R1
|
|
6
|
Design methods and implementation
|
R1
|
|
7
|
Object Oriented Data Model
|
R1
|
|
8
|
Design methods and implementation
|
R1
|
|
9
|
Design methods and implementation
|
R1
|
|
10
|
Design methods and implementation
|
R1
|
|
11
|
SQL
|
R1, SR, SR2, SR3
|
|
12
|
SQL
|
R1, SR, SR2, SR3
|
|
13
|
SQL
|
R1, SR, SR2, SR3
|
|
14
|
Revision and assesment
|
R1, SR, SR2, SR3
|
|
Prerequisites
|
-
|
|
Language of Instruction
|
Turkish
|
|
Responsible
|
Doç. Dr. Burcu Umut ZAN
|
|
Instructors
|
-
|
|
Assistants
|
-
|
|
Resources
|
R1 Nizam, Ali.Veritabanı Tasarımı İlişkisel Veri Modeli ve Uygulamaları,Papatya Bilim, 2011
|
|
Supplementary Book
|
SR1.Elmasri, Ramez ve Shamkat B. Navathe.Fundamentals of Datase Systems.6th ed. Boston: Addison Wesley, 2011.
SR2.Congar, Stewe. Hands-on Database;an introduction to database design and development.Boston: Prentice Hall,2012-
SR3.Powell, Calvin. Beginning Database Design. Indiana, Wiley Publishing Inc., 2006
|
|
Goals
|
Basic concepts related to database systems and data models(relational model, object-oriented model). Design methods (NIAM, Normalization and E-R model) and SQL
|
|
Content
|
Foundations of Database systems, Databese development and implementation, Relational database models, Logic databases, Physical design of databases, Spatial databases, spatial data standards, web-enabled spatial databases, data mining
|
|
Program Learning Outcomes |
Level of Contribution |
|
1
|
Recognizing and comprehending the terms and concepts (Turkish and foreign) regarding information and records management
|
-
|
|
2
|
Provision of sensitivity training for social, economic and cultural changes with ability of making analysis in terms of professional perspective.
|
-
|
|
3
|
To be aware of problems regarding discipline through assessment, and critical thinking and finally, create solutions.
|
-
|
|
4
|
Improving the ability and capacity of systematic thinking.
|
5
|
|
5
|
Developing an interdisciplinary perspective and evaluation.
|
3
|
|
6
|
Establishing programs leads to information awareness in the society meeting following requirements: enable individuals describe their needs of information and improve ability to find out and evaluate information for themselves.
|
-
|
|
7
|
Building foundations that is required for information retrieval selectively and comprehend related techniques and methods
|
-
|
|
8
|
Evaluating information retrieval process in national and international information systems
|
-
|
|
9
|
Recognizing a variety of information sources (general and special) regarding all subject areas according to types and contents
|
-
|
|
10
|
Gaining the ability to read and evaluate records and sources in Ottoman language
|
-
|
|
11
|
Communicating with reel and potential users
|
-
|
|
12
|
Foundations of conceptual knowledge of services with respect to types of information centers and their users
|
-
|
|
13
|
Gaining the ability to use techniques required for organization of information
|
-
|
|
14
|
Recognizing products, systems and models related with information and communication technologies and enhancing use of them.
|
5
|
|
15
|
Gaining the ability to measure the quality of digital knowledge by various disciplines and evaluate information services.
|
4
|