COURSE UNIT TITLE

: DATABASE MANAGEMENT

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BIL 2004 DATABASE MANAGEMENT COMPULSORY 2 2 0 5

Offered By

Computer Science

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

INSTRUCTOR ALPER VAHAPLAR

Offered to

Computer Science

Course Objective

Targets of this course includes preparing student to be able to design, create and use a database system and applications for an organization. Primary objectives are user requirements analysis, normalization, conceptual and physical database design, understanding of data definition and data manipulation for relational and other database models, to have experience in database management applications and using SQL.

Learning Outcomes of the Course Unit

1   Learning data and database concepts
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, Data Types
2 Data models, Relational Data Model
3 Relations - Relation types
4 Database Management System, Database Administrator and tasks
5 Normalization
6 ER Diagrams
7 SQL Structured Query Language, SELECT statement
8 Midterm Exam
9 UNION and JOIN operations
10 SQL exercises
11 CREATE TABLE, INSERT INTO, UPDATE, DELETE, DROP statements
12 Introduction to MS Access, tables, relations, queries
13 Introduction to MS SQL Server, database and table creation, user operations, View, Trigger, Stored Procedures
14 Database operations with C# Forms

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

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


Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

Students will come to the class in time. Attending the 70% of the classes are mandotary.

Contact Details for the Lecturer(s)

alper.vahaplar@deu.edu.tr
ugur.eliiyi@deu.edu.tr

Office Hours

Will be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 2 26
Tutorials 14 2 28
Preparations before/after weekly lectures 12 1 12
Preparation for midterm exam 1 15 15
Preparation for final exam 1 20 20
Preparing assignments 1 15 15
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 120

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13
LO.1423
LO.2523432
LO.35335442
LO.45335352
LO.55355555