Topic outline

• General
  

  General

  • . Forum

    
    
  • Welcome to DBMS Class Forum

    Dear Students,
    Assalamuwalaikum!
    
    Welcome to the 2020 Fall Semester, Students. I can’t wait to see all your smiling faces!  I am here to support you every step of the way.
    I encourage you to make the most of your time here.
    

    Remember to make it a great semester. Let's starts our journey with a nice Quote of DBMS is Life...

    
    

    
    

    
    

    
    

    I will see you soon.
    

    Allah Hafez.

    
    

    Tapasy Rabeya
    

    DIU Profile
    

    Lecturer, Dept. of CSE

    Daffodil International University

    Email: tapasyrabeya.cse@diu.edu.bd

    Phone: +8801827755178
• Course Introduction
  

  Course Introduction

• Course Summary and Objectives
  

  Course Summary and Objectives

  
  

  • Course Rationale

    Database Management Systems (DBMS) are vital components of modern information systems.  Database applications are pervasive and range in size from small in-memory databases to terra bytes or even larger in various applications domains.  The course focuses on the fundamentals of knowledge-base and relational database management systems, and the current developments in database theory and their practice.

  • Course Objective:

    Upon successful completion of this course, students should be able to:

    • Describe the fundamental elements of relational database management systems.
    • Explain  the  basic  concepts  of  relational  data  model,  entity-relationship  model,  relational  database design, relational algebra and SQL.
    • Design ER-models to represent simple database application scenarios
    • Convert  the  ER-model  to  relational  tables,  populate  relational  database  and  formulate  SQL  queries on data.
    •  Improve the database design by normalization.
    •  Familiar   with   basic   database   storage   structures   and   access   techniques.

    
    

  • Course Outcome
    

    CO1

    To be able to apply analytical skills to map out the conceptual design for a real-life problems and write database documentation, including data standards, procedures and definitions for the data dictionary.
    
    CO2
    To be able to draw the model of Relational Database using Entity Relationship (ER) model and explain the fundamental elements of Database management System.
    

    
    

    CO3

    To be able to evaluate the logical design to translate into a specific data model and physical design to meet system storage requirements.
    
    CO4
    To be able to evaluate MSSQL/MySQL/Oracle features and MSSQL /MySQL/Oracle related products for maintaining the integrity and performance of enterprise databases.
    
    
    
  • OBE Course outline File
  • Course Assessment:
    

    Final grade in each course will be given on the basis of performance in class attendance, in-
    course examinations, assignments, midterm test and final examination is shown in Table.

    
    

  • Text Book

    

    
    

    
    

    Database System Concept, Silbertz, Korth and Sudarshan

    
    

  • Reference Book

    

    
    

    Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.

    
    

  • Student Counseling Hours
• Week 1 (Introduction to DBMS)
  

  Week 1 (Introduction to DBMS)

  
  

  • Lecture Objectives:

    • Database Introduction, Database History, Flat File Database,
      
    • Data and Information, Database Applications
    • Problems in Conventional File Processing System, Difficulty in accessing data.
    • Integrity problems, Atomicity problems, Security problem.
    • Relational Model?  Relational Model Concept.
    • Relational Integrity Constraints, Operation in Relational Model

    
    
  • Expected outcome
    

    • Able to identify the problems of conventional file processing system with related terminology of ACID properties.

    
    

  • Class Discussion Slide-1 URL

  • Class Discussion Slide-2 URL

  • Class Discussion Slide-3 URL

  • What have I Learned from this week [MCQ] Quiz
  • Forum discussion 1_ SEC L

    Restricted Not available unless: You belong to Section - L
  • Forum_Disscussion_1_SEC-K

    Restricted Not available unless: You belong to Section - K
  • Forum_Discussion_1_SEC-EVE-(A)

    Restricted Not available unless: You belong to Section - A(EVE)
• Week 2 (Data Model and Languages)
  

  Week 2 (Data Model and Languages)

  
  

  • Lecture Objectives:

    • Level of Abstraction, Data Models, Database Languages
      
    • Two Tier Architecture, Three Tier Architecture
    • Discuss all types of keys in relational DB Model.

    
    
  • Expected outcome
    

    • Able to know the level of abstraction, database languages and make relational model with keys.

    
    

  • Class Discussion Slide-4 URL

  • Class Discussion Slide-5 URL

  • Class Discussion Slide-6 URL

  • Self Assessment URL
  • Class Discussion Slide-7 URL

  • Forum Discussion
  • 10 Minutes Practice [Click Here] URL
  • Use LucidChart to implement your 10 Minutes Work URL
  • Quiz_1_Eve(A)

    Restricted Not available unless: You belong to Section - A(EVE)
  • Quiz_1_Sec-K

    Restricted Not available unless: You belong to Section - K
  • Quiz_1_SEC-L

    Restricted Not available unless: You belong to Section - L
• Week 3 (ER to Schema Mapping)
  

  Week 3 (ER to Schema Mapping)

  
  

  • Lecture Objectives:

    • ER Diagram
      
    • ER to Schema Mapping

    
    
  • Expected outcome
    

    • Able to learn mapping with different relations in Database and mathematical structure (Relational Algebra) of relations.

    
    

  • Class Discussion Slide-8 URL
  • Class Discussion Slide-9 URL
  • ER to Schema Mapping (Video Lesson) URL

  • Five Minutes Practice File
  • Forum Discussion
  • Quiz_2_SEC-K

    Restricted Not available unless: You belong to Section - K
  • Quiz_2_SEC-EVE-A

    Restricted Not available unless: You belong to Section - A(EVE)
• Week 4 (SQL Queries)
  

  Week 4 (SQL Queries)

  
  

  • Lecture Objectives:

    • ER Diagram
      
    • ER to Schema Mapping 
    • CRUD (Create, Read, Update, Delete) operation 
    • Where and Order By Clause 
    • Group By Clause

    
    
  • Expected outcome
    

    • Able to learn very important CRUD operations in Relations.

    
    

  • Class Discussion Slide-10 URL

  • Self Assessment URL
  • Forum Discussion
• Week 5 (Join Operation)
  

  Week 5 (Join Operation)

  
  

  • Lecture Objectives:

    • Inner Join
    • Outer Join
    • Join Operation using SQL

    
    
  • Expected outcome
    

    • Able to learn the  basic Join operation with SQL query.
      

    
    

  • Class Discussion Slide-12 URL

    
    

  • Database Join Operation with Example URL

  • SQL Join 10 Minutes Practice Quiz
  • Discussion regarding SQL Join Operation Forum
• Week 6 (Basic SQL Queries)
  

  Week 6 (Basic SQL Queries)

  
  

  • Lecture Objectives:

    • Between and In Queries, Exist and not exists Queries
    • Like Operator, Group by with having clause
      
    • Rename Operation, Order By, Set Operations
    • Nested Query Using Set Operation  

    
    

    
    
  • Expected outcome
    

    • Able to learn the  basic SQL query with Set operations and different operation in SQL.
      

    
    

  • SQL queries in Database URL

    
    

  • Class Discussion Slide-13 URL

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • Discussion about SQL queries Forum
• Week 7 (Operation and Functions)
  

  Week 7 (Operation and Functions)

  
  

  • Lecture Objectives:

    • Delete Operation
    • Update Operation

    
    

    
    
  • Expected outcome
    

    • Able to learn the  basic SQL query and different functions in SQL.
      

    
    

  • Class Discussion Slide-14 URL

    
    

  • Numeric Functions, Date & Time Functions File URL

    Date Function

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • Review Lectures [Forum]
• Midterm Week (Week 8)
  

  Midterm Week (Week 8)

  
  

  
  

  • 
    

    Midterm Syllabus
    

    • Relational Model, DBMS Languages
      
    • Entity Relationship (ER) diagram.
    • ER to Schema Mapping.
    • Basic SQL Queries with different functions.
      

    Midterm Assessment Plan
    Total Marks: 25

    Assalamuwalaikum students,
    

    Please find the following documents.
    

    1. Exam instruction file for students
    2. Exam Question (day)
    3. Exam Question (Eve)
    4. Answer script submission template. ( You have to submit in pdf format)

    
    After preparing the answer script to submit your file in the following google form, and also in the classroom and BLC.

    Google form ( Click here to submit )
    Classroom

    Do not copy from others or help others. Upon finding similar copies it may cause the deduction of 5 to 10 marks.
    

    The time limit for the exam is 1:30 pm to 4:00 pm. The time will be strictly maintained.
    

    Penalties for late exam response are as follows:
    

    Time Penalty First
    29mins No penalty
    30mins-40mins 5 or 5% of the marks available
    40mins to 1hr 10 or 10% of the marks available
    

    Thank you.
    All the best.
    Allah hafez
    

    
    

    
    

  • MID_Answer_script_Submission_Spring_2021_ SEC-L Assignment

    Restricted Not available unless: You belong to Section - L
  • MID_Answer_script_Submission_Spring_2021_ SEC-K Assignment

    Restricted Not available unless: You belong to Section - K
  • MID_Answer_script_Submission_Spring_2021_ SEC-EVE-A Assignment

    Restricted Not available unless: You belong to Section - A(EVE)
• Week 8 (Nested Queries)
  

  Week 8 (Nested Queries)

  
  

  • Lecture Objectives:

    • Nested Queries

    
    

    
    
  • Expected outcome
    

    • Able to learn the nested SQL query among more than one relation.
      

    
    

  • Class Discussion Slide-15 URL

    
    

  • Class Discussion Slide-16 URL

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

• Week 9 (Stored Procedure and Normalization)
  

  Week 9 (Stored Procedure and Normalization)

  
  

  • Lecture Objectives:

    • Stored Procedure
    • First Normal Form
    • Second Normal Form
    • Third Normal Form

    
    

    
    
  • Expected outcome
    

    • Able to learn to minimize redundancy (duplicate data) and to ensure only related data is stored in each table.
      

    
    

  • Class Discussion Slide-17 URL

    class recording Sec-K (click here) 
    class recording Sec-L (click here)
    class recording Sec-EVE(A) (click here)

    
    

  • Class Discussion Slide-18 URL

    class recording Sec-K (click here)
    class recording Sec-L (click here)
    class recording Sec-EVE(A) (click here)
    

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • Class Discussion [Forum]
• Week 10 (Database Transaction)
  

  Week 10 (Database Transaction)

  
  

  • Lecture Objectives:

    • Transaction Operation in DBMS

    
    

    
    
  • Expected outcome
    

    • Able to identify Concurrent execution of the same transaction, deadlock, or slow performance.
      

    
    

  • Class Discussion Slide-19 URL

    class recording Sec-K (click here)
    class recording Sec-L (click here)
    class recording Sec-EVE(A) (click here)
    

  • Class Discussion Slide-20 URL

    
    

  • Forum Discussion : DBMS Transaction Sec-K

    Restricted Not available unless: You belong to Section - K
  • Forum Discussion : DBMS Transaction

    Restricted Not available unless: You belong to Section - L
  • 3rd quiz Submission Sec-K Assignment

    Restricted Not available unless: You belong to Section - K
  • Quiz 3 Sec-L

    Restricted Not available unless: You belong to Section - L
• Week 11 (Trigger in DBMS)
  

  Week 11 (Trigger in DBMS)

  
  

  • Lecture Objectives:

    • What is DB Trigger? 
    •  Trigger Syntax
    • Explanation of Trigger Syntax
    • Trigger Example

    
    

    
    
  • Expected outcome
    

    • Able to identify when discrete events occur, and it allows for the user to drill down into the metrics of that event.
      

    
    

  • Class Discussion Slide URL

    Class recording Sec-K ( Click Here )
    Class recording Sec-L ( Click Here )
    Class recording Sec-EVE(A) ( Click Here )
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • Quiz 2 Sec-L

    Restricted Not available unless: You belong to Section - L
• Week 12 (Final Exam Week)
  

  Week 12 (Final Exam Week)

  • Final Assessment Syllabus
    

    • ER model And Relational Schema design 
    • SQL Queries and Sub-Queries
      
    • Stored Procedure
      
    • Database Normalization
      
    • Database Trigger

    Assessment Plan
    Total Marks: 40

    Dear students, 
    Please find the final assessment question below. You have to submit a pdf answer script in blc and in a google form. You will get total 8 hour from 9 AM to 5 PM today. 
    All the best. 
    Thank you.
    

    Question SEC- K (click here)
    Question SEC- L  (click here)
    Question SEC- EVE(A) (click here) 

    Google form Submission Link ( Click Here ) 

  • Final Assessment Submission Assignment

    Restricted Not available unless: You belong to Section - A(EVE)
  • Final Assessment Submission SEC-K Assignment

    Restricted Not available unless: You belong to Section - K
  • Final Assessment Submission SEC-L Assignment

    Restricted Not available unless: You belong to Section - L
• Documents and Slides (Resource Pack)
  

  Documents and Slides (Resource Pack)

  Not available
• Topic 17
  

  Topic 17
• Topic 18
  

  Topic 18
• Topic 19
  

  Topic 19
• Topic 20
  

  Topic 20
• Topic 21
  

  Topic 21
• Topic 22
  

  Topic 22
• Topic 23
  

  Topic 23
• Topic 24
  

  Topic 24
• Topic 25
  

  Topic 25
• Topic 26
  

  Topic 26
• Topic 27
  

  Topic 27
• Topic 28
  

  Topic 28
• Topic 29
  

  Topic 29
• Topic 30
  

  Topic 30
• Topic 31
  

  Topic 31
• Topic 32
  

  Topic 32
• Topic 33
  

  Topic 33
• Topic 34
  

  Topic 34
• Topic 35
  

  Topic 35
• Topic 36
  

  Topic 36
• Topic 37
  

  Topic 37
• Topic 38
  

  Topic 38
• Topic 39
  

  Topic 39
• Topic 40
  

  Topic 40
• Topic 41
  

  Topic 41
• Topic 42
  

  Topic 42
• Topic 43
  

  Topic 43
• Topic 44
  

  Topic 44
• Topic 45
  

  Topic 45
• Topic 46
  

  Topic 46
• Topic 47
  

  Topic 47
• Topic 48
  

  Topic 48
• Topic 49
  

  Topic 49
• Topic 50
  

  Topic 50