Topic outline

• General
  

  General

  CSE311: Database Management System  

  
  

  • 
    

    Dear Students, 

    Welcome to the Spring 2021 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.

    
    

    Mark as done
  • Announcements Forum

    
    
    

• Course Summary and Objectives
  

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

    Assessment Scheme

    Theory Class Attendance Class Tests/Quizes  Assignment:  Presentation (using video/ppt)  Midterm Exam Final Exam 7% 15%  5% 8% 25% 40% [All assessment will be based on onsite/online situation]

    
              

  • Reference Books: 

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

    Mark as done
• Notice Board
  

  Notice Board

  Noticeboard 

  
  

  • Announcement Forum

    Notice and Announcements

    You have  Final Assessment
    

    
    

  • Google Meet Link

    
    

  • External Resources/ Web Links

    • UML Class Diagram
      
    • Online UML Diagram Design

  • Google Classroom Code:  ptvk57j

  • 
    

    Navigation

    Class Test: Demo, CT1, CT2, CT3      Assignment: ASN1, ASN2, ASN3       Presentation        Mid Exam       Final Exam            Interactive Video on SQL
    Week2Go:   WK1    WK2    WK3    WK4    WK5    WK6   WK7    WK8    WK9    WK10    WK11    WK12    WK13    WK14

    
    
  • Overall Student Feedback URL

    Mark as done

    
• Courses Introduction
  

  Courses Introduction

  Welcome Message 

  Dear Students,
  
  Welcome to the Spring 2021 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.
  

  Rubel Sheikh.

  • Welcome Video URL

• Week 1
  

  Week 1

  Week 1
  

  • • Introduction To BLC
    • Introduction to Database Management System

       BLC Introduction(Video)

    
    

    Mark as done
• Week 2
  

  Week 2

  Week 2
  

  • 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

    Mark as done
  • 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
  • Content Sources

    Mark as done
  • Lecture 1.1: Introduction to Database Management System (Slide) File

    Mark as done
  • Lecture 1.1 Introduction to Database (Lecture Video) Page

    Mark as done

  • Lecture 1.2: Purpose of DBMS System (Slide) File

    Mark as done
  • 1.2 Purpose of DBMS(Lecture Video) Page

    Mark as done

  • Lecture 2.2: Database Architecture (Slide) File

    Mark as done
  • Lecture 2.1: Relational Model in DBMS (Slide) File

    Mark as done

    Relational Model in DBMS (Slide)
    Relational Algebra(Slide)
    Relational Model(Video)
       Database Architecture(Video)
    

  • Forum Discussion about pros and cons of Conventional File Processing System

    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

  Week 3
  

  • Lecture 3

    Learning Outcome:

    • DBMS,  
    • Database Model Concept, 
    • Data Abstraction, 
    • Schema and instances
    • Relational DBMS Keys
  • Lecture 3.1: Data Abstraction (Slide) File

    View

      Lecture 3.1: Data Abstraction (Video)
    

  • Lecture 3.2: Relational DBMS -Keys(slide) File

      Lecture 3.2: Relational DBMS -Keys(Video)
    

  • External Links:

                                       DBMS-Keys: https://www.studytonight.com/dbms/database-key.php#

    Mark as done
  • Lecture 3.3

    Learning Outcome:

    • Introduction to ER model,  
    • What is Entity, Attribute, relationship 
    • Symbols used in ER model
    • Types of Entity, Attribute, relationship Example
  • Lecture 3.3: ER model (Slide) File

    View

           Lecture 3.3 ER Model (Video)

  • Assignment-1

    Mark as done

    Instructions for Assignment Submission:

    • Read the questions carefully 
    • Prepare your answer.
    • write down the answer here in the online text submission box.
    • ALERT    Be careful about Plagiarism

  • Interactive Video on MySQL Types

    
    

    Mark as done
• Week 4
  

  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
  • Lecture 4: ER model (Slide) File

    View
  • Lecture 6

    Learning Outcome:

    • Scenario to ER model conversion,  
    • Exercise
  • Scenario to ERD Conversion Example (Slide)-1 File

    Mark as done

       Scenario to ERD Conversion Example Lecture (Video)

  • External Links for ER-Diagram

    • https://beginnersbook.com/2015/04/e-r-model-in-dbms/ 
    • https://bitalksbi.com/erd-case-study           

    Mark as done
  • Class Test-1 PC-I Quiz

    Exam Date and Time:      24.02.2021     7:00pm to 7:35pm

    	Quiz-1 Topics: DBMS Introduction Purpose of DBMS Database Architecture Relational Model Data Abstraction DBMS Keys

    Be careful about internet connection. You are permitted for a single attempt.

• Week 5
  

  Week 5

  Week 5
  

  • Lecture 5.1

    Learning Outcome:
    

    • Scenario to ER model conversion Example,  

    
    

    
    
  • Exercise on Scenario to ERD Conversion (Slide)-2 File
  • Use LucidChart to implement your work in 10 Minutes URL
  • Use ERDplus to implement your work in 10 Minutes URL
  • Exercise On ERD model Forum

    View Make forum posts: 1

    Construct an ER Diagram for the following details :

    
    

• ERD symbol Learning
  

  ERD symbol Learning

  Not available
• Week 6
  

  Week 6

  Week 6
  

  • Lecture 9

    Learning Outcome:
    

    • Relational Algebra 
      
    • Different types of relational algebra
    • Join in DBMS 
    • Different types of join in DBMS

    
    

  • Relational Algebra(Slide) File

    View

    Relational Algebra (Video)

  • Lecture 10

    Learning Outcome:
    

    • Introduction to Join Operation
    • Join operations in DBMS

    
    

    
    
  • Join in DBMS (Slide) File

    Join in DBMS (Video)

• Week 7
  

  Week 7

  Week 7

  • Lecture 11

    Midterm Exam Discussion

    
    
    

    
    
  • Quiz-2 Assignment

    Mark as done

    Quiz 2

    Syllabus: 

                    ERD, 
                    Relational Algebra, 

    Instructions:

    ·         Read the question paper carefully.

    ·         Write all answer either in paper or in text format.

    ·         Make a single pdf file of your answer script.

    ·         Submit the answer pdf file within given time.

     

         Constraints:

    ·         You will get only 45 minutes for answering the questions. No additional time will be given.

    ·         You have to submit within time limit.

    ·         Plagiarism will be checked strictly, so be careful about copying any answer from others.

    ·         If any plagiarism is found then all suspected will be penalized.

    
    

    Time: 45 Minutes.    10:30 am to 11:15 am

    
    

• Week 8
  This topic
  

  Week 8

  MIDTERM EXAM

  • Mid Syllabus Interactive Content

    Complete the activity

    Midterm Exam Syllabus

    • Introduction to DBMS
    • DBMS Architecture
      
    • Database Models
    • Relational Model
    • Relational Schema
    • ER Diagram
    • Scenario to ER Diagram
    • SQL
    • Relational Algebra
    • Join in DBMS

  • Midterm Exam Guideline For students File

    View

    Open Book Midterm Exam Guideline

    
    

  • Sample exam script File

    View

    Midterm Exam Sample Answerscript

  • Google form for Answer script Submission
    

    Click Here

    https://forms.gle/T69BjhhrKUhNUcuA7
    

  • Midterm Question CSE311 Assignment

    View Make a submission

    CSE311 Midterm Exam Question paper

    Note: You can write your answer either in Word format or in handwritten. You have to submit your answer in .pdf format.
    Be careful with your time. Manage your time properly to complete answering and submitting your script within the allocated time.

    
    

• Week 9
  

  Week 9

  Week 9
  

  • Lecture 12

    Learning Outcome:
    

    • Transaction
    • Transaction State Diagram
    • Commit
    • Rollback
    • Savepoint

    
    

    
    
  • Transaction Part 1 File

    View

    Lecture Slide: Transaction I

    Class Lecture Video: Transaction I

  • Lecture 13

    Learning Outcome:
    

    • Transaction ACID properties
    • Transaction State Diagram
    • Deadlock

    
    

    
    
  • Transaction Part 1 (copy) File

    View

    Lecture Slide: Transaction II

    Class Lecture Video: Transaction II

• Presentation
  

  Presentation

  PRESENTATION

  
  

  Submission: Google Form 
  Deadline: 10.04.2021 11:59pm
• Week 10
  

  Week 10

  Week 10
  

  • Lecture 14

    Learning Outcome:
    

    • Database Normalization

    
    

    
    
  • Reference Video

    Mark as done
  • Normalization part 1(Slide) File

    View

    Normalization Lecture Video

  • Normalization Example File

    View

    • Example-1

    • Example-2

    • Example-3

  • Normalization exercise File

    Mark as done
  • Assignment-2 (Create Database and Relation)

    1. Create a database named 'university' and  Make the following relation using Mysql or Sql Commands under this database.

    2. After making these relations insert at least 5 records into each table.

    3. Take screenshots of your query and submit them in a single pdf.
    

    
    

  • Quiz-3 Assignment

    Mark as done

    DBMS Quiz-3

    Quiz Type: Written

    Syllabus: Transaction, Deadlock, Normalization

    Date: 08.04.2021   7:00 pm

• Week 11
  

  Week 11

  Week 11

  • Lecture 15

    Learning Outcome:
    

    • Stored Procedure
    • Create a procedure in SQL
    • Trigger

    
    

  • Lecture 16 

    Learning Outcomes

    • What is DB Trigger?  
    • Trigger Syntax, 
    • Explanation of Trigger Syntax, 
    • Trigger Example

    
    

    Mark as done
  • Reference Video

    Mark as done
  • Stored Procedure and views(Slide) File

    View

    Stored Procedure and Views (Slide)
    

    • Class Lecture Video-1
    • Class Lecture Video-2

  • Trigger in Database(Slide) File

    Trigger(Slide)

    • Class Lecture Video

• Week 12
  

  Week 12

  Week 12
  

  • Lecture 17

    Learning Outcome:
    

    • Database Security

    
    

    
    
  • Database Security Lecture Slide

    Database Security Lecture Video

    Mark as done
• Review Week
  

  Review Week

  Review Week

  
  

  • Quiz-3

    Mark as done
• Final Assessment
  

  Final Assessment

  Final Assessment-Spring_2021
  

  • Final Assessment Syllabus

    • ER Diagram Transaction Trigger Stored Procedure Deadlock	Normalization Database Security SQL Relational Algebra

      
      

    Mark as done
  • Final Assessment Assignment

    Mark as done

    Instructions:
    ·         Read the question paper carefully.
    ·         Write all answers either on paper or in text format.
    ·         Make a single pdf file of your answer script.
    ·         Submit the answer pdf file within the given time.

    
    

    Starting Time: 10:00 am                Closing Time: 2:00 pm

    You are being requested to submit your answer script in both the BLC submission and in the Google Form. Google form submission is mandatory. BLC submission is optional.

    
    

    File size may exceed 5MB. Then the only submission in google form will be ok.

    
    

    Google Form Submission Link: Click Here