Topic outline

• General
  

  General

  • Announcements Forum
  • Welcome to DBMS Class Forum

    Dear Students,
    
    Welcome to the 2020 Fall Semester!
    
    Welcome back, Students. I can’t wait to see all your smiling faces again! . 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.

    Audio Welcome Letter: 

    
    

    
    

    
    

    
    

    
    

    Instructor

    
    

    

    Shahana Shultana

    Lecturer

    Department of CSE

    Daffodil International University

    Email: shahana.cse@diu.edu.bd

    Phone: +8801672860365
    

    Office: Room #505 AB-04, Daffodil International University, Savar, Dhaka  

    
    

    Prefect 

    
    

    Md Fazley Rabbe
    Email: fazley15-1519@diu.edu.bd

    Mobile: +8801701046745 (Telegram) 

    
    

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

    

    
    

    
    

    Database System Concept, Silbertz, Korth and Sudarshan

    
    

  • Reference Book

    

    
    

    Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.

    
    

  • Lab Docs URL

    Mark as done
  • DBMS Project List File

    Mark as done
  • DBMS LAB FINAL (PC-B) Assignment

    Restricted Not available unless: You belong to PC-B

    Please submit your video through this google form: https://docs.google.com/forms/d/1X3JJQFMl-R7T6BJCKtA9o7eNDxmTG19PHdoF9OvbXLQ/viewform?fbclid=IwAR07FF5Bh_U68cDbR1hADlasKwWBK-6po1SxA3pvCo3bEERD2o2jBfgjN7c&edit_requested=true 

  • DBMS LAB FINAL (PC-A) Assignment

    Restricted Not available unless: You belong to PC-A

    Please submit your video through this google form: https://docs.google.com/forms/d/1X3JJQFMl-R7T6BJCKtA9o7eNDxmTG19PHdoF9OvbXLQ/viewform?fbclid=IwAR07FF5Bh_U68cDbR1hADlasKwWBK-6po1SxA3pvCo3bEERD2o2jBfgjN7c&edit_requested=true 

• Week 1
  

  Week 1

  • Introduction to Database Management System File

    Lecture Objectives:

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

    
    

  • Purpose of Database System File

    Lecture Objectives:

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

    
    

  • Relational Model in DBMS File

    Lecture Objectives:

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

    
    

  • What have I Learned Quiz

    Mark as done
  • Forum Discussion about pros and cons of Conventional File Processing System
  • Feedback (03-10-2020) (PC-A) Choice

    Restricted Not available unless: You belong to PC-A

    Today's class was:

  • Feedback (03-10-2020) (PC-B) Choice

    Restricted Not available unless: You belong to PC-B

    Today's class was:

  • Class (03/10/2020) (PC-A) URL

    Mark as done

    
    

  • Class (03/10/2020) (PC-B) URL

    Mark as done

    
    

  • LAB-1 (06/10/2020) URL

    Mark as done

    
    

  • Feedback (Lab-1 (06-10-2020)) Choice

    Mark as done

    Today's class was:

  • Discussion about Lab-1 Forum

    Mark as done
  • Lab Performance-1 (PC-A) Assignment

    Restricted Not available unless: You belong to PC-A
  • Lab Performance-1 (PC-B) Assignment

    Restricted Not available unless: You belong to PC-B
  • Lab Class-1 (06-10-2020) URL

    Mark as done

    PC-A

    PC-B

    
    

• Week 2
  

  Week 2

  • Level of Abstraction, Data Models, Database Languages File

  • Database Architecture File

    Lecture Objectives:

    • Two Tier Architecture, Three Tier Architecture
      

  • Types of Keys in Relational Model File

    Lecture Objectives:

    • Discuss all types of keys in relational DB Model.
      

  • Entity Relationship (ER) Model File

    Lecture Objectives:

    • Entity, Entity Type and Entity Set, Learn how to make ER model using symbol
      

  • Expected outcome
    

    • Able to know the level of abstraction, database languages and make relational model with keys.

    
    

  • 10 Minutes Practice [Click Here] URL
  • Use LucidChart to implement your 10 Minutes Work URL
  • Assignment-1 (Draw ER Diagram of your favourite sport team)
  • Start Your Journey with SQL (Write Program in Oracle Live SQL)
    

  • Feedback (05-10-2020) Choice

    Mark as done

    Today's class was:

  • Class (05-10-2020) PC-A URL

    Mark as done

    
    

  • Lab-2 (12-10-2020) (PC-B) URL

    Mark as done

    
    

  • Feedback (Lab-2) (PC-A & PC-B) Choice

    Mark as done

    Today's Lab Class was:

  • Lab Performance-2 (PC-B) Assignment

    Restricted Not available unless: You belong to PC-B
  • Lab Performance-2 (PC-A) Assignment

    Restricted Not available unless: You belong to PC-A
  • Lab-2 (PC-A) URL

    Mark as done

    
    

• Quiz-1
  

  Quiz-1

  • Quiz-1 (PC-A)

    Restricted Not available unless: You belong to PC-A
  • Quiz-1 (PC-B)

    Restricted Not available unless: You belong to PC-B
• Week 3
  

  Week 3

  • ER to Schema Mapping File
  • Er to schema mapping File

    Mark as done
  • ERD File

    Mark as done
  • ERD_exercise_1 File

    Mark as done
  • ERD_exercise_2 File

    Mark as done
  • ERD_exercise_3 File

    Mark as done
  • ER to Schema Mapping (Video Lesson) URL

  • Class: 12-10-2020 (PC-A) URL

    Mark as done

    
    

  • Class: 12-10-2020 (PC-B) URL

    Mark as done

    
    

  • Feedback (12-10-2020) (PC-A & PC-B) Choice

    Mark as done

    Today's Class was:

  • Class (17-10-2020) (PC-A) URL

    Mark as done

    
    

  • Feedback (17-10-2020) (PC-A & PC-B) Choice

    Mark as done

    Today's Class was:

  • Review Assignment (class: 17-10-2020) (PC-A & PC-B)

    Mark as done

    ERD to Relational Schema Mapping 

  • Discussion about ERD to relational schema mapping Forum

    Mark as done
  • Class (17-10-2020) PC-B URL

    Mark as done

    
    

  • Relational Algebra File

    Lecture Objectives:

    • Selection Operator, Projection Operator, Cartesian Product

  • Expected outcome
    

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

    
    

  • Five Minutes Practice File
  • Discussion (Relational Algebra) Forum
  • Feedback (19-10-2020) (PC-A & PC-B) Choice

    Mark as done

    Today's Class was:

  • Class (19-10-2020) (PC-A) URL

    Mark as done

    
    

  • Class (19-10-2020) (PC-B) URL

    Mark as done

    
    

  • Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B) Choice

    Mark as done
  • Lab Class-3 (19-10-2020) (PC-B) URL

    Mark as done

    
    

  • Lab Performance-3 Assignment

    Restricted Not available unless: You belong to PC-B
  • Lab Performance-3 (PC-A) Assignment

    Restricted Not available unless: You belong to PC-A
  • Lab Class-3 (PC-A) (20-10-2020) URL

    Mark as done

    
    

• Week 4
  

  Week 4

  • Basic SQL Queries (P-1) File

    Lecture Objectives:

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

    
    

  • Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1) Choice

    Mark as done

    Today's Class was:

  • Discussion Forum

    Mark as done
  • Class (27-10-2020) (SQL-1) URL

    Mark as done

    
    

• Week 5
  

  Week 5

  • Class: 12-10-2020 (PC-A) URL

    Mark as done

    
    

  • Join Operation in DBMS File

    Lecture Objectives:

    • INNER Join, Outer Join
      
  • Database Join Operation with Example URL

  • Expected outcome
    

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

    
    

  • SQL Join 10 Minutes Practice Quiz
  • Discussion regarding SQL Join Operation Forum
  • Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation) Choice

    Mark as done

    Today's Class was:

  • Class (27-10-2020) (SQL-2) URL

    Mark as done

    
    

• Week 6
  

  Week 6

  • SQL queries in Database URL

    Lecture Objectives:

    • Between and In Queries, Exist and not exists Queries, Like Operator, Group by with having clause
      

  • Basic SQL Queries (P-2) File

    Lecture Objectives:
    

    • Rename Operation, Order By, Set Operations, Nested Query Using Set Operation

    
    

  • Expected outcome
    

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

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • Discussion about SQL queries Forum
  • Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2) Choice

    Mark as done

    Today's Class was:

  • Class (27-10-2020) (SQL-3) URL

    Mark as done

    
    

• Week 7
  

  Week 7

  • SQL Queries File

    Lecture Objectives:

    • Delete Operation,•Update Operation

    
    
  • Numeric Functions, Date & Time Functions File URL

    Date Function

    
    

  • Expected outcome
    

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

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • class (31-10-2020) (PC-A) URL

    Mark as done

    
    

• Week 8
  

  Week 8

  • Subqueries in DBMS File

    Lecture Objectives:

    1. Learn to subqueries in DBMS
    

  • Subqueries in DBMS File

    Lecture Objectives:

    1. Learn to subqueries in DBMS

    
    

  • Expected outcome
    

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

    
    

  • class (31-10-2020) (PC-B) URL

    Mark as done

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • Quiz-2 (PC-A)

    Restricted Not available unless: You belong to PC-A
  • Quiz-2 (PC-B)

    Restricted Not available unless: You belong to PC-B
• Midterm Week (Week 9)
  

  Midterm Week (Week 9)

  • 
    

    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

    
    

  • Previous Semester's Midterm Examination Question File

    Previous Semester's Midterm Examination Question for Better Understanding.
    

• Week 10
  

  Week 10

  • Stored Procedurer and Views File
  • Start Practice (Write Program in Oracle Live SQL)
    

  • Feedback (stored procedure) (pc-a & pc-b) Choice

    Mark as done

    today's class was:

  • Discussion Forum

    Mark as done
  • Class (22-11-2020) (pc-a) URL

    Mark as done

    
    

• Week 11
  

  Week 11

  • Database Normalization File

    Lecture Objectives:

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

    
    

  • Feedback (normalization) (pc-a & pc-b) Choice

    Mark as done

    today's class was:

  • Discussion Forum

    Mark as done
  • Project Proposal PC-A Assignment

    Restricted Not available unless: You belong to PC-A
  • Project Proposal PC-B Assignment

    Restricted Not available unless: You belong to PC-B
  • class (23-11-2020) pc-a URL

    Mark as done

    
    

  • class (normalization) pc-b URL

    Mark as done

    
    

  • Feedback (LAB-23-11-2020) (pc-a & pc-b) Choice

    Mark as done

    today's lab class was:

  • LAB 23-11-2020 (PC-B) URL

    Mark as done

    
    

  • Lab-24/11/2020 (pc-a) URL

    Mark as done

    
    

• Week 12
  

  Week 12

  • Database Transaction File

    Lecture Objectives:

    • Transaction Operation in Database
      
  • Expected outcome
    

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

    
    

  • Database Transaction File
  • Feedback (28-11-2020) (PC-A & PC-B) Choice

    Mark as done
  • Discussion (pc-a and pc-b) Forum

    Mark as done
  • transaction (28-11-2020) PC-A URL

    Mark as done

    
    

  • transaction (28-11-2020) (pc-b) URL

    Mark as done

    
    

  • Database transaction part-2 File

    Mark as done
• Week 13
  

  Week 13

  • Trigger in Database File

    Lecture Objectives

    • What is DB Trigger?  Trigger Syntax, Explanation of Trigger Syntax, Trigger Example
      
  • SQL Injection URL
  • Expected outcome
    

    • Able to identify when discrete events occur, and it allows for the user to drill down into the metrics of that event.
      

    
    

  • Start Practice (Write Program in Oracle Live SQL)
    

  • class 30-11-2020 (pc-b) URL

    Mark as done

    
    

  • class 30-11-2020 PC-A URL

    Mark as done

    
    

  • ra review class (7-12-2020) (pc-b) URL

    Mark as done

    
    

  • ra review class 7-12-2020 pc-a URL

    Mark as done

    
    

  • 12-12-2020 (pc-b) URL

    Mark as done

    
    

  • 12-12-2020 pc-a URL

    Mark as done

    
    

  • lab 14-12-2020 URL

    Mark as done
• Week 14
  

  Week 14

  • 
    

    Final Examination Syllabus

    • SQL Queries and Sub-Queries
      
    • Stored Procedure
      
    • Database Normalization
      
    • Database Trigger

    Final Examination Assessment Plan
    Total Marks: 40

  • Previous Semester's Final Examination Question File

    Previous Semester's Final Examination Question for Better Understanding.
    

  • Final Exam PC-A Assignment

    Restricted Not available unless: You belong to PC-A

    FALL-2020

    Please rename your answer script (pdf) using your student ID and then submit.

    
    

  • Final Exam PC-B Assignment

    Restricted Not available unless: You belong to PC-B

    FALL-2020

    Please rename your answer script (pdf) using your student ID and then submit.

    
    

• Assignment
  

  Assignment

  • Assignment-1 (ER to Schema Mapping) (PC-A)

    Restricted Not available unless: You belong to PC-A
  • Assignment-2 (RA) (PC-A)

    Restricted Not available unless: You belong to PC-A
  • Assignment-1 (ER to Schema Mapping) (PC-B)

    Restricted Not available unless: You belong to PC-B
  • Assignment-2 (RA) (PC-B)

    Restricted Not available unless: You belong to PC-B
• Presentation
  

  Presentation

  • Presentation (PC-A) Assignment

    Restricted Not available unless: You belong to PC-A
  • Presentation (PC-B) Assignment

    Restricted Not available unless: You belong to PC-B
• MID TERM EXAM Fall-2020
  

  MID TERM EXAM Fall-2020

  • CSE311 (PC-A) Assignment

    Restricted Not available unless: You belong to PC-A
  • CSE311 (PC-B) Assignment

    Restricted Not available unless: You belong to PC-B
• Quiz-3
  

  Quiz-3

  • Quiz-3 (PC-A)

    Restricted Not available unless: You belong to PC-A
  • Quiz-3 (PC-B)

    Restricted Not available unless: You belong to PC-B