CSE311+CSE312(SSH-203): discussion

DIU-BLC

Database Management System Theory and Lab SSH(Fall-2020)

0%

Previous
Discussion

General

Announcements

Welcome to DBMS Class

Course Summary and Objectives

OBE Course outline

Lab Docs

DBMS Project List

Week 1

Introduction to Database Management System

Purpose of Database System

Relational Model in DBMS

What have I Learned

Forum Discussion about pros and cons of Conventional File Processing System

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

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

LAB-1 (06/10/2020)

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

Discussion about Lab-1

Lab Class-1 (06-10-2020)

Week 2

Level of Abstraction, Data Models, Database Languages

Database Architecture

Types of Keys in Relational Model

Entity Relationship (ER) Model

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

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

Feedback (05-10-2020)

Class (05-10-2020) PC-A

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

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

Lab-2 (PC-A)

Quiz-1

Week 3

ER to Schema Mapping

Er to schema mapping

ERD

ERD_exercise_1

ERD_exercise_2

ERD_exercise_3

ER to Schema Mapping (Video Lesson)

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

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

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

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

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

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

Discussion about ERD to relational schema mapping

Class (17-10-2020) PC-B

Relational Algebra

Five Minutes Practice

Discussion (Relational Algebra)

Feedback (19-10-2020) (PC-A & PC-B)

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

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

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

Lab Class-3 (19-10-2020) (PC-B)

Lab Class-3 (PC-A) (20-10-2020)

Week 4

Basic SQL Queries (P-1)

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

Discussion

Class (27-10-2020) (SQL-1)

Week 5

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

Join Operation in DBMS

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation)

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

Week 6

SQL queries in Database

Basic SQL Queries (P-2)

Discussion about SQL queries

Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2)

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

Week 7

SQL Queries

Numeric Functions, Date & Time Functions File

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

Week 8

Subqueries in DBMS

Subqueries in DBMS

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

Midterm Week (Week 9)

Previous Semester's Midterm Examination Question

Week 10

Stored Procedurer and Views

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

Discussion

Class (22-11-2020) (pc-a)

Week 11

Database Normalization

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

Discussion

class (23-11-2020) pc-a

class (normalization) pc-b

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

LAB 23-11-2020 (PC-B)

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

Week 12

Database Transaction

Database Transaction

Feedback (28-11-2020) (PC-A & PC-B)

Discussion (pc-a and pc-b)

transaction (28-11-2020) PC-A

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

Database transaction part-2

Week 13

Trigger in Database

SQL Injection

class 30-11-2020 (pc-b)

class 30-11-2020 PC-A

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

ra review class 7-12-2020 pc-a

12-12-2020 (pc-b)

12-12-2020 pc-a

lab 14-12-2020

Week 14

Previous Semester's Final Examination Question

Assignment

Presentation

MID TERM EXAM Fall-2020

Quiz-3
Next