INFORMATION TECHNOLOGIES (TURKISH, THESIS)
Master	TR-NQF-HE: Level 7	QF-EHEA: Second Cycle	EQF-LLL: Level 7

Course Introduction and Application Information

Course Code	Course Name	Semester	Theoretical	Practical	Credit	ECTS
YZM5507	Data Modelling and Relational Databases	Spring	3	0	3	8

This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester.

Basic information

Language of instruction:	Turkish
Type of course:
Course Level:
Mode of Delivery:	Face to face
Course Coordinator :	Prof. Dr. MEHMET ALPER TUNGA
Recommended Optional Program Components:	None.
Course Objectives:	Defining entities and relationships, modelling attributes and constraints, normalizing data model, constructing physical database from data models, defining the basics of relational database systems, indexing, developing applications through SQL queries, developing Oracle applications

Learning Outcomes

The students who have succeeded in this course;
1. Define entities and relationships
2. Construct data models
3. Describe relational databases
4. Construct physical databases
5. Design SQL queries
6. Develop Oracle DBMS applications

Course Content

The content of this course is composed of Introduction to relational databases, Relational database management systems, Entity relationship models, Data modelling and normalization, SQL: Data definition language, Built-in functions, SQL queries and Oracle objects.

Weekly Detailed Course Contents

Week	Subject	Related Preparation
1)	Introduction to relational databases
2)	Relational database management systems
3)	Entity relationship models
4)	Data modelling and normalization
5)	Data modelling and normalization
6)	SQL: Data definition language
7)	Basic SQL queries
8)	Basic SQL queries
9)	Built-in functions
10)	Built-in function / Midterm Exam
11)	Nested SQL queries
12)	Nested SQL queries
13)	Oracle objects
14)	Oracle objects

Sources

Course Notes / Textbooks:	Nilesh Shah, Database Systems using Oracle: A Simplified Guide to SQL and PL/SQL, 2ed, Pearson Prentice Hall, 2005, ISBN 0-13-191180-5
References:	Yok - None.

Evaluation System

Semester Requirements	Number of Activities	Level of Contribution
Project	1	% 30
Midterms	1	% 30
Final	1	% 40
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 30
PERCENTAGE OF FINAL WORK		% 70
Total		% 100

ECTS / Workload Table

Activities	Number of Activities	Duration (Hours)	Workload
Course Hours	14	3	42
Application	14	3	42
Study Hours Out of Class	14	3	42
Midterms	1	22	22
Final	1	41	41
Total Workload			189

Contribution of Learning Outcomes to Programme Outcomes

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Program Outcomes	Level of Contribution
1)	Follows the scientific literature in the field of Information Technology, critically analyzes it, and effectively utilizes it in solving complex IT problems.	4
2)	Designs, plans, implements, and manages original projects related to the field of Information Technology.	3
3)	Conducts independent studies in the field of Information Technology, assumes scientific responsibility, and evaluates the findings with a critical perspective.	3
4)	Presents the outcomes of research and projects effectively in written, oral, and visual forms, in accordance with academic and professional standards.
5)	Conducts independent research on specialized topics within the field, develops innovative and original ideas, and translates this knowledge into practice and technology.	2
6)	Effectively applies advanced theoretical knowledge and practical skills specific to the field of Information Technology; analyzes and develops current software, hardware, and system solutions.	5
7)	Acts in accordance with professional, scientific, and ethical principles; takes responsibility by considering the societal, environmental, and ethical impacts of IT applications.