Database Management System (Spring 21)

Section outline

• Select section General

  General

  Collapse all Expand all

  • Select activity Announcements

    

    Announcements Forum
  • Select activity Announcements

    

    Announcements Forum
  • Select activity Welcome to DBMS Class

    

    Welcome to DBMS Class Forum

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

    Instructor,

    

    Name                      : Faisal Ahmed
    Destination            : Lecturer                                                                                   
    Office                      : DIU, Asulia                                                                        
    Cell                         : 01776107653
    E-mail                    : faisalahmed.cse@diu.edu.bd
    Web Profile          : https://sites.google.com/diu.edu.bd/faisal-ahmed/home

    Google Scholar  : https://scholar.google.com/citations?hl=en&user=KsY-J4QAAAAJ

    
    
  • Select activity Experience with BLC

    

    Experience with BLC Survey

    Completion

    Students must

    

    Mark as done
  • Select activity Join us on TELEGRAM

    

    Join us on TELEGRAM URL

    Completion

    Students must

    

    Mark as done
• Select section Course Summary and Objectives

  Course Summary and Objectives

  
  

  • Select activity Course Rationale Database Management Systems (...

    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.

  • Select activity Course Objective: Upon successful completion o...

    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.

    
    

  • Select activity Course OutcomeCO1To be able to apply analytical sk...

    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.
    
    
    
  • Select activity OBE Course outline

    

    OBE Course outline File
  • Select activity Course Assessment:Final grade in each course will ...

    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.

    
    

  • Select activity Text Book Database System Con...

    Text Book

    

    
    

    
    

    
    

    Database System Concept, Silbertz, Korth and Sudarshan

    
    

  • Select activity Reference Book Fundamentals o...

    Reference Book

    

    
    

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

    
    

• Select section Course Introduction

  Course Introduction

  • Select activity Label

• Select section Week 1

  Week 1

  • Select activity Introduction to Database Management System

    

    Introduction to Database Management System File

    Lecture Objectives:

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

    
    

    
    

    (Class Lecture_1)
    

  • Select activity Purpose of Database System

    

    Purpose of Database System File

    Lecture Objectives:

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

    
    

    
    

    
    

    (Class_Lecture_2)
    

  • Select activity What have I Learned

    

    What have I Learned Quiz
  • Select activity Relational Model in DBMS

    

    Relational Model in DBMS File

    Lecture Objectives:

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

    
    

    (Class_Lecture_3)
    

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

    

    Forum Discussion about pros and cons of Conventional File Processing System
• Select section Week 2

  Week 2

  • Select activity Level of Abstraction, Data Models, Database Languages

    

    Level of Abstraction, Data Models, Database Languages File

    
    

    
    

    (Class_Lecture_4)
    

  • Select activity Database Architecture

    

    Database Architecture File

    Lecture Objectives:

    • Two Tier Architecture, Three Tier Architecture
      

  • Select activity Types of Keys in Relational Model

    

    Types of Keys in Relational Model File

    Lecture Objectives:

    • Discuss all types of keys in relational DB Model.
      

    
    
                                                                      (Class_Lecture_5)
    

  • Select activity Entity Relationship (ER) Model

    

    Entity Relationship (ER) Model File

    Lecture Objectives:

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

    
    

    
    

    (Class_Lecture_6)
    

  • Select activity 10 Minutes Practice [Click Here]

    

    10 Minutes Practice [Click Here] URL
  • Select activity Use LucidChart to implement your 10 Minutes Work

    

    Use LucidChart to implement your 10 Minutes Work URL
  • Select activity Assignment-1 (Draw ER Diagram of your favourite sport team)

    

    Assignment-1 (Draw ER Diagram of your favourite sport team)
• Select section Week 3

  Week 3

  • Select activity ER to Schema Mapping

    

    ER to Schema Mapping File
  • Select activity ER to Schema Mapping (Video Lesson)

    

    ER to Schema Mapping (Video Lesson) URL

    
    
                                                                             (Class_Lecture_7)
    

  • Select activity Assignment-2 (ER to Schema Mapping)

    

    Assignment-2 (ER to Schema Mapping)
  • Select activity Relational Algebra

    

    Relational Algebra File

    Lecture Objectives:

    • Selection Operator, Projection Operator, Cartesian Product

    
    

    (Class_Lecture_8)
    

  • Select activity Five Minutes Practice

    

    Five Minutes Practice File
  • Select activity Homework (Relational Algebra)

    

    Homework (Relational Algebra) Forum
  • Select activity Quiz-1

    

    Quiz-1

    Completion

    Students must

    

    View
• Select section Week 4

  Week 4

  • Select activity Basic SQL Queries (P-1)

    

    Basic SQL Queries (P-1) File

    Lecture Objectives:

    •CRUD (Create, Read, Update, Delete) operation  •Where and Order By Clause  •Group By Clause

    
    

    
    

    (Class_Lecture_8)
    

  • Select activity Assignment-3 (Create Database and Relation)

    

    Assignment-3 (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.

    
    

    
    

• Select section Week 5

  Week 5

  • Select activity Join Operation in DBMS

    

    Join Operation in DBMS File

    Lecture Objectives:

    • INNER Join, Outer Join
      
  • Select activity Database Join Operation with Example

    

    Database Join Operation with Example URL

    
    

    (Class_Lecture_8)
    

  • Select activity SQL Join 10 Minutes Practice

    

    SQL Join 10 Minutes Practice Quiz
  • Select activity Discussion regarding SQL Join Operation

    

    Discussion regarding SQL Join Operation Forum
• Select section Week 6

  Week 6

  • Select activity SQL queries in Database

    

    SQL queries in Database URL

    Lecture Objectives:

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

    
    

    (FULL_WEEK_LECTURE_DISCUSSION_FA)
    

  • Select activity Basic SQL Queries (P-2)

    

    Basic SQL Queries (P-2) File

    Lecture Objectives:
    

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

    
    

  • Select activity Discussion about SQL queries

    

    Discussion about SQL queries Forum
• Select section Week 7

  Week 7

  • Select activity SQL Queries

    

    SQL Queries File

    Lecture Objectives:

    • Delete Operation,•Update Operation

    
    
  • Select activity Numeric Functions, Date & Time Functions File

    

    Numeric Functions, Date & Time Functions File URL

    Date Function

    
    

  • Select activity Quiz-2 (Time:1hour) : Please submit your answer script as ID_Section_Quiz2.pdf by 9.30PM

    

    Quiz-2 (Time:1hour) : Please submit your answer script as ID_Section_Quiz2.pdf by 9.30PM

    Completion

    Students must

    

    View

    

    Receive a grade
• Select section Week 8

  Week 8

  • Select activity MID TERM EXAM

    

    MID TERM EXAM Assignment

    Completion

    Students must

    

    Mark as done
• Select section Week 9

  Week 9

  • Select activity Subqueries in DBMS

    

    Subqueries in DBMS File

    Lecture Objectives:

    1. Learn to subqueries in DBMS

    
    

  • Select activity Subqueries in DBMS

    

    Subqueries in DBMS File

    Lecture Objectives:

    1. Learn to subqueries in DBMS
    

• Select section Week 10

  Week 10

  • Select activity Stored Procedurer and Views

    

    Stored Procedurer and Views File
• Select section Week 11

  Week 11

  • Select activity Database Normalization

    

    Database Normalization File

    Lecture Objectives:

    • First Normal Form, Second Normal Form, Third Normal Form

    
    

    
    

    FA_Meets_Lecture
    

• Select section Week 12

  Week 12

  • Select activity Database Transaction

    

    Database Transaction File

    Lecture Objectives:

    • Transaction Operation in Database
      
  • Select activity Database Transaction

    

    Database Transaction File
  • Select activity Quiz-3

    

    Quiz-3 Assignment

    Completion

    Students must

    

    Mark as done
• Select section Week 13

  Week 13

  • Select activity Trigger in Database

    

    Trigger in Database File

    Lecture Objectives

    • What is DB Trigger?  Trigger Syntax, Explanation of Trigger Syntax, Trigger Example
      
  • Select activity SQL Injection

    

    SQL Injection URL
  • Select activity Submit your assignment on SQL injection and its prevention

    

    Submit your assignment on SQL injection and its prevention

    Completion

    Students must

    

    Mark as done
  • Select activity Submit your presentation drivelink

    

    Submit your presentation drivelink Assignment

    Completion

    Students must

    

    Mark as done
• Select section Week 14

  Week 14

  • Select activity Discussion the Final Syllabus and Problems

    Discussion the Final Syllabus and Problems
    

  • Select activity FINAL EXAM (Please read the instructions first)

    

    FINAL EXAM (Please read the instructions first) Assignment

    Completion

    Students must

    

    Mark as done
• Select section Topic 17

  Topic 17
• Select section Topic 18

  Topic 18
• Select section Topic 19

  Topic 19
• Select section Topic 20

  Topic 20
• Select section Topic 21

  Topic 21
• Select section Topic 22

  Topic 22
• Select section Topic 23

  Topic 23
• Select section Topic 24

  Topic 24
• Select section Topic 25

  Topic 25
• Select section Topic 26

  Topic 26
• Select section Topic 27

  Topic 27
• Select section Topic 28

  Topic 28
• Select section Topic 29

  Topic 29
• Select section Topic 30

  Topic 30
• Select section Topic 31

  Topic 31
• Select section Topic 32

  Topic 32
• Select section Topic 33

  Topic 33
• Select section Topic 34

  Topic 34
• Select section Topic 35

  Topic 35
• Select section Topic 36

  Topic 36
• Select section Topic 37

  Topic 37
• Select section Topic 38

  Topic 38
• Select section Topic 39

  Topic 39
• Select section Topic 40

  Topic 40
• Select section Topic 41

  Topic 41
• Select section Topic 42

  Topic 42
• Select section Topic 43

  Topic 43
• Select section Topic 44

  Topic 44
• Select section Topic 45

  Topic 45
• Select section Topic 46

  Topic 46
• Select section Topic 47

  Topic 47
• Select section Topic 48

  Topic 48
• Select section Topic 49

  Topic 49
• Select section Topic 50

  Topic 50