Section outline

  • General

    Collapse all Expand all
    • forum icon
      Welcome to DBMS Class Forum



      Dear Students,
      Welcome to the 2020 Fall Semester!
      Welcome back, Students. I can’t wait to see all your smiling faces again! . 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 year. I will see you soon in your green campus.
      Stay Home Stay Safe.



  • Course Summary and Objectives



    •                                     Teacher Information

      Instructor Name: Rahmatul Kabir Rasel

      Designation: Lecturer

      Dept. of CSE

      Cell-Phone: 01761918875

      Email: raselsarker.cse@diu.edu.bd

      Google Site : https://sites.google.com/diu.edu.bd/rkrsarker

      		                    


    •                                       One-click find me
                                                      
      		                                                           

    •                                                                              Semester Timeline 


    • 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.


    • resource icon
      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

      Oracle Database 10g: The Complete Reference, Author: KavinLoney



      Database System Concept, Silbertz, Korth and Sudarshan


    • Reference Book

      Oracle Database 10g: The Complete Reference, Author: KavinLoney


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


    • Students must
      Mark as done

      Ice breaking Video 

       

       

  • Course Introduction

  • 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.

    • url icon
      Class Discussion Slide-1 URL
      Students must
      Mark as done

       

       

    • url icon
      Class Discussion Slide-2 URL

       

       

    • url icon
      Class Discussion Slide-3 URL
    • quiz icon
      What have I Learned from this week [MCQ] Quiz
      Students must
      Mark as done
    • forum icon
      Forum Discussion about pros and cons of Conventional File Processing System

  • Week 2 (Data Model and Languages)

  • Week 3 (ER to Schema Mapping)

  • Week 4 (SQL Queries)

  • Week 5 (Join Operation)

  • 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.

    • url icon
      SQL queries in Database URL


    • url icon
      Class Discussion Slide-13 URL


    • Start Practice (Write Program in Oracle Live SQL)
    • forum icon
      Discussion about SQL queries Forum
    • quiz icon
      Quiz 02
      Students must
      View


      Quiz Password

    • forum icon
      weekly Discussion Forum
      Students must
      Mark as done

  • Midterm Week (Week 8)


    • Midterm Syllabus

      Midterm Assessment Plan
      Total Marks: 25


    • assign icon
      Midterm Exam Guideline Assignment
      Students must
      Mark as done

      https://drive.google.com/file/d/18VyVTCwBIB4BygrVJ-U94Lr2IvhK3OBv/view

    • assign icon
      Midterm Exam Assignment
      Students must
      Mark as done

      As per the examination routine of the department, the mid-exam or final-exam section will be activated on

      your DIU BLC classroom and the following activity will have to performed by you considering the exam

      condition described in section 2.0:

      (1) Download the paper (pdf) and answer script template (doc) from DIU BLC

      (2) Write responses in the answer script template either type or hand written

      (3) Save the answer script template as pdf e.g. CSE134-O1-111-15-1234-mid.pdf .

      (4) Upload the pdf in DIU BLC and if failed, then send in email or telegram in private within the given time.

      (5)Everyone upload the answer script in below link

      https://forms.gle/SbC1P77HQc2M6bwS9

    • forum icon
      Midterm Exam Review Forum
      Students must
      Mark as done

  • Week 8 (Nested Queries)

  • 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.

    • url icon
      Class Discussion Slide-17 URL


    • url icon
      Class Discussion Slide-18 URL


    • Start Practice (Write Program in Oracle Live SQL)
    • forum icon
      Class Discussion [Forum]

  • 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.

    • url icon
      Class Discussion Slide-19 URL


    • url icon
      Class Discussion Slide-20 URL


    • forum icon
      Class Discussion [Forum]
    • assign icon
      Quiz 03 Assignment
      Students must
      Mark as done


    • assign icon
      Presentation Assignment
      Students must
      Mark as done

      First of all upload your presentation slide and video file in your google drive then crate link then upload the link here. 

  • Week 11 (Trigger and Injection 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.

    • url icon
      Class Discussion Slide URL
    • url icon
      SQL Injection URL
    • assign icon
      Final Assignment
      Students must
      Mark as done
    • Start Practice (Write Program in Oracle Live SQL)
    • forum icon
      Final Exam Reivew [Forum]

  • Week 12 (Final Exam Week)


    • Final Examination Syllabus

      Final Examination Assessment Plan
      Total Marks: 40

    • assign icon
      Final Exam Assignment
      Students must
      Mark as done

      As per the examination routine of the department, the mid-exam or final-exam section will be activated on

      your DIU BLC classroom and the following activity will have to performed by you considering the exam

      condition described in section 2.0:

      (1) Download the paper (pdf) and answer script template (doc) from DIU BLC

      (2) Write responses in the answer script template either type or hand written

      (3) Save the answer script template as pdf e.g. CSE134-O1-111-15-1234-mid.pdf .

      (4) Upload the pdf in DIU BLC and if failed, then send in email or telegram in private within the given time.

      (5)Everyone upload the answer script in below link

      https://forms.gle/mSFUVMG1sbAE3HcQ6


    • My dear Students,

      We are working and learning together. We have shared lot of things in the entire course. Every moment, every day has been filled with boundless joy. As much as I enjoy teaching know that I have enjoyed you more; your laughter, your ideas, your personality, your uniqueness. So, Don't forget to share your experiences with me.

      Your timely response will be highly appreciated!!!


  • Documents and Slides (Resource Pack)