Section outline

  • General

    Collapse all Expand all

    CSE311: Database Management System  

    Loving Students,

    Assalamu Alaikum. Welcome to the Database Management System course! I am Warda Ruheen Bristi and I'll be your instructor of this course for the semester of Spring 2021.  Here we will discuss, learn, and explore. Wishing you a great experience!

  • 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 

  • Week 1

    Week 1

    • Students must
      Mark as done

      Introduction To BLC

      Lecture 1.1

      Learning Outcome:

      • Database Introduction,
      • Data and Information,
      • Database Applications
      • Problems in Conventional File Processing System, 

      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
      Lecture Contents:
      Links
      Video Lectures:

    • Live Class sec-J

      Not available unless: You belong to Section-J

    • Live Class sec-I

      Not available unless: You belong to Section-I

    • Live Class [28-01-2021]

      Live Class [29-01-2021]

      Not available unless: You belong to Re-A

  • Week 2

    Week 2

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

    • Students must
      Mark as done

      Video Lectures

    • Live class [section-Re-A][2-2-2021]

      Not available unless: You belong to Re-A

  • Week 3

    Week 3

    • Lecture 3

      Learning Outcome:

      • Introduction to ER model,  
      • What is Entity, Attribute, relationship 
      • Symbols used in ER model
      • Types of Entity, Attribute, relationship Example
      ER Model
    • resource icon
      ER Model 1 File
      Students must
      Mark as done
    • Students must
      Mark as done

      Live Class recording [27-01-2021]

    • Students must
      Mark as done

      Live class[31-01-2021]

    • **Live class[8-2-2021]

      Not available unless: You belong to Re-A

    • **Live class[9-2-2021]

      Not available unless: You belong to Re-A
    • Students must
      Mark as done

      **Live class[10-2-2021]

  • 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

    • 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

  • Week 5

    Week 5

    • Lecture 8

      Learning Outcome:
      • Scenario to ER model conversion Example,  


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

  • quiz

    QUIZ 

    • quiz icon
      Quiz-1
      Students must
      View

      Syllabus: Introduction to ER diagram

    • quiz icon
      Quiz-2
      Students must
      Mark as done

      Syllabus: Schema, Relational Algebra, SQL

    • quiz icon
      Quiz-3
      Students must
      Mark as done

      Syllabus: Relational algebra, Normalization, Transaction, ACID Properties

    • Students must
      Mark as done

      Presentation

      Click here to upload.

  • Week 6

    Week 6

  • Week 7

    Week 7

  • Week 8

    MIDTERM EXAM

    • assign icon
      Mid Examination Spring 2021 [CSE311-Sec-I, J] Assignment

      Exam duration: 2:30 hrs [1:30PM - 4:00PM]

      Full Marks: 25


      Google form Link to submit the script. Click here


    • assign icon
      Mid Examination Spring 2021 [CSE311-Re-A] Assignment

      Exam duration: 2:30 hrs [1:30PM - 4:00PM]

      Full Marks: 25


      Google form Link to submit the script. Click here


      Not available unless: You belong to Re-A

  • Week 9

    Week 9

    • Lecture 12

      Learning Outcome:


    • resource icon
      Transaction File
      Students must
      Mark as done
    • Students must
      Mark as done

      ACID Properties

    • Students must
      Mark as done

      **Class Recording[1-4-2021]

  • Week 10

    Week 10

    • Lecture 14

      Learning Outcome:
      • Database Normalization


    • resource icon
      Normalization part 1 File
      Students must
      View
    • Students must
      Mark as done

      Normalization part 2

    • Students must
      Mark as done

      Normalization part 3

    • Students must
      Mark as done

      Normalization

    • Students must
      Mark as done

      **Live class recording [24-03-2021]

    • Students must
      Mark as done

      ** 1NF

    • Students must
      Mark as done

      **2NF

    • Students must
      Mark as done

      **3NF

  • Week 13

    FINAL EXAM

    • Topics Covered:

      • Scenario to ERD
      • Normalization
      • Transaction
      • SQL
      • Relational Algebra



    • resource icon
      Final Assessment Question 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.