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
CSC 4202	COMPUTER PROGRAMMING FOR DATA MANAGEMENT	ELECTIVE	4	0	0	7

Offered By

Mathematics

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

DOCTOR VOLKAN ÖĞER

Offered to

Mathematics (Evening)
Mathematics

Course Objective

Database development using complex database programming techniques emphasizing multiple interrelated files, menu design, security implementation, and multiple access. Procedural SQL will be used to study control constructs, cursors, exception handlers, procedures, functions, and data warehousing.

Learning Outcomes of the Course Unit

1	Have a good understanding of database concept.
2	Developing the data model for the related field
3	Designing conceptual model of a database
4	Construction and administration of a database
5	Data manipulation and query by using SQL language

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week	Subject	Description
1	Database concepts: Table-Record-Data
2	Creating a database for a project
3	Adding record; INSERT INTO
4	Collecting data; SELECT, WHERE, ORDER BY
5	Update data; UPDATE
6	Delete record; DELETE
7	Collecting data; JOIN
8	Collecting data; LEFT / RIGHT JOIN
9	Collecting data; UNION
10	Collecting data; GROUP BY
11	Collecting data; HAVING
12	VIEW
13	Procedures
14	Transactions

Recomended or Required Reading

Textbook(s): Hansen, G. W., Hansen, J. V., Database Management and Design, Prentice Hall; 2nd edition, 1995
Supplementary Book(s): Ramakrishnan R. and Gehrke J., Database Management Systems, 3rd edition, 2007.
Silberschatz A., Korth, H. F., Sudarshan, S., Database System Concepts, 5th edition, McGraw-Hill, 2005
Access 2000, Yalçın Özkan, Gülser Acar Dondurmacı, ISBN:0000003576

Planned Learning Activities and Teaching Methods

Lectures, Lecture notes

Assessment Methods

SORTING NUMBER	SHORT CODE	LONG CODE	FORMULA
1	VZ	Vize
2	FN	Final
3	BNS	BNS	VZ * 0.40 + FN * 0.60
4	BUT	Bütünleme Notu
5	BBN	Bütünleme Sonu Başarı Notu	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

To be announced.

Language of Instruction

English

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

volkan.oger@deu.edu.tr

Office Hours

Will be announced.

Work Placement(s)

None

Workload Calculation

Activities	Number	Time (hours)	Total Work Load (hours)
Lectures	14	4	56
Preparations before/after weekly lectures	14	3	42
Preparation for midterm exam	1	30	30
Preparation for final exam	1	35	35
Preparation for quiz etc.	0	0	0
Preparing assignments	0	0	0
Final	1	2	2
Midterm	1	2	2
Quiz etc.	0	0	0
TOTAL WORKLOAD (hours)			167

Contribution of Learning Outcomes to Programme Outcomes

PO/LO	PO.1	PO.2	PO.3	PO.4	PO.5	PO.6	PO.7	PO.8	PO.9	PO.10	PO.11	PO.12	PO.13
LO.1								4	2	5		4	3
LO.2										5	3	2	3
LO.3							3	3		5	3	4	4
LO.4										5		3	5
LO.5	5	5	5	5	5	5	5	5	5	5	5	5	5

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