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
DIU-BLC
Side panel
Guidelines
For Teachers
For Students
Search
Close
Search
Toggle search input
Log in
Username
Password
Remember username
Forgot Password?
Log in
Create new account
Course Overview
Sections
General
1
Announcements
Forum
Welcome to DBMS Class
Forum
Course Summary and Objectives
2
OBE Course outline
File
Lab Docs
URL
DBMS Project List
File
Week 1
3
Introduction to Database Management System
File
Purpose of Database System
File
Relational Model in DBMS
File
What have I Learned
Quiz
Forum Discussion about pros and cons of Conventional File Processing System
Class (03/10/2020) (PC-A)
URL
Class (03/10/2020) (PC-B)
URL
LAB-1 (06/10/2020)
URL
Feedback (Lab-1 (06-10-2020))
Choice
Discussion about Lab-1
Forum
Lab Class-1 (06-10-2020)
URL
Week 2
4
Level of Abstraction, Data Models, Database Languages
File
Database Architecture
File
Types of Keys in Relational Model
File
Entity Relationship (ER) Model
File
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)
Feedback (05-10-2020)
Choice
Class (05-10-2020) PC-A
URL
Lab-2 (12-10-2020) (PC-B)
URL
Feedback (Lab-2) (PC-A & PC-B)
Choice
Lab-2 (PC-A)
URL
Quiz-1
5
Week 3
6
ER to Schema Mapping
File
Er to schema mapping
File
ERD
File
ERD_exercise_1
File
ERD_exercise_2
File
ERD_exercise_3
File
ER to Schema Mapping (Video Lesson)
URL
Class: 12-10-2020 (PC-A)
URL
Class: 12-10-2020 (PC-B)
URL
Feedback (12-10-2020) (PC-A & PC-B)
Choice
Class (17-10-2020) (PC-A)
URL
Feedback (17-10-2020) (PC-A & PC-B)
Choice
Review Assignment (class: 17-10-2020) (PC-A & PC-B)
Discussion about ERD to relational schema mapping
Forum
Class (17-10-2020) PC-B
URL
Relational Algebra
File
Five Minutes Practice
File
Discussion (Relational Algebra)
Forum
Feedback (19-10-2020) (PC-A & PC-B)
Choice
Class (19-10-2020) (PC-A)
URL
Class (19-10-2020) (PC-B)
URL
Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B)
Choice
Lab Class-3 (19-10-2020) (PC-B)
URL
Lab Class-3 (PC-A) (20-10-2020)
URL
Week 4
7
Basic SQL Queries (P-1)
File
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1)
Choice
Discussion
Forum
Class (27-10-2020) (SQL-1)
URL
Week 5
8
Class: 12-10-2020 (PC-A)
URL
Join Operation in DBMS
File
Database Join Operation with Example
URL
SQL Join 10 Minutes Practice
Quiz
Discussion regarding SQL Join Operation
Forum
Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation)
Choice
Class (27-10-2020) (SQL-2)
URL
Week 6
9
SQL queries in Database
URL
Basic SQL Queries (P-2)
File
Discussion about SQL queries
Forum
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2)
Choice
Class (27-10-2020) (SQL-3)
URL
Week 7
10
SQL Queries
File
Numeric Functions, Date & Time Functions File
URL
class (31-10-2020) (PC-A)
URL
Week 8
11
Subqueries in DBMS
File
Subqueries in DBMS
File
class (31-10-2020) (PC-B)
URL
Midterm Week (Week 9)
12
Previous Semester's Midterm Examination Question
File
Week 10
13
Stored Procedurer and Views
File
Feedback (stored procedure) (pc-a & pc-b)
Choice
Discussion
Forum
Class (22-11-2020) (pc-a)
URL
Week 11
14
Database Normalization
File
Feedback (normalization) (pc-a & pc-b)
Choice
Discussion
Forum
class (23-11-2020) pc-a
URL
class (normalization) pc-b
URL
Feedback (LAB-23-11-2020) (pc-a & pc-b)
Choice
LAB 23-11-2020 (PC-B)
URL
Lab-24/11/2020 (pc-a)
URL
Week 12
15
Database Transaction
File
Database Transaction
File
Feedback (28-11-2020) (PC-A & PC-B)
Choice
Discussion (pc-a and pc-b)
Forum
transaction (28-11-2020) PC-A
URL
transaction (28-11-2020) (pc-b)
URL
Database transaction part-2
File
Week 13
16
Trigger in Database
File
SQL Injection
URL
class 30-11-2020 (pc-b)
URL
class 30-11-2020 PC-A
URL
ra review class (7-12-2020) (pc-b)
URL
ra review class 7-12-2020 pc-a
URL
12-12-2020 (pc-b)
URL
12-12-2020 pc-a
URL
lab 14-12-2020
URL
Week 14
17
Previous Semester's Final Examination Question
File
Assignment
18
Presentation
19
MID TERM EXAM Fall-2020
20
Quiz-3
21
Skip to main content
Database Management System Theory and Lab SSH(Fall-2020)
Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Fall 20
CSE311+CSE312(SSH-203)
Week 4
Discussion
Search forums
Search forums
Discussion
Mark as done
List of discussions. Showing 20 of 20 discussions
Status
Discussion
Started by
Last post
Replies
Actions
Basic SQL
Locked
Omar Faruq Fahim
28 Nov 2020
Omar Faruq Fahim
28 Nov 2020
0
Basic sql
Locked
Md. Tamjeed Monshi
29 Oct 2020
Md. Tamjeed Monshi
29 Oct 2020
0
Basic SQL Queries
Locked
Fahim Yusuf
27 Oct 2020
Fahim Yusuf
27 Oct 2020
0
Basic SQL Queries
Locked
Moklasur Rahman
23 Nov 2020
Moklasur Rahman
23 Nov 2020
0
Basic SQL Queries
Locked
Shakil Ahmmed
28 Oct 2020
Shakil Ahmmed
28 Oct 2020
0
Basic SQL Queries
Locked
Md. Zayed Hassan Bhuiyan
23 Nov 2020
Md. Zayed Hassan Bhuiyan
23 Nov 2020
0
Basic SQL Queries
Locked
Mahmudur Rahman Rifat
30 Oct 2020
Mahmudur Rahman Rifat
30 Oct 2020
0
Basic SQL Queries
Locked
Sifat Ul Haque
27 Oct 2020
Sifat Ul Haque
27 Oct 2020
0
Basic SQL query
Locked
Reaz Uddin Rafi
31 Oct 2020
Reaz Uddin Rafi
31 Oct 2020
0
Basic SQL query
Locked
khadiza Akter
1 Nov 2020
khadiza Akter
1 Nov 2020
0
Basic SQL Query
Locked
iftekhar jahan Soron
31 Oct 2020
iftekhar jahan Soron
31 Oct 2020
0
Basic SQL Query
Locked
Mahfuzur Rahman
31 Oct 2020
Mahfuzur Rahman
31 Oct 2020
0
basic sql query
Locked
Marupa Akter
27 Oct 2020
Marupa Akter
27 Oct 2020
0
basiq sql query
Locked
Zobayda Akter
28 Oct 2020
Zobayda Akter
28 Oct 2020
0
Discussion
Locked
Obaidul Islam
30 Oct 2020
Obaidul Islam
30 Oct 2020
0
Discussion
Locked
Shakhawat Hossain 183-15-2335
8 Nov 2020
Shakhawat Hossain 183-15-2335
8 Nov 2020
0
Discussion
Locked
Anik Das
3 Dec 2020
Anik Das
3 Dec 2020
0
discussion
Locked
Salma Akter
24 Dec 2020
Salma Akter
24 Dec 2020
0
Discussion about Basic SQL Queries
Locked
Arafat Hosaain
5 Nov 2020
Arafat Hosaain
5 Nov 2020
0
Discussion about Basic SQL Queries
Locked
Himanish Debnath.[Himu]
29 Oct 2020
Md.Muktar Ali
29 Oct 2020
1
Previous Activity
Jump to...
Jump to...
Announcements
Welcome to DBMS Class
OBE Course outline
Lab Docs
DBMS Project List
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)
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)
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)
Basic SQL Queries (P-1)
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1)
Class (27-10-2020) (SQL-1)
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)
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)
SQL Queries
Numeric Functions, Date & Time Functions File
class (31-10-2020) (PC-A)
Subqueries in DBMS
Subqueries in DBMS
class (31-10-2020) (PC-B)
Previous Semester's Midterm Examination Question
Stored Procedurer and Views
Feedback (stored procedure) (pc-a & pc-b)
Discussion
Class (22-11-2020) (pc-a)
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)
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
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
Previous Semester's Final Examination Question
Next Activity