Midterm Exam Review

List of discussions. Showing 1 of 1 discussions
Status	Discussion	Started by	Last post	Replies	Actions
	Midterm Exam	Rahmatul Kabir Rasel Sarker 25 Nov 2020	Md Imtiaz _182-15-11790 25 Nov 2020	6

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