Topic outline

• General
  

  General

  
  

  • Announcements Forum

    Welcome to DBMS

  • 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.
    
    Saif Mahmud Parvez
    

    Lecturer, Dept. of CSE

    Daffodil International University

    Email: saif.cse@diu.edu.bd

    Phone: +8801765455133
    
  • Social 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.
    
    
    
  • 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.

    
    

• Course Introduction
  

  Course Introduction

  • Welcome to the course! File

    Hello Everyone! Greetings! Welcome to database management system course. I am your course teacher, Saif Mahmud Parvez and I gladly inviting all to this semester. In This Semester we will learn all the best things in the dbms course and be sure that it will be interesting. So cheer up! Hope to meet you all in the next classes
    

    
    

• Week 1
  

  Week 1

  • Introduction to Database Management System File

    Lecture Objectives:

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

    The PPT file is attached for better understanding. Also, you can check the attached video.
    
  • Purpose of Database System File

    Lecture Objectives:

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

    
    

  • What have I Learned Quiz
  • Relational Model in DBMS File

    Lecture Objectives:

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

    
    

    
    

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

  Week 2

  • Level of Abstraction, Data Models, Database Languages File

    • The PPT file is enclosed here
    • For more knowledge about Database Model and Abstraction, check out the following video

    
    

    • Check on the link below to provide what you actually learned on today's class 

    https://www.menti.com/8vq2ai9udt
    

  • Dive Deep Into Relational Model File

    Lecture Objectives:

    • Discuss all details relational DB Model.

    Intuition for Relational Database

    • The following video will give you the concept of why actually we need a Relational Database. We will drive deep into our class.

    A deeper knowledge of keys in RDBMS

    • This video will give you more precise knowledge about Super Key, Candidate Key and Primary Key (MUST WATCH)
    • 
      

    
    

  • Simple Quiz on RDBMS for PC-A (01-06-2020)
  • Simple Quiz on RDBMS for PC-B (02-06-2020)
• Week 3
  

  Week 3

  • Entity Relationship (ER) Model File

    Lecture Objectives:

    • Entity, Entity Type and Entity Set, Learn how to make ER model using symbol. The ppt slide is already uploaded.
      
    • The below two links will help you more to know details about drawing ER diagram (It is a MUST READ item).

    1. https://www.guru99.com/er-diagram-tutorial-dbms.html
       
    2. https://www.smartdraw.com/entity-relationship-diagram/
       

    
    

  • Use LucidChart to implement your 10 Minutes Work URL
  • 10 Minutes Practice [Click Here] URL
  • ER to Schema Mapping File
  • ER to Schema Mapping (Video Lesson) URL

• Week 4
  

  Week 4

  • How to convert ER Diagram to Schema Diagram Lesson

    Mark as done

    How to convert ER Diagram to Schema Diagram
    

    •  This video will give you a hint how to convert ER Diagram to Shema Diagram.
      
    • More details are provided in the ppt slide of ER Diagram

    
    

  • Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-A

    • Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. Summary statistics should be modeled as derived attributes.
    • Use https://app.diagrams.net/ {It is for draw.io website} to draw your ER Diagram

    
    

  • Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-B

    • Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. Summary statistics should be modeled as derived attributes. 
    • User https://app.diagrams.net/   {It is for draw.io} to create your ER Diagram
• Week 5
  

  Week 5

  • Basic SQL File

    Mark as done

    Basic SQL

    • Download the attached file for this lesson.
    • Here we will learn all the basic and intermediates of SQL. Also check the lab files 
    • Also a video is embedded for better understanding the CRUD operation

    
    

  • Basic SQL Practice URL

    Mark as done

    Basic SQL Practice

• Week 6
  

  Week 6

  Not available
• Mid Term Week (Week 7)
  

  Mid Term Week (Week 7)

  Not available
• Week 8
  

  Week 8

  Not available
• Week 9
  

  Week 9

  Not available
• Week 10
  

  Week 10

  Not available
• Week 11 (Final Examination)
  

  Week 11 (Final Examination)

  Not available
• Week 12
  

  Week 12

  Not available
• Week 13
  

  Week 13

  Not available
• Week 14
  

  Week 14

  Not available