DATABASE MANAGEMENT SYSTEMS

BİS502

Course Code: BİS502
Semester: Second Term (Spring)
Theory+Practice: 2 + 2
ECTS: 10

Course Type

Compulsory Course

Course Level

Master's Degree Without Thesis

Year of Study

Semester

Second Term (Spring)

ECTS

Name of Lecturer(s)

Professor Mustafa Sert

Learning Outcomes

At the end of this course, the students;

Know relational data mode and integrity constraints.
Know and apply relational algebra and structured query language (SQL).
Know normal forms and apply to designs.
Describe multidimensional and Bitmap index structures.
Know query evaluation and optimization principles.
Describe transaction management principles.
Object-relational, object, and multidimensional data models.

Mode of Delivery

E-Learning

Prerequisites

Recommended Optional Programme Components

None

Course Description

An Overview of Database Management Systems. Relational DB Model and Integrity Constraints. Relational Algebra. Structured Query Language (SQL). Design Theory for Relational DBs: FDs. Design Theory for Relational Databases:Normalization. Index Structures. Multidimensional and Bitmap Indexes. Query Evaluation and Optimization. Transaction Management; Object-Relational, Object-Oriented, and Multimedia Data Models.

Course Contents

WEEK	TOPICS
1^st Week	An Overview of Database Management Systems
2^nd Week	An Overview of Database Management Systems
3^rd Week	Relational DB Model and Integrity Constraints
4^th Week	Relational DB Model and Integrity Constraints
5^th Week	Relational Algebra
6^th Week	Structured Query Language (SQL)
7^th Week	Design Theory for Relational DBs: FDs
8^th Week	Design Theory for Relational Databases: Normalization
9^th Week	Index Structures
10^th Week	Multidimensional and Bitmap Indexes
11^th Week	Query Evaluation and Optimization
12^th Week	Transaction Management
13^th Week	Object-Relational, Object-Oriented, and Multimedia Data Models
14^th Week	Final Exam

Recommended or Required Reading

1. Molina, H.G., Ullmani J.D., Widom, J., "Database Systems - The Complete Book", Prentice Hall, (2002).

Planned Learning Activities and Teaching Methods

Lecture

Assessment Methods and Criteria

	Quantity	Percentage (%)
Assignment	1	20
Total(%)		20
Contribution of In-term Studies to Overall Grade(%)		20
Contribution of Final Examination to Overall Grade(%)		80
Total(%)		100

ECTS Allocated Based on Student Workload

Activities	Quantity	Duration (Hour)	Total Workload (Hour)
Midterm exam
Preparation for Quiz
Individual or group work	14	3	42
Preparation for Final exam	1	40	40
Course hours	14	3	42
Preparation for Midterm exam
Laboratory (including preparation)
Final exam	1	2	2
Homework
Presentation (including preperation)	1	80	80
Project	1	80	80
Total Work Load			286
Total Work Load / 30 (h)			9.53
ECTS Credit of the Course			10

Language of Instruction

Turkish

Work Placement(s)

Programme Qualifications / Learning Outcomes

	LO1	LO2	LO3	LO4	LO5	LO6	LO7
K1	X	X	X	X	X	X	X
K2		X	X
K3		X				X	X
K4		X			X		X
K5	X	X	X		X
K6					X	X	X
K7					X	X	X
K8	X	X	X	X
K9
K10		X	X
K11					X	X	X
K12	X	X	X	X	X	X	X

	LO1	LO2	LO3	LO4	LO5	LO6	LO7
K1	X	X	X	X	X	X	X
K2		X	X
K3		X				X	X
K4		X			X		X
K5	X	X	X		X
K6					X	X	X
K7					X	X	X
K8	X	X	X	X
K9
K10		X	X
K11					X	X	X
K12	X	X	X	X	X	X	X

	LO1	LO2	LO3	LO4	LO5	LO6	LO7
K1	X	X	X	X	X	X	X
K2		X	X
K3		X				X	X
K4		X			X		X
K5	X	X	X		X
K6					X	X	X
K7					X	X	X
K8	X	X	X	X
K9
K10		X	X
K11					X	X	X
K12	X	X	X	X	X	X	X

	LO1	LO2	LO3	LO4	LO5	LO6	LO7
K1	X	X	X	X	X	X	X
K2		X	X
K3		X				X	X
K4		X			X		X
K5	X	X	X		X
K6					X	X	X
K7					X	X	X
K8	X	X	X	X
K9
K10		X	X
K11					X	X	X
K12	X	X	X	X	X	X	X