COURSE UNIT TITLE

: DATABASE MANAGEMENT SYSTEMS

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
YBS 8124 DATABASE MANAGEMENT SYSTEMS COMPULSORY 3 0 0 7

Offered By

Management Information Systems Non-Thesis(Distance Learning)

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

PROFESSOR DOCTOR ÇIĞDEM TARHAN

Offered to

Management Information Systems Non-Thesis(Distance Learning)

Course Objective

Types of databases, fundamentals of database concepts and database creation techniques will explained in this lecture. Students will gain logic of relational database and capability to use query lanquage .

Learning Outcomes of the Course Unit

1   To be able to design database by itself
2   To be able to design database procedures
3   To be able to inform about query lanquages
4   To be able to query between database tables with using query lanquages

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Introduction to Database Management - Database Management Systems Advantages and Disadvantages of Databases Sample Databases
2 Relational Model 1: QBE - Relational Databases - Entity Relationship Diagram - Simple Queries - Table Relationships
3 Relational Model 2: SQL - Creating a Table - Using Special Operators (LIKE, IN) - Functions - Grouping - Sorting
4 Relational Model 3: Advanced Topics - Updating a Table - Creating a Table with a Query - Structural Changes
5 Database Sample Application: Having
6 Date Functions
7 IF - CASE
8 JOIN Operations I
9 JOIN Operations II
10 Stored Procedure (Parameterized - Parameterless)
11 Trigger I
12 Trigger II
13 Normalization Functional Dependency First Normal Form Second Normal Form Third Normal Form Improper Decompositions Multi-Valued Addictions
14 Application

Recomended or Required Reading

Concepts of Database Management (Seventh Edition); Philip J. Pratt and Joseph J. Adamski; 2012

Planned Learning Activities and Teaching Methods

The activities are detailed in the 'Assessment Methods' and 'Workload Calculation' sections.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 FCG FINAL COURSE GRADE
3 FCG FINAL COURSE GRADE MTE * 0.20 + FIN* 0.80
4 RST RESIT
5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.20 + RST* 0.80


Further Notes About Assessment Methods

None

Assessment Criteria

Students' performances are measured with a midterm exam and a final exam.

Language of Instruction

Turkish

Course Policies and Rules

The rules applied by the department apply.

Contact Details for the Lecturer(s)

Dokuz Eylül Üniversitesi - I.I.B.F. Yönetim Bilişim Sistemleri Bölümü - Dokuzçeşmeler Kampüsü - Buca - IZMIR 35160
Tel: 0 232 301 07 62
e-mail: cigdem.tarhan@deu.edu.tr

Office Hours

It will 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 8 112
Preparation for midterm exam 1 9 9
Preparation for final exam 1 10 10
Final 1 1 1
Midterm 1 1 1
TOTAL WORKLOAD (hours) 175

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11
LO.155555555555
LO.255555555555
LO.355555555555
LO.455555555555

CONTACT INFORMATION
Dokuz Eylül Üniversitesi Cumhuriyet Bulvarı No: 144 35210 Alsancak / İZMİR
Phone: +90(232) 412 12 12 - Fax: +90 (232) 464 81 35

Copyright 2015 DEÜ. BİD

HOME / ABOUT US / DEGREE PROGRAMMES / GENERAL INFORMATION FOR STUDENTS / INTERNATIONAL RELATIONS