CSE311+CSE312(SSH-203): Relational Algebra

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

0%

Previous
Relational Algebra

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

Guidelines
For Teachers For Students

Search Close

Toggle search input

Log in

Username

Password

Remember username
Forgot Password?
Create new account

Course Overview

Sections

Announcements Forum
Welcome to DBMS Class Forum

Course Summary and Objectives 2

OBE Course outline File
Lab Docs URL
DBMS Project List File

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

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

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

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

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

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

SQL Queries File
Numeric Functions, Date & Time Functions File URL
class (31-10-2020) (PC-A) URL

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

Stored Procedurer and Views File
Feedback (stored procedure) (pc-a & pc-b) Choice
Discussion Forum
Class (22-11-2020) (pc-a) URL

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

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

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

Previous Semester's Final Examination Question File

Presentation 19

MID TERM EXAM Fall-2020 20

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 3
Relational Algebra

Relational Algebra

Lecture Objectives:

Selection Operator, Projection Operator, Cartesian Product

Click Lesson_7.pdf link to view the file.

Previous Activity

Jump to...

Next Activity

Follow Us

Follow Us

Follow Us

Follow Us

Guidelines
- For Teachers
- For Students

Copyright © 2022 Daffodil International University. All Rights Reserved.

DIU Blended Learning Center © 2024. All rights reserved.

Terms & Conditions Privacy Policy

You are currently using guest access (Log in)