Dokuz Eylül University Information Package / Courses Catalog

Description of Individual Course Units

Course Unit Code	Course Unit Title	Type Of Course	D	U	L	ECTS
CSE 5021	PRINCIPLES OF DATABASE DESIGN	ELECTIVE	3	0	0	7

Offered By

Graduate School of Natural and Applied Sciences

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

ASSOCIATE PROFESSOR SEMIH UTKU

Offered to

Computer Engineering (Non-Thesis-Evening) (English)
Computer Engineering Non-Thesis (English)
Computer Engineering (English)
Computer Engineering (English)
COMPUTER ENGINEERING (ENGLISH)

Course Objective

Covers the concepts and principles of parallel and distributed database systems, real-time database systems and information retrieval systems. Included in the study, a historical review of database systems, development and normalization of database systems, and methods to query database systems are investigated.

Learning Outcomes of the Course Unit

1	Prepare a physical relational database schema for specific business applications
2	Distinguish the differences between relational, hierarchical and network databases
3	Recognize the strengths and weaknesses of relational databases vs the other types
4	Describe the responsibilities of a Database Administrator in an organization
5	Appreciate database systems performance issues

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week	Subject	Description
1	Overview of Databases
2	Relational Model
3	Database Design Methodology
4	Detailed Logical Design
5	Structured Query Language (SQL) Overview
6	Detailed Physical Database Design
7	Database Management System Features
8	Database Administrator Responsibilities
9	Professional, Legal and Ethical Issues / Security
10	Object Oriented Databases
11	Distrubuted Databases
12	Data Warehousing Concepts
13	Performance Monitoring
14	Principles of Data-Mining

Recomended or Required Reading

Textbook(s):
Connolly, T.M. & Begg, C.E. (2010). Database Systems: A Practical Approach to Design, Implementation and Management. Addison Wesley Publishing Company
Supplementary Book(s):
Ramakrishnan R., Gehrke J. " Database Management Systems ", Third Edition, McGraw-Hill, 2004.
Performance Dashboards; Measuring, Monitoring, and Managing your Business by Wayne W. Eckerson. John Wiley & Sons, Inc 2006.
References:
Materials:

Planned Learning Activities and Teaching Methods

Presentation/Lecturing and Interactive discussion

Assessment Methods

SORTING NUMBER	SHORT CODE	LONG CODE	FORMULA
1	MTE	MIDTERM EXAM
2	RPT	REPORT
3	PRS	PRESENTATION
4	FIN	FINAL EXAM
5	FCG	FINAL COURSE GRADE	MTE* 0.10 +RPT * 0.20 +PRS * 0.20 + FIN * 0.50
6	RST	RESIT
7	FCGR	FINAL COURSE GRADE (RESIT)	MTE* 0.10 +RPT * 0.20 + PRS * 0.20 + RST * 0.50

Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

English

Course Policies and Rules

Cheating, plagiarism (submitting another person s materials or ideas as one s own), or doing work for another person who will receive academic credit are all-impermissible.
Successfully complete all of the assignments and exercises.

Contact Details for the Lecturer(s)

Asst.Prof.Dr. Semih UTKU
Dokuz Eylul University
Department of Computer Engineering
Tinaztepe Campus 35160 BUCA/IZMIR
Tel: +90 (232) 301 74 01
e-mail: semih@cs.deu.edu.tr

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities	Number	Time (hours)	Total Work Load (hours)
Lectures	14	3	42
Preparations before/after weekly lectures	14	3	42
Preparation for final exam	1	8	8
Preparation for midterm exam	1	8	8
Preparing assignments	2	8	16
Preparing presentations	1	14	14
Field study	4	10	40
Final	1	3	3
Midterm	1	3	3
TOTAL WORKLOAD (hours)			176

Contribution of Learning Outcomes to Programme Outcomes

PO/LO	PO.1	PO.2	PO.3	PO.4	PO.5	PO.6	PO.7	PO.8	PO.10	PO.11
LO.1	5	3		4	4				4
LO.2	4	5					4		3
LO.3	4	3		3			5
LO.4			4	4		3	4	5	4	3
LO.5				3	5		4		3

COURSE UNIT TITLE

DEGREE PROGRAMMES

Description of Individual Course Units

Offered By

Level of Course Unit

Course Coordinator

Offered to

Course Objective

Learning Outcomes of the Course Unit

Mode of Delivery

Prerequisites and Co-requisites

Recomended Optional Programme Components

Course Contents

Recomended or Required Reading

Planned Learning Activities and Teaching Methods

Assessment Methods

Further Notes About Assessment Methods

Assessment Criteria

Language of Instruction

Course Policies and Rules

Contact Details for the Lecturer(s)

Office Hours

Work Placement(s)

Workload Calculation

Contribution of Learning Outcomes to Programme Outcomes

CONTACT INFORMATION