Description of Individual Course Units
Course Unit CodeCourse Unit TitleType of Course UnitYear of StudySemesterNumber of ECTS Credits
9201115092005Database ManagementElective117
Level of Course Unit
Second Cycle
Objectives of the Course
Aim of this course to give fundamental information on database management and spatial databases. Also gives basic skills to create a databases.
Name of Lecturer(s)
Dr. İlhan EKİNCİOĞLU
Learning Outcomes
1Use SQL to establish a database
2Design databases in GIS context
3Understand the spatial database systems
4Design simple database models
5Understand the spatial data models, spatial query languages, database architecture, database technology for spatial database systems
Mode of Delivery
Face to Face
Prerequisites and co-requisities
None
Recommended Optional Programme Components
None
Course Contents
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
Weekly Detailed Course Contents
WeekTheoreticalPracticeLaboratory
1Introduction to database conceptLecture
2Spatial data models ILecture
3Spatial data models IILecture
4Foundations of database systemsLecture
5Database development and implementationLecture
6Relational database modelsLecture + practise
7Logic databasesLecture + practise
8Physical design of databasesLecture + practise
9Midterm Exam
10Database SchemasLecture
11Spatial databasesLecture + practise
12Spatial data standardsLecture
13Web based spatial databasesLecture + practise
14Data miningLecture + practise
15FieldworkPractise
16Final Exam
Recommended or Required Reading
Jeffrey A. Hoffer, Modern Database Management, Prentice Hall, 2005. Yeung, A.K.W., and Hall, G.Brent, Spatial Database Systems, Springer, 2007
Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight
SUM0
End Of Term (or Year) Learning ActivitiesQuantityWeight
SUM0
SUM0
Language of Instruction
Turkish
Work Placement(s)
None
Workload Calculation
ActivitiesNumberTime (hours)Total Work Load (hours)
Midterm Examination144
Final Examination144
Attending Lectures15460
Practice8432
Field Trip166
Self Study8432
Individual Study for Mid term Examination5420
Individual Study for Final Examination5420
Reading8432
TOTAL WORKLOAD (hours)210
Contribution of Learning Outcomes to Programme Outcomes
PO
1
PO
2
PO
3
PO
4
PO
5
PO
6
PO
7
PO
8
PO
9
PO
10
PO
11
PO
12
PO
13
PO
14
LO1              
LO2              
LO3              
LO4              
LO5              
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High
 
Ege University, Bornova - İzmir / TURKEY • Phone: +90 232 311 10 10 • e-mail: intrec@mail.ege.edu.tr