Dokuz Eylül University Information Package / Courses Catalog

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

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	VZ0.40 + FN 0.60
4	RST	RESIT
5	FCGR	FINAL COURSE GRADE (RESIT)	VZ0.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/LO	PO.8	PO.10	PO.11	PO.12	PO.15
LO.1	1		1	1	1
LO.2	1		1	1	1
LO.3	1	1	1	1	1
LO.4	1		1	1	1
LO.5	1		1	1	1

COURSE UNIT TITLE

DEGREE PROGRAMMES

Description of Individual Course Units

Offered By

Level of Course Unit

Course Coordinator

Offered to

Course Objective

Learning Outcomes of the Course Unit

Mode of Delivery

Prerequisites and Co-requisites

Recomended Optional Programme Components

Course Contents

Recomended or Required Reading

Planned Learning Activities and Teaching Methods

Assessment Methods

Further Notes About Assessment Methods

Assessment Criteria

Language of Instruction

Course Policies and Rules

Contact Details for the Lecturer(s)

Office Hours

Work Placement(s)

Workload Calculation

Contribution of Learning Outcomes to Programme Outcomes

CONTACT INFORMATION