Information Package
baskent.edu.tr

Program of Technology and Knowledge Management

TKM215

DATABASE MANAGEMENT SYSTEMS

Course Code
TKM215
Semester
Third Term (Fall)
Theory+Practice
3 + 0
ECTS
6
Course TypeCompulsory Course
Course LevelBachelor's Degree
Year of Study2
SemesterThird Term (Fall)
ECTS6
Name of Lecturer(s) -
Learning Outcomes

At the end of this course, the students;

  1. Have a broad understanding of database concepts and database management system software
  2. Have a high-level understanding of major DBMS components and their function
  3. Be able to model an application's data requirements using conceptual modeling tools like ER diagrams and design database schemas based on the conceptual model.
  4. Be able to write SQL commands to create tables and indexes, insert/update/delete data, and query data in a relational DBMS.
  5. Will be able to describe and develop Relational Algebra queries
  6. Can identify problems related to database usage in business life and produce solutions.
Mode of DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme Components
Course DescriptionThe aim of this course is to make students gain knowledge and experience about the importance, necessity, design and development of database management systems. In the course, students are given information about database concepts and database management system software, data modeling tools such as ER diagrams are introduced, SQL and relational algebra queries are explained.
Course Contents
WEEK TOPICS
1st Week Introduction to Conceptual Modeling (data, database, database management system, database features, database examples)
2nd Week Database Systems Concepts and Architecture
3rd Week Database modeling using the Entity-Relationship (ER)
4th Week Database modeling using the Extended Entity-Relationship (ER)
5th Week Relational Data Model and Relational Database Constraints
6th Week ER-to-Relational Mapping
7th Week EER-to-Relational Mapping
8th Week Midterm Exam
9th Week Relational Algebra
10th Week Introduction to SQL
11th Week SQL
12th Week Functional Dependencies and Normalization for Relational Databases
13th Week Relational Database Design Algorithms and Further Dependencies
14th Week Transaction Processing Concepts and Theory
Recommended or Required ReadingR. Elmasri, S.B. Navathe, Fundamentals of Database Systems, 4th edition, Addison-Wesley, 2004.
Raghu Ramakrishnan, Database Management Systems, McGraw Hill, 3rd edition, 2003.
Planned Learning Activities and Teaching Methods
  • Presentation
  • Lecture
  • Discussion
  • Problem Solving
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 2.5 2.5
Preparation for Quiz
Individual or group work 14 3 42
Preparation for Final exam 1 25 25
Course hours 14 3 42
Preparation for Midterm exam 1 20 20
Laboratory (including preparation)
Final exam 1 2.5 2.5
Homework
Project 1 15 15
Total Work Load149
Total Work Load / 30 (h)4.96
ECTS Credit of the Course6
Language of InstructionTurkish
Work Placement(s)No

Programme Qualifications / Learning Outcomes

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