COURSE UNIT TITLE

: COMPUTER PROGRAMMING FOR DATA MANAGEMENT

DEGREE PROGRAMMES

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 (English)

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

DOCTOR VOLKAN ÖĞER

Offered to

Mathematics (Evening)
Mathematics (English)

Course Objective

To teach the concepts of data, database and relational database, to create a relational database and to process the data in this database with the help of SQL.

Learning Outcomes of the Course Unit

1   Have a good understanding of database and relational database concept.
2   Being able to create a relational database.
3   Being able Selecting, inserting, deleting and updating datas using SQL.
4   Being able to create view.
5   Being able to write a procedure.

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, relational database.
2 Creating a database for a project - 1
3 Creating a database for a project - 2
4 Adding record; INSERT INTO Delete record; DELETE
5 Update data; UPDATE
6 Collecting data; SELECT, WHERE, ORDER BY
7 Collecting data; JOIN, LEFT / RIGHT JOIN
8 Midterm Exam
9 Collecting data; UNION
10 Collecting data; GROUP BY, HAVING
11 VIEW
12 Stored Procedures
13 Transaction
14 Project presantations - 1
15 Project presantations - 2

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

Planned Learning Activities and Teaching Methods

Lectures, Lecture notes and applicaitons.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 VZ Vize
2 ODV Ödev
3 SN Sunum
4 FN Final
5 BNS BNS VZ * 0.20 + ODV * 0.20 + SN * 0.20 + FN * 0.40
6 BUT Bütünleme Notu
7 BBN Bütünleme Sonu Başarı Notu VZ * 0.20 + ODV * 0.20 + SN * 0.20 + BUT * 0.40


Further Notes About Assessment Methods

HOMEWORK :
Students will be divided into groups.
They will create a relational database on the topics they choose.
They will make the necessary views regarding this database and write the necessary stored procedures.
They will enter data into this database.
PRESENTATION:
They will demonstrate and explain their database in front of other students.
They will try to write SQL sentences according to the requests of other students and the instructor.

Assessment Criteria

If your final grade or average is lower than 20, you will be excluded from evaluation and fail (FF).

Language of Instruction

English

Course Policies and Rules

Homework presentations will be made in the 14th and 15th weeks. Attendance at these classes is mandatory for everyone.

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 2 28
Preparation for midterm exam 1 15 15
Preparation for final exam 1 20 20
Preparing assignments 1 48 48
Preparing assignments 0 0 0
Final 1 2 2
Midterm 1 2 2
Project Final Presentation 1 1 1
TOTAL WORKLOAD (hours) 172

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13
LO.142543
LO.25323
LO.3335344
LO.4535
LO.55555555555555

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