Section outline

  • Welcome Database Management System

    Collapse all Expand all

    Welcome to the 2024 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.

    Course Teacher Information
    Course Teacher

    Course Teacher: Israt Jahan

    Designation: Lecturer (Senior Scale) 

    Office address: Room no 705, Level 7, Knowledge Tower (KT), Daffodil Smart City

    Email:isratjahan.cse@diu.edu.bd

    Mobile:01794362263

  • Course Summary and Objectives

    • Course Rationale

      DBMS refers to an introductory course for understanding the fundamental concepts, principles, and techniques of database management systems. DBMS aims at the design, implementation and maintenance of relational databases, as well as various database models, query languages, normalization techniques, and database administration.

    • Course Objective:

      • Gain a foundational understanding of database management systems, including data models, normalization principles, and relational algebra.  
      • Develop proficiency in SQL for data manipulation, querying, and database schema definition. 
      • Learn to design and implement efficient relational databases using normalization techniques and proper schema design principles. 
      • Understand database security concepts and implement measures such as authentication, authorization, encryption, and auditing to protect data integrity and confidentiality. 
      • Explore advanced topics such as distributed databases, NoSQL databases, and data warehousing to understand emerging trends and technologies in the field.

    • Course Outcome

      CO1 : demonstrate a comprehensive understanding of fundamental database management concepts, including the relational data model, normalization techniques, and SQL basics
      CO2: design, implement and optimize relational databases, incorporating advanced SQL queries, indexing techniques and query optimization strategies.
      CO3 understand and analyze security measures, distributed database architectures and emerging trends in database management, demonstrating an understanding of the broader context and challenges in the field.
    • resource icon
      OBE Course New Updated 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.


  • Topic 2


    • Lesson One(1): Introduction to Database 

    • resource icon
      Introduction to Database Management System and its purpose File

      Learning Objectives:

    • Lesson 2 : 

      Learning Objective:

      Relational Model in DBMSFile 

    • resource icon
      Relational Model in DBMS File

      Lecture Objectives:

      • Relational Model?  Relational Model Concept, Relational Integrity Constraints, Operation in Relational Model



    • Students must
      Mark as done

      Content By IJN 
      Content 1-IJN: DBMS Overview (CLICK Here)

      Content 2-IJN: Normalization (CLICK HERE)


      DBMS Normalization Online Site by IJN (JavaTpoint-Click here)

  • Topic 3


  • Topic 4


  • Topic 5


  • Topic 6


    • Lesson: 9
      Learning Objectives: 

      Join and join classification?
      Equi join and self join with example 

      Click here to get resource (Self Join and Equi Join example in table JPG format)

    • assign icon
      Assessment your learning Assignment-3 (Create Database and Relation)

      1. Create a database named 'university' and  Make the following relation using Mysql or Sql Commands under this database.

      2. After making these relations insert at least 5 records into each table.


    • Lesson: 10
      Learning Objectives: 

      • Subqueries- excel table example
      Subqueries lecture content

  • Mid term Week


    daffodil

    Daffodil International University

    Department of Computer Science and Engineering

    MIDTERM EXAM

    		cseicon

    Topics:

    • Introduction to Database
    • Basics of Database Architecture and properties 
    • Relational Model
    • Schema Diagram
    • SQL Operations
    • Join and Subqueries 

  • Week 8

  • Week 9

    • Lesson: 17

      Learning Objectives: 

            ACID Properties
            Transaction details
            Commit
            Rollback
            savepoint

      Lecture Content from StudyTonight site

  • Week 10


    • Lesson: 13
      Learning Objectives: 

              States of Transaction
              Deadlock types 
              Working Mechanism of PC
              Numeric Functions,

      Lecture Content 

      Video Content

    • Click here for Feedback 

    • Lesson: 14
      Learning Objectives: 

              Introduction to nested queries
      Lecture Content 
      Lecture Content 

      Video Content

    • Lecture Video:

    • Click here for Feedback 

  • Week 11

    • Students must
      Mark as done

      Lecture Objectives: Distributed Database, NoSQL, Database Security

      1. Distributed database 

      2. NoSQL 

      3. Database Security

      Content by IJN  (Click Here)

    • Lecture Video:

    • forum icon
      Discussion Forum
      Students must
      Mark as done

  • Week 12

    • Students must
      Mark as done

      Database CRUD Operation

      Lecture  Objective: 

      1. Insert
      2. Delete
      3. update

    • Lecture Video:

  • Week 13

    • resource icon
      Trigger in Database File

      Lecture Objectives

      • What is DB Trigger?  Trigger Syntax, Explanation of Trigger Syntax, Trigger Example
    • Students must
      Mark as done

      Trigger Content by IJN

      Trigger content-1 by IJN (CLICK HERE)

      Trigger Practice content-1 by IJN (CLICK HERE)

      Trigger Practice content-2 by IJN (CLICK HERE)

    • resource icon
      Store Procedure and View in database File

      Lecture Objectives

      • What is DB Procedure?   Procedure Syntax, Explanation of Procedure Syntax, Procedure Example.
      • What is View? View Syntax, Explanation of View Syntax, View Example.
    • Students must
      Mark as done

      Procedure and View Content by IJN

      Procedure content-1 by IJN (CLICK HERE)

      Procedure Practice content-1 by IJN (CLICK HERE)

      View Practice content-1 by IJN (CLICK HERE)

  • Week 14

    • Final exam is coming!!! Are you ready... - Language Center DTC ...

  • Topic 15

  • Topic 16

  • Topic 17

  • Topic 18

  • Topic 19