DATABASE MANAGEMENT PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
BIL309	DATABASE MANAGEMENT	8	4	3	6

GENERAL INFORMATION
Language of Instruction :	Turkish
Level of the Course Unit :	BACHELOR'S DEGREE, TYY: + 6.Level, EQF-LLL: 6.Level, QF-EHEA: First Cycle
Type of the Course :	Elective
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Prof. TARIK ÇAKAR
Instructor(s) of the Course Unit
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	To teach the students defining entities and relationships, modelling attributes and constraints, normalizing data model, constructing physical database from data models, defining the basics of relational database systems, developing applications through SQL queries.
Contents of the Course Unit:	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.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
The students who take the course will be able to; I. Define entities and relationships II. Construct data models III. Describe relational databases IV. Construct physical databases V. Design SQL queries VI. Develop Oracle DBMS applications

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	-	Importance of data, data management, and data management systems	-
2	-	Defining the problem and gathering data	-
3	-	Introduction to relational databases	-
4	-	Relational database management systems	-
5	-	Data Models	-
6	-	Entity - Relationship Diagrams	-
7	-	Data Modeling and Normalization	-
8	-	MID-TERM EXAM	-
9	-	SQL: Data Definition Language	-
10	-	Simple SQL queries	-
11	-	Built-in SQL functions	-
12	-	Complex SQL queries	-
13	-	Triggers	-
14	-	Indexes and how to use them	-
15	-	Other data models: XML, Text, and multimedia	-
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
1. Database Systems using Oracle: A Simplified Guide to SQL and PL/SQL, Nilesh Shah, Pearson Prentice Hall, 2005 2. Database Systems: A Practical Approach to Design, Implementation and Management, Thomas M. Connolly, Carolyn E. Begg, Pearson, 2014

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description

Level of Contribution
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Gain sufficient knowledge in Mathematics, Science and Industrial Engineering.				3

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Analyzes and evaluates existing application areas in the field of Industrial Engineering and develops applications for their solutions.					4

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Analyzes a system, the components of that system, the process of that system, and designs the system by examining it in line with realistic constraints and goals.						5
2	Gains the ability to model and solve engineering problems.				3

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Identifies the problems that may be encountered in the field of industrial engineering and acquires the ability to choose and apply the appropriate method to be used in problem solving.				3
2	Selects and uses technical tools necessary for industrial engineering applications; uses information technologies effectively.						5
3	Designs experiments, conducts experiments, collects data, analyzes and interprets the results to examine problems in the field of industrial engineering.				3

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Gains the ability to work effectively within a team.					4
2	Works effectively individually and takes responsibility.						5

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Accesses the necessary information for a determined problem and searches for resources for this purpose.			2
2	Has the ability to follow all developments in the field of industrial engineering and constantly renew itself.			2

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Gains oral and written communication skills and speaks at least one foreign language.				3

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Has awareness of professional and ethical responsibility.					4
2	Has knowledge about the universal and social effects of industrial engineering applications and reaches solutions by being aware of the importance of an innovative approach in solving engineering problems.					4

WORKLOAD & ECTS CREDITS OF THE COURSE UNIT
Workload for Learning & Teaching Activities
Type of the Learning Activites	Learning Activities (# of week)	Duration (hours, h)	Workload (h)
Lecture & In-Class Activities	14	4	56
Preliminary & Further Study	14	3	42
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	4	4	16
Project Work	0	0	0
Seminar	0	0	0
Internship	0	0	0
Technical Visit	0	0	0
Web Based Learning	0	0	0
Implementation/Application/Practice	0	0	0
Practice at a workplace	0	0	0
Occupational Activity	0	0	0
Social Activity	0	0	0
Thesis Work	0	0	0
Field Study	0	0	0
Report Writing	0	0	0
Final Exam	1	1	1
Preparation for the Final Exam	4	5	20
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	3	4	12
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	41	0	148