Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
1BBM471DATABASE MANAGEMENT SYSTEMS3+0+03606.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 Elective
Course Delivery Method Face To Face
Objectives of the Course To teach the fundamental concepts, models, languages and techniques necessary for database design and use.
Course Content Database, database management systems, database architecture, schemas and data independence. Data models: Entity-relationship model and relational model. Integrity restrictions and relational design: Field restrictions, reference restrictions, dependencies between attributes, normal forms, design criteria. Relational languages: Relational algebra and relational calculus. SQL standard relational language: data definition, data manipulation, database management possibilities and main commands. Transactions. Concurrency control and Serializability. Recovery mechanisms.
Course Methods and Techniques Lecture, Drill and Practice, Problem Solving
Prerequisites and co-requisities ( BBM102 ) and ( BBM104 ) and ( BBM473 )
Course Coordinator None
Name of Lecturers Asist Prof.Dr. Engin Demir
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Database Management Systems, Raghu Ramakrishnan ve Johannes Gehrke, 3rd Edition, 2002. Silberschatz, A. et al. Database System Concepts. McGraw Hill, 2001. Yarımağan, Ü. Veri Tabanı Sistemleri. Akademi & Türkiye Bilişim Vakfı Ortak Yayını, 2000.
Course Notes Database Management Systems, Raghu Ramakrishnan ve Johannes Gehrke, 3rd Edition, 2002.
Silberschatz, A. et al. Database System Concepts. McGraw Hill, 2001.
Yarımağan, Ü. Veri Tabanı Sistemleri. Akademi & Türkiye Bilişim Vakfı Ortak Yayını, 2000.


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
Assignment 5 % 10
Final examination 1 % 40
Total
8
% 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 12 3 36
Assignments 5 4 20
Preparation for Midterm Exam 2 24 48
General Exam Preparation 1 34 34
Total Work Load   Number of ECTS Credits 6 180

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 In completition of this course, the student will: have the required knowledge for designing, managing, querying and implementing a database management system.
2 Have the background necessary for the management of large scale data and databases.
3 Be able to control the transaction management and form related recovery mechanisms.
4 Be able to design and model database systems in general, and acquire the common steps in administrating a database management system.
5 Genel olarak veritabanlarının uygun şekilde modellenmesi ve hayata geçirilmesi için gereken adımlarını özümser.
6  
7  
8  

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Introduction to Database Management Systems
2 E/R Model
3 Relational Data Model
4 Relational Algebra
5 SQL
6 Advanced SQL
7 Midterm Exam
8 Designing Relational Databases
9 Normalization
10 Query Optimization
11 Midterm Exam
12 Transactions
13 Concurrency Control
14 Recovery Mechanisms
15 NoSQL Systems
16 Final Exam

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12
All 4 5 3 4 2 4 3 4 3 3 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=2687422&lang=en