| Course Type | Compulsory Course |
|---|
| Course Level | Master's Degree With Thesis |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 10 |
|---|
| Name of Lecturer(s) |
|
| 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 | Face to face |
|---|
| Prerequisites | No |
|---|
| 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 |
|
1st Week |
An Overview of Database Management Systems |
|
2nd Week |
An Overview of Database Management Systems |
|
3rd Week |
Relational DB Model and Integrity Constraints |
|
4th Week |
Relational DB Model and Integrity Constraints |
|
5th Week |
Relational Algebra |
|
6th Week |
Structured Query Language (SQL) |
|
7th Week |
Mid-term |
|
8th Week |
Design Theory for Relational DBs: FDs |
|
9th Week |
Design Theory for Relational Databases: Normalization |
|
10th Week |
Index Structures |
|
11th Week |
Multidimensional and Bitmap Indexes |
|
12th Week |
Query Evaluation and Optimization |
|
13th Week |
Transaction Management |
|
14th Week |
Object-Relational, Object-Oriented, and Multimedia Data Models |
|
| 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
- Questions/Answers
- Presentation
- Practice
- Problem Solving
- Project
- Report Preparation
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
30 |
| Assignment |
1 |
15 |
| Quiz |
1 |
15 |
| Total(%) |
|
60 |
| Contribution of In-term Studies to Overall Grade(%) |
|
60 |
| Contribution of Final Examination to Overall Grade(%) |
|
40 |
| Total(%) |
|
100 |
|
| ECTS Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| Midterm exam |
1 |
1 |
1 |
| Preparation for Quiz |
|
|
|
| Individual or group work |
|
|
|
| Preparation for Final exam |
1 |
40 |
40 |
| Course hours |
14 |
3 |
42 |
| Preparation for Midterm exam |
1 |
30 |
30 |
| Laboratory (including preparation) |
|
|
|
| Final exam |
1 |
2 |
2 |
| Homework |
2 |
30 |
60 |
| Presentation (including preperation) |
2 |
70 |
140 |
| Total Work Load | 315 |
| Total Work Load / 30 (h) | 10.5 |
| ECTS Credit of the Course | 10 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
