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


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

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