COURSE UNIT TITLE

: DATABASE 1

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BLP 4119 DATABASE 1 COMPULSORY 2 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 Creating and Using Query Varieties
6 Creating and Using Query Varieties
7 Creating and Using Query Varieties
8 Midterm Exam
9 Queries related with multiple tables
10 Data Manipulation Language querries
11 Data Manipulation Language querries
12 User queries
13 Writing View Queries.
14 Writing Trigger Queries.
15 Writing Trigger Queries.

Recomended or Required Reading

Textbook(s): Veri Tabanı ve Yönetimi, A.M. Ateş,Ö.Kestane, C.E.S. Enternasyonel Kitabevi, Izmir, 2004.
Supplementary Book(s): Veri Tabanı Yönetim Sistemleri 2, Turgut Özseven,Ekin Yayınevi,2019.
SQL Server 2014& Veritabanı Programlama, Yaşar Gözüdeli, Seçkin Yayınevi, 2014.Internet, Bilgisayar lab.
References:
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


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 16:00-17:00

Work Placement(s)

None

Workload Calculation

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

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