COURSE UNIT TITLE

: DATABASE 1

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BLP 4103 DATABASE 1 COMPULSORY 3 1 0 4

Offered By

Computer Programming

Level of Course Unit

Short Cycle Programmes (Associate's Degree)

Course Coordinator

DOCTOR ÖZER KESTANE

Offered to

Computer Programming
Computer Programming (Evening)

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   Design Database
2   Setup Database
3   Execute database queries
4   Sub-programs use the database
5   Perform database management functions

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Database Requirements Analysis, Normalization
2 Normalization
3 Normalization
4 Database setup Tables and attributes setup
5 Tables and attributes setup
6 Tables and attributes setup. Creating and Using Query Varieties
7 Midterm Exam
8 Midterm Exam
9 Queries related with multiple tables
10 Data Manipulation Language querries
11 Data Manipulation Language querries. User queries.
12 Writing View Queries. Writing Triger Queries.
13 Writing Trigger Queries. Writing Sub-Programme Queries.
14 Make Process Transaction. Writing Queries Index.

Recomended or Required Reading

The main source:Veri Tabanı ve Yönetimi, A.M. Ateş,Ö.Kestane, C.E.S. Enternasyonel Bookstore, Izmir, 2004.
Auxiliary source:Veri Tabanı Yönetim Sistemleri 1, Turgut Özseven, Ekin Basım Yayın. internet. computer lab.
Other course materials: Database servers.

Planned Learning Activities and Teaching Methods

1. Lectures
2. Example applications that make

Assessment Methods

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


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

Further Notes About Assessment Methods

None

Assessment Criteria

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

Language of Instruction

Turkish

Course Policies and Rules

70% of the classes is compulsory to attend. Disciplinary investigation will be concluded with the opening of any act of dishonesty.

Contact Details for the Lecturer(s)

Ph.D. Özer Kestane
Telefon: +90 232 301 26 21
E-posta:ozer.kestane@deu.edu.tr

Office Hours

Wednesday 08:30-10:10

Work Placement(s)

None

Workload Calculation

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

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.11111
LO.21111
LO.311111
LO.41111
LO.51111