1	Course Title:	DATABASE MANAGEMENT IN THE LAND CONSOLIDATION
2	Course Code:	BSM5011
3	Type of Course:	Optional
4	Level of Course:	Second Cycle
5	Year of Study:	1
6	Semester:	1
7	ECTS Credits Allocated:	6
8	Theoretical (hour/week):	3
9	Practice (hour/week) :	0
10	Laboratory (hour/week) :	0
11	Prerequisites:	None
12	Recommended optional programme components:	None
13	Language:	Turkish
14	Mode of Delivery:	Face to face
15	Course Coordinator:	Prof. Dr. ŞERİFE TÜLİN AKKAYA ASLAN
16	Course Lecturers:	Yok
17	Contactinformation of the Course Coordinator:	E-posta: akkaya@uludag.edu.tr Tel: (90) 224 29 41 625 Adres: Bursa Uludağ Üniversitesi Ziraat Fakültesi Biyosistem Mühendisliği Bölümü Görükle Kampüsü 16059 BURSA/ TÜRKİYE
18	Website:
19	Objective of the Course:	Land consolidation in data collection, database creation, data analysis and making interpersonal relationships, land consolidation and the use of databases in project planning stage, land grading, the account of the progress; interview study and the redistribution of land and the creation of new advanced information system using GIS techniques
20	Contribution of the Course to Professional Development	It will provide the ability to look at land consolidation studies from a wider perspective.

21

Learning Outcomes:

1 Understanding the importance of the database in the Land Consolidation; 2 Acquire the ability to do database design for the land consolidation, ; 3 Acquire the ability to use computer programs for the land consolidation;

22	Course Content:

Week	Theoretical	Practical
1	Data sources for land consolidation, acquisition of data, classification,
2	Use of orthophoto
3	The creation of relationships between data analysis
4	The design of the data base for planning the land consolidation
5	Making planning work with the database
6	Land consolidation of the planning data base, to be transferred to the project stage
7	Establishment of land grading map
8	Account the value of the parcel and block value
9	Account the value of the parcel and block value
10	The preferences of the owners work
11	Be transferred to the the preferences of the owners information and performing analysis of information systems - block making distribution
12	Block balancing - the making inside blocks parcel sorting
13	Establishment of redistribution map
14	Creating a new information system

23	Textbooks, References and/or Other Materials:	1. Arıcı, İ., Akkaya Aslan, Ş.T. 2010. Arazi Toplulaştırması, Planlama ve Projelemesi, Uludağ Üniversitesi Ziraat Fakültesi Ders Notları No:105, 205 S. 2. Takka, S.1993. Arazi Toplulaştırması, Kültürteknik Derneği Yayınları No:1, Ankara. 3. Çevik, B., Tekinel, O. 1987. Arazi Toplulaştırması, Çukurova Üni. Ziraat Fakültesi Yayınları no: 437, Ankara. 4. Demirel 1999, Arazi Toplulaştırma, Yıldız Teknik Üni. İşaat Fakültesi, Jeodezi ve Fotogrametri Müh. Böl Yayın No:YTÜ.IN.DN.-99.0486 İstanbul. 5. Läpple, E.C. 1992. Flurbereinigung in Europa, Landwirtschaftsverlag. 6. Gamperl 1972. Ländliche Neuordnung, Handbuch der Vermessungshunde, J.B. Metzlersche Verlagsbuchhandlung, Stuttgart.
24	Assesment

TERM LEARNING ACTIVITIES	NUMBER	PERCENT
Midterm Exam	0	0
Quiz	0	0
Homeworks, Performances	0	0
Final Exam	1	100
Total	1	100
Contribution of Term (Year) Learning Activities to Success Grade		0
Contribution of Final Exam to Success Grade		100
Total		100
Measurement and Evaluation Techniques Used in the Course	1 final exam 1 project assignment
Information	The average of 1 final exam and 1 project homework will be entered into the system as a midterm exam.

25

ECTS / WORK LOAD TABLE

Activites	NUMBER	TIME [Hour]	Total WorkLoad [Hour]
Theoretical	14	3	42
Practicals/Labs	0	0	0
Self Study and Preparation	10	4	40
Homeworks, Performances	0	10	50
Projects	1	40	40
Field Studies	0	0	0
Midtermexams	0	0	0
Others	0	0	0
Final Exams	1	15	15
Total WorkLoad			187
Total workload/ 30 hr			6,23
ECTS Credit of the Course			6

26	CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS
PQ1 PQ2 PQ3 PQ4 PQ5 PQ6 PQ7 PQ8 PQ9 PQ10 PQ11 PQ12 LO1 3 0 3 0 0 0 0 4 0 3 3 3 LO2 3 0 3 0 0 0 0 4 0 3 3 3 LO3 3 3 0 0 0 0 0 4 0 3 3 3

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High