COURSE UNIT TITLE

: DATABASE MANAGEMENT

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BIL 3203 DATABASE MANAGEMENT ELECTIVE 3 0 0 5

Offered By

Statistics

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSISTANT PROFESSOR ALPER VAHAPLAR

Offered to

Statistics
Statistics(Evening)

Course Objective

Target of this course is to teach students to design and use of database applications for companies. As primary aims of this course are user necessity analysis, normalization, designing logical and physical databases, data description for relational and other data models, understanding of data manipulation languages, obtaining experience in database applications and database management, learning SQL.

Learning Outcomes of the Course Unit

1   Constructing 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
2 Data Types
3 Data models, Relational Data Model
4 Database Management System, Database Administrator and tasks
5 Normalization
6 Normalization cont d
7 ER Diagram
8 Midterm Exam
9 SQL Structured Query Language, SELECT statement
10 SELECT statement cont d
11 UNION and JOIN operations
12 CREATE TABLE, INSERT INTO, UPDATE, DELETE, DROP statements
13 Introduction to MS Access, tables, relations, queries
14 MS Access Forms and reports

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
Materials:

Planned Learning Activities and Teaching Methods

Lecture, homework assignments, problem solving

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.20 + ASG * 0.40 + FIN * 0.40
5 RST RESIT
6 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.20 + ASG * 0.40 + RST * 0.40


*** 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

Student responsibilities
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

Office Hours

Will be announced

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Preparations before/after weekly lectures 12 1 12
Preparation for final exam 1 15 15
Preparing assignments 2 15 30
Preparation for midterm exam 1 15 15
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 115

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14
LO.14
LO.2433
LO.34343
LO.443343
LO.543543