DATABASE MANAGEMENT PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
BIL309	DATABASE MANAGEMENT	5	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 :	Compulsory
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Assist.Prof. OĞUZHAN ÖZTAŞ
Instructor(s) of the Course Unit	Assist.Prof. OĞUZHAN ÖZTAŞ
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)
Define entities and relationships.
Construct data models
Describe relational databases
Construct physical databases
Construct SQL queries.
Develops applications in Database Management System.

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
Database Systems using Oracle: A Simplified Guide to SQL and PL/SQL, Nilesh Shah, Pearson Prentice Hall, 2005
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	Explains the fundamental engineering concepts of computer science and relates them to the groundwork of computer science.		1

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Uses theoretical and practical knowledge coming from mathematics, probability, statistics and various other branches of life sciences, to find solutions to engineering problems.			2

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Determines the components and the underlying process of a system and designs an appropriate computational model under reasonable constraints.					4
2	Designs a computer-aided conceptual model with modern techniques.				3

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Determines, detects and analyzes the areas of computer science applications and develops appropriate solutions.					4
2	Identifies, models and solves computer engineering problems by applying appropriate analytical methods.				3
3	Determines and uses the necessary information technologies in an efficient way for engineering applications.		1

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Possess the responsibility and ability to design and conduct experiments for engineering problems by collecting, analyzing and interpreting data.			2
2	Possess the ability to conduct effective individual study.		1
3	Takes responsibility as a team work and contributes in an effective way.			2

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Monitors the developments in the field of information technologies by means of internet and related journals and possess the required knowledge for the management, control, development and security of information technologies.					4
2	Develops positive attitude towards lifelong learning.				3

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Communicates effectively by oral and/or written form and uses at least one foreign language.					4
2	Possess sufficient consciousness about the issues of project management, practical applications and also environmental protection, worker's health and security.				3

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Possess professional and ethical responsibility and willingness to share it.		1
2	Possess sufficient consciousness about the universality of engineering solutions and applications and be well aware of the importance of innovation.			2

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	2	2	4
Preparation for the Short Exam	0	0	0
TOTAL	43	0	152