Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
1BBM473DATABASE MANAGEMENT SYSTEMS LABORATORY0+2+01406.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 advance the practical knowledge of students on design and maintanence of database management systems (DBMSs).
Course Content Studies of data base design on enhanced database management systems, database definition, query and application development on databases. Researches and presentation of database technologies, disaster recovery, well known database systems
Course Methods and Techniques Lecture, Drill and Practice, Problem Solving
Prerequisites and co-requisities ( BBM102 ) and ( BBM104 ) and ( BBM471 )
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
Practice 8 % 40
Project 1 % 30
Final examination 1 % 30
Total
10
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 2 28
Practice 8 4 32
Project 1 40 40
General Exam Preparation 1 20 20
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 The student will have hands-on experience on designing DBMSs.
2 The student will implement a large scale DBMS.
3 The student will advance in query mechanisms of DBMSs.
4 The student will have knowledge on the assistive tools that are used in DBMS design and web application development.
5 The student will have practice in working in groups.
6 The student will have experience in preparing presentations.
7  
8  

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Introduction to Database Management Systems
2 Design with E/R Model
3 Design with E/R Model
4 Writing SQL queries
5 Writing advanced SQL queries
6 Writing advanced SQL queries
7 Relational Data Model and tables
8 Relational Data Model and tables
9 Tools for DBMS
10 Tools for DBMS
11 Query optimization
12 Transaction Management
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 4 5 3 4 4 4 4 3 3
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=2687398&lang=en