COURSE UNIT TITLE

: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
ERA 2702 INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS ELECTIVE 2 2 0 4

Offered By

Management Information Systems

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

PROFESSOR DOCTOR VAHAP TECIM

Offered to

Management Information Systems

Course Objective

The course aims to inform about database and database management systems.

Learning Outcomes of the Course Unit

1   Recognizing the database and management practices of databases.
2   Identifying requirements of the database.
3   Comparing different database products and choosing the correct one according to necessities.
4   Performing the database design.
5   Connecting the database with related software.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Concept of Database
2 Database Structure
3 Basic and Advanced Topics
4 Basic Principles and Design
5 Tables
6 SQL Language
7 Queries
8 Mid-Term
9 Mid-Term
10 Queries
11 Relational Queries
12 Functions
13 Table and Database Transfer
14 Sample Applications

Recomended or Required Reading

Main Textbook: Veritabanı Ilkeleri ve Yönetim Sistemleri, Ahmet Vatansever, Deniz Mertkan Gezgin, Füsun Yavuzer Aslan, Murat Aslanyürek, Selma Bulut Büyükgüze, Paradigma Akademi Yayınları / Bilgisayar Kitapları Dizisi, 2013
Help book: Veritabanı Yönetim Sistemleri, Arzu Kilitçi, Savaş Özdemir, Selçuk Alp, Türkmen Yayınları / Bilgisayar Dizisi, 2011

Planned Learning Activities and Teaching Methods

Activities are given in detail in the Assessment Methods and Total Workload sections.

Assessment Methods

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


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

Further Notes About Assessment Methods

Students will undergo two exams, one mid-term and one final.

Assessment Criteria

Assessment criteria will be announced later.

Language of Instruction

English

Course Policies and Rules

The rules applied by the department are valid.

Contact Details for the Lecturer(s)

Contact details will be announced later.

Office Hours

Office hours will be announced later.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 12 3 36
Preparations before/after weekly lectures 12 3 36
Preparation for midterm exam 1 10 10
Preparation for final exam 1 15 15
Final 1 1 1
Midterm 1 1 1
TOTAL WORKLOAD (hours) 99

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13
LO.1555
LO.2555
LO.3555
LO.455555
LO.555555