CSE 311 (RKR-203): Presentation

Course Menu

Opened: Tuesday, 15 December 2020, 12:00 AM

Due: Sunday, 20 December 2020, 12:00 AM

First of all upload your presentation slide and video file in your google drive then crate link then upload the link here.

General

Welcome to DBMS Class

Course Summary and Objectives

OBE Course outline

Course Introduction

Week 1 (Introduction to DBMS)

Class Discussion Slide-1

Class Discussion Slide-2

Class Discussion Slide-3

What have I Learned from this week [MCQ]

Forum Discussion about pros and cons of Conventional File Processing System

Week 2 (Data Model and Languages)

Class Discussion Slide-4

Class Discussion Slide-5

Class Discussion Slide-6

Self Assessment

Class Discussion Slide-7

Forum Discussion

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

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

Week 3 (ER to Schema Mapping)

Class Discussion Slide-8

Class Discussion Slide-9

ER to Schema Mapping (Video Lesson)

Class Discussion Slide-10

Assignment-2 (ER to Schema Mapping)

Five Minutes Practice

Homework (Relational Algebra)

Forum Discussion

Week 4 (SQL Queries)

Class Discussion Slide-11

Self Assessment

Forum Discussion

Interactive Self_Test

Week 5 (Join Operation)

Class Discussion Slide-12

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Week 6 (Basic SQL Queries)

SQL queries in Database

Class Discussion Slide-13

Discussion about SQL queries

Quiz 02

weekly Discussion

Week 7 (Operation and Functions)

Midterm Week (Week 8)

Midterm Exam Guideline

Midterm Exam

Midterm Exam Review

Week 8 (Nested Queries)

Class Discussion Slide-15

Class Discussion Slide-16

Forum Discussion

Week 9 (Stored Procedure and Normalization)

Class Discussion Slide-17

Class Discussion Slide-18

Class Discussion [Forum]

Week 10 (Database Transaction)

Class Discussion Slide-19

Class Discussion Slide-20

Class Discussion [Forum]

Quiz 03

Presentation

Week 11 (Trigger and Injection in DBMS)

Class Discussion Slide

SQL Injection

Final Assignment

Final Exam Reivew [Forum]

Week 12 (Final Exam Week)

Final Exam

Documents and Slides (Resource Pack)

Introduction to Database Management System

Purpose of Database System File

Relational Model in DBMS

Level of Abstraction and Data Models

Database Architecture

Types of Keys in Relational Model

Entity Relationship (ER) Model