COURSE UNIT TITLE

: DATABASE AND MANAGEMENT SYSTEMS

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BIL 2004 DATABASE AND MANAGEMENT SYSTEMS COMPULSORY 3 1 0 4

Offered By

COMPUTER TECHNOLOGY

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

INSTRUCTOR DUYGU BAĞCI

Offered to

COMPUTER TECHNOLOGY

Course Objective

With this course, students, data base designing, creating, querying a database using the administrative functions of the gain qualifications.

Learning Outcomes of the Course Unit

1   Will be able to define the main concepts of data base
2   Can design database
3   Can creating the database
4   To be able to use database management systems.
5   Can query the database
6   Can use the database administrative functions

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Database Needs Analysis Normalization
2 Normalization
3 Normalization
4 Installing the Database Tools Creating Tables and Determine the Properties
5 Creating Tables and Determine the Properties
6 Create and Use The Kinds of Queries
7 1.Midterm Exam
8 Create and Use The Kinds of Queries
9 Prepare Tables Associated With The Query
10 Using DML Queries
11 User Queries Writing
12 Write to the View Queries
13 Write to The View Queries Writing Trigger Queries
14 Sub-Programme Writing Queries Transaction Processing Make Writing Queries Index

Recomended or Required Reading

Lecture notes, prepared by the teaching staff.
Veri Tabanı ve Yönetimi, A.M. Ateş,Ö.Kestane, C.E.S. Enternasyonel Kitabevi, Izmir, 2004
Uysal, Mithat, SQL Veri Tabanı Sorgulama Dili, ISTANBUL: Beta Basım (2001) NAVATHE, B., (2009) Fundamentals of Database Systems 6e : Global Edition, Pearson Education , ISBN: 9780132144988 Plew R., Stephens, R., (2003), Herkes Için 24 Saatte Veritabanları, Alfa Basım Yayım Dağıtım, ISBN No: 9752974295 Çamoğlu, K., (2009), Programlama & Veritabanı Mantığı, Kodlab Yayın Dağıtım, ISBN No: 9786054205127 Burma, Z. (2009), Veritabanı Yönetim Sistemleri ve SQL/PL-SQL/T-SQL, Seçkin Yayınev, ISBN No: 9789750210556 Öztürk, A. (2003), Oracle Veri Tabanı Yönetim Sistemi, Nobel Yayınevi, ISBN No: 975-6574-31-3

Planned Learning Activities and Teaching Methods

1-Lecture
2-DVD, video vb.
3-Practice

Assessment Methods

Successful / Unsuccessful


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

Further Notes About Assessment Methods

It is calculated by taking 40% average grade of Midterm exams , 60% of the final exam success rating.

Assessment Criteria

The understanding degree of students to 6 learning outputs is evaluated by midterm and final exams.

Language of Instruction

Turkish

Course Policies and Rules

1.70% of participation in the courses is mandatory
2.All kinds of plagiarism (cheating) initiative, and the actual results in disciplinary action

Contact Details for the Lecturer(s)

Öğr. Gör. Duygu BAĞCI
duygu.bagci@deu.edu.tr
Tel: 0232 632 12 48 / 121

Office Hours

It will be announced later.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Tutorials 13 1 13
Preparations before/after weekly lectures 13 2 26
Preparation for midterm exam 1 13 13
Preparation for final exam 1 16 16
Midterm 1 2 2
Final 1 2 2
TOTAL WORKLOAD (hours) 111

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.1555533333
LO.2555533333
LO.3555533333
LO.4555533333
LO.5555533333
LO.6555533333

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