COURSE UNIT TITLE

: DATABASE MANAGEMENT IN OCEANOGRAPHY

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
CZM 5039 DATABASE MANAGEMENT IN OCEANOGRAPHY ELECTIVE 3 0 0 7

Offered By

Graduate School of Natural and Applied Sciences

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

Offered to

COASTAL ZONE MANAGEMENT

Course Objective

In this course the necessity of an oceanographic database, and its types will be
introduced. The database is a system that data are defined according to the main
components of the oceanographic management strategy. It follows that planning a
database is largely a matter of how much data of what type is needed and how to store
and retrieve it. The usability of the database depends on the accuracy of the
monitoring program, adherence to it, and the dynamic strategy building. It covers
sampling and parameter analysis; data entry and verification schemes; data refining
techniques; data queries, statistical and scientific analysis; and data presentation.

Learning Outcomes of the Course Unit

1   able to understand the importance of database
2   able to reach quickly and easily to requested data through the database system
3   able to build a database table acording to the different type of data set
4   able to understand to combine the tables through the relationships in oceanographic database

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 INTRODUCTION TO DATABASE Description of database and its crusial isues Tables and oceanographic parameters and fields
2 OVERVIEW Overviewing Oceanographic studies Purposes of the data and database plan The need for Database Management
3 SYSTEMATIZATION OF OCEANOGRAPHIC RESEARCH PROJECTS Systematization of studies Data flow chart
4 OVERVIEW OF DATA STRUCTURE AND ALGORITMS Data Types, Structure ANSI data flow chart diagramms Oceanographic Data Formating
5 ORGANIZATION OF OCEAN DATABASE Physical Organization in Oceanographic database Organizations of Tables Primary key Determination the relationships in Oceanographic database
6 DATA MANUPULATION FROM OCEANOGRAPHIC DATABASES Specifying the criteria Sorting Searching
7 QUERIES General Forms of Commands in Structured Query Language (SQL) Creating simple queries
8 MIDTERM
9 QUERIES (cont) Select Command OR and AND criteria for different field Ordering and gruping data
10 OCEANOGRAPHIC DATA PRESENTATION
11 PROBLEMS and EXERCISE in FoxPro (SQL)
12 PROBLEMS and EXERCISE in FoxPro (SQL cont.)
13 PROBLEMS and EXERCISE in FoxPro (data control)
14 PROBLEMS and EXERCISE in FoxPro (simple statistical analysis and data presentation)

Recomended or Required Reading

Stamber D.,Price W.; 1990,Database Design and Management an Applied Approach, McGRAWHILL,
ISBN 0-07-100934-5
Şen, A., Şenyay, L., 1995: Sistem Analizi ve Veritabanı Tasarımı.
Intergovernmental Oceanographic Commission ( of UNESCO), 1995: Software for Management
and International Exchange of Oceanographic Data.
INTERGRAPH, 1989: Oracle SQL Report Writer Reference Manual.
MICROSOFT, 1996: Visual FOXPRO.
Main, M. and Savitch, W.,1995: Data Structures and other Objects.
United Nations Environmental Programme, 1992: Computerization of MED POL Data.

Planned Learning Activities and Teaching Methods

Lectures will be held conventionaly. The applications will be prepared using FOX-PRO
database program.

Assessment Methods

To be announced!


Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Prof. Dr. Erdem SAYIN
Institute of Marine Sciences and Technology
erdem.sayin@deu.edu.tr

Office Hours

will be announce at the first lecture

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Preparations before/after weekly lectures 13 3 39
Preparation for midterm exam 1 10 10
Preparation for final exam 1 20 20
Preparing assignments 1 40 40
Preparing presentations 1 10 10
Reading 10 2 20
Midterm 1 3 3
Final 1 3 3
TOTAL WORKLOAD (hours) 184

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.13222222245
LO.23334334345
LO.33334334345
LO.43445335345