COURSE UNIT TITLE

: DATABASE MANAGEMENTS SYSTEMS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
ETC 5018 DATABASE MANAGEMENTS SYSTEMS ELECTIVE 3 0 0 5

Offered By

Electronic Trade

Level of Course Unit

Second Cycle Programmes (Master's Degree)

Course Coordinator

DOCTOR ÖZER KESTANE

Offered to

Electronic Trade

Course Objective

In this course students will gain the knowledge required to design, setup, query and manage a database.

Learning Outcomes of the Course Unit

1   Manage the Database Server
2   Design Database
3   Execute database queries
4   Sub-programs use the database

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Setting up of at least two server programs according to industry standards. Database management panel setup.
2 Normalization
3 Creating tables and attributes setup
4 Managing the diagram.
5 Creating and Using Query Varieties
6 Creating and Using Query Varieties
7 Midterm Exam
8 Using queries with multiple tables
9 Data Manipulation Language querries.
10 Data Manipulation Language querries. User queries.
11 Writing View Queries
12 Writing Trigger Queries
13 Writing Sub-Programme Queries.
14 Indexes

Recomended or Required Reading

Veritabanı Yönetim Sistemleri 1, Turgut Özseven, Ekin Basım Yayın
Veritabanı Eğitim Seti 2-5, Kodlab
Auxiliary source:internet, computer lab.
Other course materials: Database servers

Planned Learning Activities and Teaching Methods

1. Lecture
2. Example applications that make

Assessment Methods

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


Further Notes About Assessment Methods

None

Assessment Criteria

Mid-term exam and final exam to measure learning outcomes, and in-class applications with the four outcomes that will be followed in reaching the stage of the student.

Language of Instruction

Turkish

Course Policies and Rules

1. Attending at least 70 percent of lectures is mandatory.
2. Plagiarism of any type will result in disciplinary action.
3. Students are expected tp participate actively in class discussions.
4. Students are expected to attend to classes on time

Contact Details for the Lecturer(s)

ozer.kestane@deu.edu.tr
+9 0 232 301 26 21

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Preparations before/after weekly lectures 13 3 39
Preparation for midterm exam 1 15 15
Preparation for final exam 1 20 20
Midterm 1 1 1
Final 1 1 1
TOTAL WORKLOAD (hours) 115

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14PO.15
LO.111
LO.21111
LO.3111
LO.41111