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

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSOCIATE PROFESSOR FIDAN NURIYEVA

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, History of Database, Data Types
2 Data models, Relational Data Model, Relations, Relation types
3 Database Management System, Database Administrator and tasks, Introduction to MS Access, tables, relations, queries
4 Normalization
5 ER Diagrams
6 SQL - Structured Query Language, Introduction to MS SQL Server, database, table creation
7 SQL Applications
8 Midterm exam
9 SELECT statement
10 WHERE statement
11 CREATE TABLE, INSERT INTO, UPDATE, DELETE, DROP statements
12 SQL exercises
13 UNION and JOIN operations
14 SQL exercises

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 MTE MIDTERM EXAM
2 FIN FINAL EXAM
3 FCG FINAL COURSE GRADE MTE * 0.40 + FIN * 0.60
4 RST RESIT
5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + FIN * 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)

fidan.nuriyeva@deu.edu.tr

Office Hours

Will be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 4 52
Preparations before/after weekly lectures 12 3 36
Preparation for midterm exam 1 35 35
Preparation for final exam 1 37 37
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) 164

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