Introduction to Database Systems
CMPE 321Instructor: Prof. Arzucan Özgür, arzucan.ozgur@boun.edu.tr
Semester: Spring 2024
Credits: (3+0+2) 4 ECTS 6
Course Description
Logical organization of data: Entity-relationship modeling of data. Hierarchical, network and relational models. Data description and query languages. Normal forms and database design. Physical design and access strategies. Security, integrity and reliability. Design and implementation of a simple database management system that includes file security and a simple query language.
Course Information
-
Office Hours: After class or by appointment
-
Website: Course content will be available at Moodle.
Textbook (Optional)
- R. Ramakrishnan and J. Gehrke. Database Management Systems, 3rd Edition.
Tentative List of Topics
- Introduction
- ER Model
- Relational Model
- Relational Algebra, Relational Calculus
- Introduction to SQL
- Database Application Programming
- DB Schema Refinement and Normalization
- Storage and Indexing
- Query Evaluation
- Query Optimization
- Transaction Management
- Crash Recovery
Course Requirements
You are encouraged to attend and actively participate in the lectures.
The programming projects will involve intermediate-level programming and knowledge of data structures, where you will implement and test some of the techniques that we cover in class. For each of the projects, you will work with a partner. In that case, you will turn in a single project, and both students will receive the same grade. The projects and the required tools will be explained in detail in the lab/problem sessions. So, you are strongly encouraged to attend the lab/problem sessions (PS).
Grading (Tentative)
The weights might change by around 5%.
- 3-4 Projects: 50%
- Midterm exam: 20%
- Final exam: 30%
Prerequisites
CMPE 250: Data Structures and Algorithms