Geomatics Engineering

Course Content

Course Name	DATABASES IN ENGINEERING
Semester	Course Code	Theory Practice Hours	ECTS
4	1205325	2 / 0	3

Course Level

Bachelor's Degree

Course Delivery Format

Face to face

Coordinator

Prof. Dr. Şükran Yalpır

Coordinator E-mail

syalpir ktun.edu.tr

Instructor

Prof. Dr. Şükran Yalpır

Course Assistant

Course Objective

The aim of this course is to introduce the basic database structure and to teach how to use the SQL language, which is the basic query language of database management systems, at a basic level.

Eng Destek Dersi	Eng İletişim ve Yönetim Becerileri Dersi
90	10

Instructional Methods
Lecture, Experimentation

Week	Course Content	Resource
1	Basic concepts in database	Veri Tabanlarına Giriş, Serdar ERGEN-Ender KELLECİ Veri Tabanı Yönetim Sistemleri, Zehra Alakoç Veri Tabanı Yönetim Sistemleri, Turgut ÖZSEVEN Veri Tabanı Sistemleri, Ünal YARIMAĞAN
2	Entity relationship model	Veri Tabanlarına Giriş, Serdar ERGEN-Ender KELLECİ Veri Tabanı Yönetim Sistemleri, Zehra Alakoç Veri Tabanı Yönetim Sistemleri, Turgut ÖZSEVEN Veri Tabanı Sistemleri, Ünal YARIMAĞAN
3	Relational Data Model
4	Relational Database Design
5	Relational Database Design Database Management Systems	Veri Tabanı Yönetim Sistemleri, Zehra Alakoç
6	Introduction to Relational Algebra Databases
7	SQL - Structured Query Language Database Management Systems
8	Using SQL Functions Database Management Systems
9	Analyzing Data by Grouping Database Systems
10	Introduction to Multiple Tables Databases
11	Introduction to Complex Queries Databases
12	DML (Data Manipulation Language) Database Management Systems
13	Database Objects Database Management Systems
14	Adding Limitations to Tables Introduction to Databases
15	Controlling User Access Database Management Systems
16	SQL - Introduction to Structured Query Language Application Databases

No	Course Outcomes (CO)	Percent
1	Ability to define basic concepts in databases	5
2	To be able to define the components of relational databases	5
3	To be able to comprehend database models	10
4	Ability to define database normalization	10
5	Ability to design database	20
6	Ability to use basic SQL language	50

	CO 1	CO 2	CO 3	CO 4	CO 5	CO 6
PO 1	5	5	10	10	10	10
PO 2	0	0	0	0	0	0
PO 3	0	0	0	0	0	0
PO 4	0	0	0	0	0	10
PO 5	0	0	0	0	0	0
PO 6	0	0	0	0	0	10
PO 7	0	0	0	0	0	0
PO 8	0	0	0	0	10	0
PO 9	0	0	0	0	0	0
PO 10	0	0	0	0	0	10
PO 11	0	0	0	0	0	0
PO 12	0	0	0	0	0	0
PO 13	0	0	0	0	0	0
PO 14	0	0	0	0	0	5
PO 15	0	0	0	0	0	0
PO 16	0	0	0	0	0	0
PO 17	0	0	0	0	0	0
PO 18	0	0	0	0	0	0
PO 19	0	0	0	0	0	0
PO 20	0	0	0	0	0	0
PO 21	0	0	0	0	0	0
PO 22	0	0	0	0	0	5
PO 23	0	0	0	0	0	0
PO 24	0	0	0	0	0	0
PO 25	0	0	0	0	0	0
PO 26	0	0	0	0	0	0
PO 27	0	0	0	0	0	0
PO 28	0	0	0	0	0	0
PO 29	0	0	0	0	0	0
PO 30	0	0	0	0	0	0

ECTS Workload	Number	Duration,Min	Total Workload
Weekly Lecture Hour (Theoretical)	28	45	1260
Weekly Practice/Lab Hour	0	0	0
Homework	0	0	0
Quiz	0	0	0
Material Design, Preparation	0	0	0
Field Studies	0	0	0
Report Preparation	1	600	600
Presentation	1	120	120
Project Making	1	1830	1830
Other Studies	0	0	0
Mid-Term exam and pre-study	1	360	360
Final Exam and pre-study	1	480	480

ECTS Workload	% of Mid-term Grading	% of Final Grading
Weekly Lecture Hour (Theoretical)	0	0
Weekly Practice/Lab Hour	0	0
Homework	0	0
Quiz	0	0
Material Design, Preparation	0	0
Field Studies	0	0
Report Preparation	10	0
Presentation	10	0
Project Making	30	0
Other Studies	0	0
Mid-Term exam and pre-study	50	0
Final Exam and pre-study	0	100

Geomatics Engineering

Department Course Content

Course Content