Section outline

  • Welcome to the DBMS course

    Collapse all Expand all

    CSE311: Database Management System 

  • Course Introduction Video

  • Course Summary and Objectives


    • Welcome to the Database Systems course! In this course, we will be using SQL Server to learn about administering a database, as well as the basics of the SQL language.  In this course, we will learn about database management the system, database languages, data models, database design. This course will focus on how to use the SQL language in order to view and manipulate data. This will include creating and deleting various database objects, adding and altering data within tables, and viewing and sorting data. After completing this course, you will have hands-on experience in administering a database know how to use the SQL language in order to manage it.

    • 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 Objective:


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

    • Students must
      Mark as done

      BLC Course Design Feed-back

      Please give your valuable feedback here. Your Single feedback can make a great change. So do not miss the chance to contribute. I appreciate your active participation

    • Students must
      Mark as done

      BLC Design Feedback Form

  • Communication

    How would you like to communicate with me ..

    me

    Instructor :
    Dr. Moushumi Zaman Bonny
    Assistant Professor
    Department of Computer Science and Engineering
    Faculty of Science and Technology
    Daffodil International University 

    Office : Level 5, CSE Building, Daffodil Tower Extension
    Office Hour   : Sunday (14:00/16:00),Tuesday (14:00/16:00) or by appointment
    Telephone : 8130864  Ext. 226
    Email : bonny.cse@diu.edu.bd

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

    • forum icon
      Forum discussion on File processing system
      Students must
      Mark as done
    • url icon
      A-Recorded Class::18.05.2022 URL
      Students must
      Mark as done


    • url icon
      A-Recorded Class::19.05.2022 URL
      Students must
      Mark as done


    • url icon
      B::Recorded Class:18.05.2022 URL
      Students must
      Mark as done


    • url icon
      B::Recorded Class::::Part-1::::19.05.2022 URL
      Students must
      Mark as done


    • url icon
      B::Recorded Class::::Part-2::::19.05.2022 URL
      Students must
      Mark as done


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

    • forum icon
      Forum Discussion
    • url icon
      B::Recorded Class::::26.05.2022 URL
      Students must
      Mark as done


  • Week 3 (ER to Schema Mapping)


    • Lecture Objectives:

      • ER Diagram
      • ER practice from scenario

    • Expected outcome

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

    • url icon
      10 minutes practice URL
      Students must
      Mark as done
    • url icon
      Use LucidChart to implement your 10 Minutes Work URL
      Students must
      Mark as done
    • url icon
      Class_discusiio_Slide 8 URL
      Students must
      Mark as done

  • Week 4 (SQL Queries)


    • Lecture Objectives:

      • ER to Schema Mapping 
      • Practice example

    • Expected outcome

      • Able to learn very important CRUD operations in Relations.

    • url icon
      Class Discussion Slide-10 URL


    • forum icon
      Forum Discussion on Relational Schema
      Due: Monday, 6 June 2022, 9:05 AM
      Students must
      Mark as done

  • Week 5 (Join Operation)


    • Lecture Objectives:

      • Relational Algebra 

    • Expected outcome

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

    • url icon
      Class Discussion Slide-11 URL

  • Week 6 (Basic SQL Queries)


    • Lecture Objectives:

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



    • Expected outcome

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

    • url icon
      Class Discussion Slide-13 URL


    • forum icon
      Discussion about SQL queries Forum

    • Lecture Objectives:

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



    • Expected outcome

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

    • url icon
      Class Discussion Slide-13 URL


    • forum icon
      Discussion about SQL queries Forum

  • Week 7 (Operation and Functions)


    • Lecture Objectives:

      • SQL Joining  



    • Expected outcome

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

    • url icon
      Class Discussion Slide-13 URL


    • Start Practice (Write Program in Oracle Live SQL)
    • forum icon
      Review Lectures [Forum]
    • Students must
      Mark as done

      Presentation Submission (Click Here)

  • Midterm Week

    Mid Term Examination 

     

    • Students must
      Mark as done

      Midterm Syllabus

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

  • Week 8 (Nested Queries)


    • Lecture Objectives:

      • Nested Queries



    • Expected outcome

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

    • url icon
      Class Discussion Slide-14 URL


  • 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-15 URL



    • url icon
      Class Discussion Slide-18 URL




    • 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-17 URL


    • url icon
      Class Discussion Slide-18 URL


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

    • url icon
      Class Discussion Slide 21 URL

  • Week 12 (Final Exam Week)


  • Topic 18

  • Topic 19

  • Topic 20

  • Topic 21

  • Topic 22

  • Topic 23

  • Topic 24

  • Topic 25

  • Topic 26

  • Topic 27

  • Topic 28

  • Topic 29

  • Topic 30

  • Topic 31

  • Topic 32

  • Topic 33

  • Topic 34

  • Topic 35

  • Topic 36

  • Topic 37

  • Topic 38