Section outline

  • General

    Collapse all Expand all
    • Students must
      Mark as done

      Welcome Letter

        
       


      Dear Students,
      Welcome to the 2020 Fall Semester!
      Welcome back, 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 year. I will see you soon.

      Noor Kibria Sabuz
      Lecturer, Dept. of CSE
      Daffodil International University
      Email: kibria4329@diu.edu.bd
      Phone: +8801961696069

      Course Summary and Objectives



      Instructor Information: Noor Kibria Sabuz  



      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 Outcomes (CO’s):

      • 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
      Lecture Slide-16 URL


    • Students must
      Mark as done

      Quick Navigation Table

      Attendance

      Week-1

      Week-8

      Assignment

      Week-2

      Week-9

      Presentation

      Week-3

      Week-10

      Quiz-1

      Week-4

      Week-11

      Quiz-2

      Week-5

      Week-12

      Quiz-3

      Week-6

      Week-13

      Week-7:Midterm Exam

      Week-14: Final Exam


    • url icon
      Students Interest Feedback URL
    • Students must
      Mark as done
      Set your Appointment Here:
       
                                               
    • Students must
      Mark as done

      Important Dates

      Made with Padlet
    • Students must
      Mark as done
      Introduction Video of DBMS Course

                                                                      

       

    • Students must
      Mark as done

      Student Interest Survey: Click Here

  • Attendance

                                                                                    e

  • Week 1

                                                

  • Week 2

                                               

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

    • resource icon
      Lecture Slide- 4 File
      Students must
      Mark as done
    • Students must
      Mark as done

      Lecture -4 

    • resource icon
      Lecture Slide- 5 File
      Students must
      Mark as done
    • Students must
      Mark as done

      Lecture -5 : Database Architecture

    • resource icon
      Lecture Slide- 6 File
      Students must
      Mark as done
    • resource icon
      Lecture Slide- 7 File
      Students must
      Mark as done
    • url icon
      Class Discussion Lecture-4 URL
      Students must
      Mark as done
    • url icon
      Class Discussion Lecture-5 URL
      Students must
      Mark as done
    • url icon
      Class Discussion Lecture-6 URL
      Students must
      Mark as done
    • url icon
      Class Discussion Lecture-7 (part-1) URL
      Students must
      Mark as done
    • url icon
      Class Discussion Lecture-7 (part-2) URL
      Students must
      Mark as done
    • assign icon
      Assignment-1 ( ER Diagram Drawing)
      Students must
      Mark as done
    • resource icon
      ER Diagram Example File
      Students must
      Mark as done
    • forum icon
      Discussion Forum
      Students must
      Mark as done

  • Week 3

                                                 

  • Quiz-1

                                     

  • Week 4

                           

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

    • url icon
      Lecture Slide-11 URL

      Extra Resource:

                                                                

    • url icon
      Class Lecture-11 URL
      Students must
      Mark as done
    • assign icon
      Week-4-Assignment (Create Database and Relation)
    • forum icon
      Discussion Forum
      Students must
      Mark as done

  • Week 5

                                                                  

    • Lecture Objectives:

      • Inner Join
      • Outer Join
      • Join Operation using SQL

    • Expected outcome

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

    • url icon
      Lecture Slide-12 URL


    • url icon
      Class Lecture-12 URL
      Students must
      Mark as done
    • url icon
      Extra Resource- Join Operation Example URL

                                                                                   

    • forum icon
      Discussion Forum
      Students must
      Mark as done

  • 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  



    • url icon
      Lecture Slide-13 URL


    • url icon
      Class Lecture-13 URL
      Students must
      Mark as done
    • url icon
      SQL queries in Database URL


    • forum icon
      Discussion Forum Week-6

  • Week 7

                                     

    • Lecture Objectives:

      • Delete Operation
      • Update Operation



    • Expected outcome

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

    • url icon
      Lecture Slide-14 URL


    • url icon
      Class Lecture- 14 URL
      Students must
      Mark as done
    • Students must
      Mark as done
      Video Tutorial on Update Operation
    • url icon
      Numeric Functions, Date & Time Functions File URL

      Date Function


    • forum icon
      Week-7 Discussion Forum

  • Quiz-02

                                                 

  • Midterm Week (Week 8)

    •                                              

      Midterm Syllabus

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

      Midterm Assessment Plan
      Total Marks: 25

      Image to PDF Generator Mobile Apps: [Use any one of these apps]
      1. Cam Scanner [Click to download on your Smartphone]
      2. Fast Scanner [Click to download on your Smartphone]
      3. Tap Scanner [Click to download on your Smartphone]

    • Students must
      Mark as done
      Mid Term Exam Guideline for students. Click here to see the guideline. 
    • assign icon
      Mid Term Examination Fall-2020 (O-2) Assignment
      Students must
      View

      You have to answer all the questions. 
      Upload pdf format answer script and the file size must be within 10MB.
      Total Time: 4 hours. 

      File Name Pattern:  e.g. CSE311-O2-111-15-1111-mid.pdf

      N. B. If you are unable to submit the answer script in BLC, you can submit it in the following Google Form.


    • resource icon
      Online Exam Response Submission Template Fall-2020 (Answer Script) File
      Students must
      Mark as done
      Download this file.
    • url icon
      [Google Form] Mid Exam Answer Script Submission for O-2 Section URL
      Students must
      View

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

  • Week 10 (Database Transaction)

                                                                          

    • Lecture Objectives:

      • Transaction Operation in DBMS

    • Expected outcome

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

    • Expected outcome

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

  • 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
      Lecture Slide- 21 URL
    • url icon
      Class Lecture-21 URL
      Students must
      View
    • url icon
      SQL Injection URL
    • forum icon
      Week-11 Discussion Forum

  • Quiz-03

                                                                                       

  • Presentation

                                                                                    

    • Students must
      Mark as done

      To upload your presentation Click Here

  • Week 12 (Final Exam Week)

                                                                    

    Final Examination Syllabus

    • SQL Queries and Sub-Queries
    • Stored Procedure
    • Database Normalization
    • Database Transaction
    • Database Trigger
    • ER Diagram

    Final Examination Assessment Plan
    Total Marks: 40

    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)