COURSE UNIT TITLE

: PRINCIPLES OF DATABASE DESIGN

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/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11
LO.153444
LO.24543
LO.34335
LO.44434543
LO.53543