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

PROFESSOR EFENDI NASIBOĞLU

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. C# applications to access data from a database. Emphasizes Object-Oriented Programming (OOP) and database programming with ADO.NET and ASP.NET.

Learning Outcomes of the Course Unit

1   Have a good understanding of database concept.
2   Have ability to construct and manage database with using MS Access.
3   Have ability to use the procedural SQL.
4   Have ability to design and implement database applications with using ADO.NET.
5   Have ability to design and implement database applications with using ASP.NET.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 The Basic Concepts of Database Data, records, files, database concepts Types of database and database languages
2 Introduction to Access Database Access program interface The database wizard
3 Tables in Access (Storing Data) Using the table wizard Building a table by entering data
4 Tables in Access (Storing Data) (continues to ) Adding records Field names Quiz 1
5 Queries (Finding Data) What is a query Using the query wizard The query design tool
6 Forms (Viewing and Entering Data) Using the form wizard Creating different type of forms Forms performing calculations
7 7. Forms (Viewing and Entering Data) (continues to ) Multiple forms per table Querying from a form
8 Mid-term exam
9 Reports (Printing Data) Creating a report using the report wizard Printing a report
10 Introduction to Structured Query Language (SQL) Using SQL Using query analyzer
11 Introduction to Structured Query Language (SQL) (continues to..) Accessing a database using C#
12 Fundamental Database Programming with ADO.NET Connecting a database Executing database command Using datareader objects to read results Quiz 2
13 Fundamental Database Programming with ADO.NET (continues to ) Using dataset objects to store data Using dataset objects to modify data
14 Advanced Database Programming with ADO.NET Advanced transaction control Introducing web applications ASP.NET Using SQL servers XML support Web services

Recomended or Required Reading

Textbook(s):C# for Programmers, Harvey M. Deitel, Paul J. Deitel, ISBN: 9780137144150
SupplementaryBook(s):C# Programlama Dili ve Yazılım Tasarımı, Ahmet Kaymaz, ISBN: 9789756797839
Access 2000, Yalçın Özkan, Gülser Acar Dondurmacı, ISBN:0000003576

Planned Learning Activities and Teaching Methods

The course is taught in a lecture, class presentation and discussion format. Besides the taught lecture, group presentations are to be prepared by the groups assigned and presented in a discussion session. In some weeks of the course, results of the homework given previously are discussed.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 FIN FINAL EXAM
2 FCGR FINAL COURSE GRADE (RESIT) FIN * 1
3 RST RESIT
4 FCGR FINAL COURSE GRADE (RESIT) RST * 1


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)

e-mail: efendi.nasibov@deu.edu.tr Tel:(232) 3019511
e-mail: murat.berberler@deu.edu.tr Tel:(232) 3016514

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 15 15
Preparation for final exam 1 25 25
Preparation for quiz etc. 2 5 10
Preparing assignments 2 10 20
Final 1 2 2
Midterm 1 2 2
Quiz etc. 2 1 2
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