Section outline

  • General

    Collapse all Expand all

    CSE311: Database Management System  

    • Students must
      Mark as done



      Instructor: 

      Rubaiya Hafiz

      Senior Lecturer
      Department of Computer Science & Engineering
      Daffodil International University
      rubaiya.cse@diu.edu.bd
      01914194973
      Room#416, CSE building, Department of CSE, Daffodil International University       

    • forum icon
      Announcements Forum

  • 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
      Outline File

      DBMS Course Outline

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

                    

    • Students must
      Mark as done

      Reference Books: 

      1. Database System Concept, Silbertz, Korth and Sudarshan
      2. Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.

  • Notice Board

    Noticeboard 

  • Courses Introduction

    Welcome Message 

    Dear Students,

    Welcome to the 2020 Fall Semester!
    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 best use of your time here. Remember to make it a great year, together we will make a remarkable journey.

    Rubaiya.

  • Week 1

    Week 1

    • Students must
      Mark as done

      Introduction To BLC

  • Week 2

    Week 2

    • Students must
      Mark as done

      Lecture 1.1

      Learning Outcome:

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

      Lecture 1.2

      Learning Outcome:

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

      Reference Book Chapter:

      • Fundamentals of Relational Database Management System, S. Sumathi and S. Esakkirajan   Chapter 1
      • Database System Concept, Silbertz, Korth and Sudarshan Chapter 1
    • url icon
      Lecture 1.1: Introduction to Database Management System (Video) URL
      Students must
      Mark as done
    • url icon
      Lecture 1.2: Purpose of DBMS System (Video) URL
      Students must
      Mark as done
    • resource icon
      Lecture 1.1: Introduction to Database Management System (Slide) File
      Students must
      Mark as done
    • resource icon
      Lecture 1.2: Purpose of DBMS System (Slide) File
      Students must
      Mark as done
    • url icon
      Section O-1(EVE) Lecture 1 Meet discussion URL
      Not available unless: You belong to DBMS O-1 (EVE)

    • Lecture 2

      Learning Outcome:

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

      Reference Book Chapter:

      • Fundamentals of Relational Database Management System, S. Sumathi and S. Esakkirajan   Chapter 1
      • Database System Concept, Silbertz, Korth and Sudarshan Chapter 1
    • url icon
      Lecture 2.1: Relational Model in DBMS (Video) URL
      Students must
      Mark as done
    • url icon
      Lecture 2.2: Database Architecture (Video) URL
      Students must
      Mark as done
    • resource icon
      Lecture 2.1: Relational Model in DBMS (Slide) File
      Students must
      Mark as done
    • resource icon
      Lecture 2.2: Database Architecture (Slide) File
      Students must
      Mark as done
    • url icon
      Section O-1(EVE) Lecture 2 Meet discussion URL
      Not available unless: You belong to DBMS O-1 (EVE)
    • url icon
      Section O-2 Lecture 2 Meet discussion URL
      Not available unless: You belong to DBMS Section O-2
    • forum icon
      Forum Discussion about pros and cons of Conventional File Processing System
      Students must
      View
      Make forum posts: 1

      Forum Discussion Question:

      Discuss a real-life scenario where you have to work with a Conventional File Processing System. Now write the advantage and disadvantages on the basis of your experience.

  • Week 3

    Week 3

    • Lecture 3

      Learning Outcome:

      • DBMS,  
      • Database Model Concept, 
      • Data Abstraction, 
      • Schema and instances
      • Relational DBMS Keys
    • url icon
      Lecture 3.1: Data Abstraction (Video) URL
      Students must
      Mark as done
    • url icon
      Lecture 3.2: Relational DBMS -Keys(Video) URL
      Students must
      Mark as done
    • resource icon
      Lecture 3.1: Data Abstraction (Slide) File
      Students must
      View
    • resource icon
      Lecture 3.1: Relational DBMS -Keys(slide) File
    • url icon
      Lecture 3 Google meet discussion Section O2 URL
      Not available unless: You belong to DBMS Section O-2

    • Lecture 4

      Learning Outcome:

      • Introduction to ER model,  
      • What is Entity, Attribute, relationship 
      • Symbols used in ER model
      • Types of Entity, Attribute, relationship Example
    • resource icon
      Lecture 4: ER model (Slide) File
      Students must
      View
    • url icon
      Lecture 4: Meet discussion Introduction To ERD Section O-2 URL
      Not available unless: You belong to DBMS Section O-2

  • Week 4

    Week 4

    • Lecture 5(ERD Continue..)

      Learning Outcome:

      • Introduction to ER model,  
      • What is Entity, Attribute, relationship 
      • Symbols used in ER model
      • Types of Entity, Attribute, relationship Example
    • resource icon
      Lecture 4: ER model (Slide) File
      Students must
      View
    • url icon
      Lecture 5: Meet discussion Introduction To ERD Section O-2 URL
      Not available unless: You belong to DBMS Section O-2
    • url icon
      Lecture 5: Meet discussion Introduction To ERD Section O-1 (Eve) URL
      Not available unless: You belong to DBMS O-1 (EVE)

    • Lecture 6

      Learning Outcome:

      • Scenario to ER model conversion,  
      • Exercise
    • resource icon
      Scenario to ERD Conversion Example (Slide)-1 File
      Students must
      Mark as done
    • url icon
      Lecture 5: Meet discussion Scenario To ERD Section O-1 (Eve) URL
      Not available unless: You belong to DBMS O-1 (EVE)
    • url icon
      Scenario to ERD Conversion Section O-2 (Google meet discussion) URL
      Not available unless: You belong to DBMS Section O-2

  • Week 5

    Week 5

    • Students must
      Mark as done

      QUIZ 1

    • quiz icon
      Quiz 1 Question Section O-2
      Students must
      View

      • Syllabus: Lecture 1 to 4
      • MCQ question
      • Marks: 15
      • Time: 45 minutes

    • Lecture 8

      Learning Outcome:
      • Scenario to ER model conversion Example,  


    • url icon
      Scenario to ERD Conversion Section O-2 (Google meet discussion) Part 2 URL
      Not available unless: You belong to DBMS Section O-2
    • resource icon
      Exercise on Scenario to ERD Conversion (Slide)-2 File
    • url icon
      Use LucidChart to implement your work in 10 Minutes URL
    • forum icon
      Exercise On ERD model Forum
      Students must
      View
      Make forum posts: 1

      Construct an ER Diagram for Company having the following details :

      • Company organized into DEPARTMENT. Each department has unique name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations.
      • A department controls a number of PROJECT. Projects have a unique name, number, and a single location.
      • Company's EMPLOYEE name, ssno, address, salary, and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; The immediate supervisor for the employee.
      • Employee's DEPENDENT are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).

  • ERD symbol Learning

    • hvp icon
      ERD symbol Learning Interactive Content
      Students must
      View

      Learning ERD Symbols

      Its a kind of game. You can drag all text buttons below and put them on the symbol images.  You have to match symbols with an appropriate name. After matching you can submit it.

  • Assignment 1

    ASSIGNMENT 1 

    • assign icon
      Assignment 1
      Students must
      View
      Make a submission

      Consider you are planning to build an Information system as one of your Lab project. On the initial day, you have to describe the system to everyone so that your classmates as well as your course teacher could understand whatever you are going to implement.  

      1. Think about a system you want to develop.
      2. Choose an appropriate name for your system.
      3. Now prepare a document that describes the overall functionality of your system. This description must contain the description of objects with properties that you need to implement
      4. Draw ERD model for your system

  • Week 6

    Week 6

    • Lecture 9

      Learning Outcome:
      • ER model to Relational Schema


    • resource icon
      ERD to Relational Schema Conversion (Slide) File
      Students must
      View
    • resource icon
      ER to Schema Mapping (PDF) File
    • url icon
      Google meet discussion on ERD to schema Section O-2 URL
      Not available unless: You belong to DBMS Section O-2
    • url icon
      Google meet discussion on ERD to schema Section O-1 (EVE)---Part 1 URL
      Not available unless: You belong to DBMS O-1 (EVE)
    • url icon
      Google meet discussion on ERD to schema Section O-1 (EVE)---Part 2 URL
      Not available unless: You belong to DBMS O-1 (EVE)

  • Assignment 2

    ASSIGNMENT 2 

    • assign icon
      Assignment 2
      Students must
      View
      Make a submission

  • Week 7

    Week 7

    • Lecture 11

      Midterm Exam Discussion




    • Students must
      Mark as done

      Quiz 2

      Syllabus: ERD, 

                       Relational Schema, 

                       SQL

      Instructions:

      1. Time: 45 Minutes. After that Your attempt will be submitted automatically.

      2. Go to the next page once you have marked all the questions on the current page. Because once you go to the next page, you do not find options for the previous pages. 

    • quiz icon
      Quiz 2
      Students must
      View
      Receive a grade
    • url icon
      Lecture 10 Meet discussion Section O-5 URL
      Not available unless: You belong to DBMS Section O-2

  • Week 8

    MIDTERM EXAM

    • hvp icon
      Mid Syllabus Interactive Content
      Students must
      View

      Midterm Exam Syllabus

    • resource icon
      Midterm Exam Guideline For students File
      Students must
      View

      Open Book Midterm Exam Guideline

    • resource icon
      Sample exam script File
      Students must
      View

      Midterm Exam Sample Answerscript

    • assign icon
      Midterm Question CSE311(Day-O2) Assignment
      Students must
      View
      Make a submission

      CSE311 Midterm Exam Question paper

      Note: (Only For question Q1(a):  You have to write the answer of question Q1(a) in the doc file or any text editor. No answer will be accepted if you write in hand and then submit it. 

      For other questions, you can write by hand or in the editor. Anyone you chose.


    • Google form for Answer script Submission

  • Week 9

    Week 9

    • Lecture 12

      Learning Outcome:
      • Transaction
      • Commit
      • Rollback
      • Savepoint


    • resource icon
      Transaction Part 1 File
      Students must
      View
    • url icon
      Transaction Part 1 Video (Download Link) URL
      Students must
      View
    • url icon
      Transaction Part 1 SQL Video( Download Link) URL
      Students must
      View

    • Lecture 13

      Learning Outcome:
      • Transaction ACID properties
      • Transaction State Diagram
      • Deadlock


    • resource icon
      Transaction Part 2 File
      Students must
      View
    • url icon
      Transaction Part 2 Meet discussion O-1(EVE) URL
      Not available unless: You belong to DBMS O-1 (EVE)

  • Week 10

    Week 10

  • Week 11

    Week 11


  • Week 13

    FINAL EXAM

    • Topics Covered in Final exam:

      • Scenario to ERD
      • ERD to Relational Schema
      • Normalization
      • Transaction
      • SQL
      • Stored Procedure
      • Trigger



    • resource icon
      Final Exam Answer Script Template Fall 2020 File
      Students must
      Mark as done
    • resource icon
      Final Exam Guideline File
      Students must
      Mark as done
    • url icon
      Google Form Submission URL
      Students must
      Mark as done

      Google Form. You Can Submit Only PDF file.

      While Submitting, Please Check your Section Carefully. 

    • assign icon
      Overlap Exam Assignment
      Not available unless: Your Email address is tanzila15-11789@diu.edu.bd