Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
5BBM371DATA MANAGEMENT3+0+03406.09.2024

 
Course Details
Language of Instruction English
Level of Course Unit Bachelor's Degree
Department / Program COMPUTER ENGINEERING
Type of Program Formal Education
Type of Course Unit Compulsory
Course Delivery Method Face To Face
Objectives of the Course To develop an understanding and practice for fundamental data management systems with a focus on relational data
Course Content Dabase architectures, relational data model, database design, SQL, query processing, complex and big data storage, tree and hash based indexing, spatial and multidimensional index structures.
Course Methods and Techniques Lecture
Prerequisites and co-requisities ( BBM104 ) and ( BBM102 )
Course Coordinator None
Name of Lecturers Asist Prof.Dr. Engin Demir
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources ? Ramakrishnan R. ve Gehrke J., Database Management Systems, 2nd ed., McGraw-Hill Education, 1999. ? Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer D. Widom. Database Systems The Complete Book. Pearson 2008
Course Notes Avi Silberschatz, Henry F. Korth, S. Sudarshan: Database System Concepts, Seventh Edition. McGraw-Hill Book Company 2020, ISBN 9780078022159
Ramakrishnan R. ve Gehrke J., Database Management Systems, 2nd ed., McGraw-Hill Education, 1999.
Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer D. Widom. Database Systems The Complete Book. Pearson 2008


Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Midterm Exam 2 % 50
Final examination 1 % 50
Total
3
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 3 42
Hours for off-the-c.r.stud 14 3 42
Preparation for Midterm Exam 2 10 20
General Exam Preparation 1 16 16
Total Work Load   Number of ECTS Credits 4 120

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Designing relational databases using ER-diagrams
2 Performing all levels of queries using SQL
3 Understanding the concept and types of files, organization and access of files
4 Geting familar with physical storage structures
5 Comparing the performance of index types, tree and hash structured file organization, and external sorting.
6 Understanding the diferent storage and indexing schemes for complex and spatial data
7  
8  

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Introduction to Data Management and Database Architecture
2 Database Design Using The Entity-Relationship Model
3 Relational Data Model
4 SQL
5 Intermediate SQL
6 Advanced SQL
7 Complex Data
8 Big Data
9 Physical Storage Systems
10 Data Storage Structures
11 Tree Based Indexing
12 Hash Based Indexing
13 Spatial Data Management
14 Query Processing (join algorithms, external sorting)
15 Preparation to final exam
16 Final Exam

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12
All 5 4 4 3 2 1 2 3 1 1 2
C1
C2
C3
C4
C5
C6
C7
C8

  Contribution: 1: Very Slight 2:Slight 3:Moderate 4:Significant 5:Very Significant

  
  https://bilsis.hacettepe.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=2687582&lang=en