Section outline

  • General

    Collapse all Expand all
    • forum icon
      Announcements Forum
    • 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.

      Audio Welcome Letter: 






      Instructor

      Lecturer
      Department of CSE
      Daffodil International University
      Email: shahana.cse@diu.edu.bd
      Phone: +8801672860365
      Office: Room #505 AB-04, Daffodil International University, Savar, Dhaka  

      Prefect 

      Md Fazley Rabbe
      Email: fazley15-1519@diu.edu.bd
      Mobile: +8801701046745 (Telegram) 

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


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


    • url icon
      Lab Docs URL
      Students must
      Mark as done
    • resource icon
      DBMS Project List File
      Students must
      Mark as done
    • assign icon
      DBMS LAB FINAL (PC-B) Assignment

      Please submit your video through this google form: https://docs.google.com/forms/d/1X3JJQFMl-R7T6BJCKtA9o7eNDxmTG19PHdoF9OvbXLQ/viewform?fbclid=IwAR07FF5Bh_U68cDbR1hADlasKwWBK-6po1SxA3pvCo3bEERD2o2jBfgjN7c&edit_requested=true 

      Not available unless: You belong to PC-B
    • assign icon
      DBMS LAB FINAL (PC-A) Assignment

      Please submit your video through this google form: https://docs.google.com/forms/d/1X3JJQFMl-R7T6BJCKtA9o7eNDxmTG19PHdoF9OvbXLQ/viewform?fbclid=IwAR07FF5Bh_U68cDbR1hADlasKwWBK-6po1SxA3pvCo3bEERD2o2jBfgjN7c&edit_requested=true 

      Not available unless: You belong to PC-A

  • Week 1

    • resource icon
      Introduction to Database Management System File

      Lecture Objectives:

      • Database Introduction, Database History, Flat File Database, Data and Information, Database Applications

    • resource icon
      Purpose of Database System File

      Lecture Objectives:

      • Problems in Conventional File Processing System, Difficulty in accessing data, Integrity problems, Atomicity problems, Security problems

    • resource icon
      Relational Model in DBMS File

      Lecture Objectives:

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

    • quiz icon
      What have I Learned Quiz
      Students must
      Mark as done
    • forum icon
      Forum Discussion about pros and cons of Conventional File Processing System
    • choice icon
      Feedback (03-10-2020) (PC-A) Choice

      Today's class was:

      Not available unless: You belong to PC-A
    • choice icon
      Feedback (03-10-2020) (PC-B) Choice

      Today's class was:

      Not available unless: You belong to PC-B
    • url icon
      Class (03/10/2020) (PC-A) URL
      Students must
      Mark as done


    • url icon
      Class (03/10/2020) (PC-B) URL
      Students must
      Mark as done


    • url icon
      LAB-1 (06/10/2020) URL
      Students must
      Mark as done


    • choice icon
      Feedback (Lab-1 (06-10-2020)) Choice
      Students must
      Mark as done

      Today's class was:

    • forum icon
      Discussion about Lab-1 Forum
      Students must
      Mark as done
    • assign icon
      Lab Performance-1 (PC-A) Assignment
      Not available unless: You belong to PC-A
    • assign icon
      Lab Performance-1 (PC-B) Assignment
      Not available unless: You belong to PC-B
    • url icon
      Lab Class-1 (06-10-2020) URL
      Students must
      Mark as done

      PC-A

      PC-B


  • Week 2

  • Quiz-1

    • quiz icon
      Quiz-1 (PC-A)
      Not available unless: You belong to PC-A
    • quiz icon
      Quiz-1 (PC-B)
      Not available unless: You belong to PC-B

  • Week 3

  • Week 4

    • resource icon
      Basic SQL Queries (P-1) File

      Lecture Objectives:

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

    • choice icon
      Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1) Choice
      Students must
      Mark as done

      Today's Class was:

    • forum icon
      Discussion Forum
      Students must
      Mark as done
    • url icon
      Class (27-10-2020) (SQL-1) URL
      Students must
      Mark as done


  • Week 5

  • Week 6

  • Week 7

  • Week 8

  • Midterm Week (Week 9)

  • Week 10

  • Week 11

    • resource icon
      Database Normalization File

      Lecture Objectives:

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

    • choice icon
      Feedback (normalization) (pc-a & pc-b) Choice
      Students must
      Mark as done

      today's class was:

    • forum icon
      Discussion Forum
      Students must
      Mark as done
    • assign icon
      Project Proposal PC-A Assignment
      Not available unless: You belong to PC-A
    • assign icon
      Project Proposal PC-B Assignment
      Not available unless: You belong to PC-B
    • url icon
      class (23-11-2020) pc-a URL
      Students must
      Mark as done


    • url icon
      class (normalization) pc-b URL
      Students must
      Mark as done


    • choice icon
      Feedback (LAB-23-11-2020) (pc-a & pc-b) Choice
      Students must
      Mark as done

      today's lab class was:

    • url icon
      LAB 23-11-2020 (PC-B) URL
      Students must
      Mark as done


    • url icon
      Lab-24/11/2020 (pc-a) URL
      Students must
      Mark as done


  • Week 12

  • Week 13

  • Week 14


    • Final Examination Syllabus

      Final Examination Assessment Plan
      Total Marks: 40

    • resource icon
      Previous Semester's Final Examination Question File

      Previous Semester's Final Examination Question for Better Understanding.

    • assign icon
      Final Exam PC-A Assignment

      FALL-2020

      Please rename your answer script (pdf) using your student ID and then submit.


      Not available unless: You belong to PC-A
    • assign icon
      Final Exam PC-B Assignment

      FALL-2020

      Please rename your answer script (pdf) using your student ID and then submit.


      Not available unless: You belong to PC-B

  • Assignment

    • assign icon
      Assignment-1 (ER to Schema Mapping) (PC-A)
      Not available unless: You belong to PC-A
    • assign icon
      Assignment-2 (RA) (PC-A)
      Not available unless: You belong to PC-A
    • assign icon
      Assignment-1 (ER to Schema Mapping) (PC-B)
      Not available unless: You belong to PC-B
    • assign icon
      Assignment-2 (RA) (PC-B)
      Not available unless: You belong to PC-B

  • Presentation

    • assign icon
      Presentation (PC-A) Assignment
      Not available unless: You belong to PC-A
    • assign icon
      Presentation (PC-B) Assignment
      Not available unless: You belong to PC-B

  • MID TERM EXAM Fall-2020

    • assign icon
      CSE311 (PC-A) Assignment
      Not available unless: You belong to PC-A
    • assign icon
      CSE311 (PC-B) Assignment
      Not available unless: You belong to PC-B

  • Quiz-3

    • quiz icon
      Quiz-3 (PC-A)
      Not available unless: You belong to PC-A
    • quiz icon
      Quiz-3 (PC-B)
      Not available unless: You belong to PC-B