Information Package
baskent.edu.tr

Program of Artificial Intelligence Engineering (English)

AI341

DATABASE MANAGEMENT SYSTEMS

Course Code
AI341
Semester
Fifth Term (Fall)
Theory+Practice
3 + 1
ECTS
4
Course TypeCompulsory Course
Course LevelBachelor's Degree
Year of Study3
SemesterFifth Term (Fall)
ECTS4
Name of Lecturer(s) -
Learning Outcomes

At the end of this course, the students;

  1. Describe general concepts and principles of relational database management systems.
  2. Design logical database.
  3. Design physical database.
  4. Interpret and apply Structured Query Language (SQL).
  5. Write and interpret relational algebraic expressions.
  6. Describe and apply normalization rules.
  7. Know transaction management principles.
  8. Know query evaluation principles.
Mode of DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme Components
Course DescriptionIntroduction to DBMSs. Relational Databases. Relational Algebra. SQL. Entity Relationship Model. Theory of Database Design. Physical Database Design. Vector Databases and AI-Specific DBMS: indexing and similarity search for embeddings, applications in NLP. Database Integration in AI Workflows.
Course Contents
WEEK TOPICS
1st Week Database Management System Concepts and principles
2nd Week Entity-relationship (ER) and enhanced ER models
3rd Week Relational data model and integrity constraints
4th Week ER/EER to relational mapping
5th Week Relational algebra and calculus
6th Week Structured query language (SQL)
7th Week Logical database design
8th Week Mid-term
9th Week Functional dependency and normalizations
10th Week Physical database design
11th Week Basic file structures
12th Week Hash and B+ indexing structures
13th Week Query evaluation and optimization
14th Week Transaction processing
Recommended or Required Reading* Fundamentals of Database Systems, Ramez Elmasri and Shamkant B. Navathe, 7th. Edition.
* Vector Database for AI Agents: Powering Autonomous AI Agents with High-Performance Similarity Search and Memory, Ted Winston.
Planned Learning Activities and Teaching Methods
  • Lecture
  • Questions/Answers
  • Problem Solving
  • Experiment
  • Project
  • Report Preparation
  • Presentation
Assessment Methods and Criteria
Quantity Percentage (%)
Mid-term 1 30
Assignment 4 15
Quiz 4 15
Total(%) 60
Contribution of In-term Studies to Overall Grade(%) 60
Contribution of Final Examination to Overall Grade(%) 40
Total(%) 100
Language of InstructionEnglish
Work Placement(s)No

Programme Qualifications / Learning Outcomes

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