| Course Type | Elective Course |
|---|
| Course Level | Master's Degree Without Thesis |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 10 |
|---|
| Name of Lecturer(s) |
|
| Learning Outcomes |
At the end of this course, the students;
- Comprehend the key concepts of relational database management system
- Develop skills for efficient database design
- Understand the role of database management systems in knowledge management
- Understand the multi-user database concerns
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | |
|---|
| Course Description | Database systems are the information heart of modern enterprises. In the first part of the course, a brief introduction to the database will be given and popular relational data model will be introduced. In the second part of the course, relational algebra and SQL will be introduced. Also various database issues, including normal forms, indexing, transactions, from design to implementation will be introduced during the course. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Introduction to Conceptual Modeling, Database System Concepts and Architecture |
|
2nd Week |
Database modeling using the Entity-Relationship (ER) and Extended ER (EER) |
|
3rd Week |
The Relational Data Model and Relational Database Constraints, Relational Database Design by ER-to-Relational Mapping |
|
4th Week |
EER-to-Relational Mapping |
|
5th Week |
The Relational Algebra |
|
6th Week |
SQL |
|
7th Week |
SQL |
|
8th Week |
Midterm |
|
9th Week |
Functional Dependencies and Normalization for Relational Databases |
|
10th Week |
Relational Database Design Algorithms and Further Dependencies |
|
11th Week |
Introduction to Transaction Processing Concepts and Theory |
|
12th Week |
Introduction to Transaction Processing Concepts and Theory |
|
13th Week |
Concurrency Control Techniques |
|
14th Week |
Recovery |
|
| Recommended or Required Reading | Ramez Elmasri & Shamkant B. Navathe. Fundamentals of Database Systems (6. Baskı) |
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Discussion
- Questions/Answers
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
30 |
| Project |
1 |
30 |
| 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 |
3 |
3 |
| Preparation for Quiz |
|
|
|
| Individual or group work |
14 |
5 |
70 |
| Preparation for Final exam |
1 |
60 |
60 |
| Course hours |
14 |
3 |
42 |
| Preparation for Midterm exam |
1 |
50 |
50 |
| Laboratory (including preparation) |
|
|
|
| Final exam |
1 |
3 |
3 |
| Homework |
|
|
|
| Project |
1 |
70 |
70 |
| Total Work Load | 298 |
| Total Work Load / 30 (h) | 9.93 |
| ECTS Credit of the Course | 10 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
