Forum Discussion

To operate the Blended Learning Center(BLC) at optimal level, maintenance will be performed every day at 8:30 AM and at 5:00 PM regularly which can take up to 30 minutes. Please consider scheduling your activity in the BLC platform accordingly.

Forum Discussion

Discuss the problem you faced in the contents of the lecture.

General

.

Welcome to DBMS Class

Course Introduction

Course Summary and Objectives

OBE Course outline

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]

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

Week 3 (ER to Schema Mapping)

Class Discussion Slide-8

Class Discussion Slide-9

ER to Schema Mapping (Video Lesson)

Five Minutes Practice

Forum Discussion

Week 4 (SQL Queries)

Class Discussion Slide-10

Self Assessment

Forum Discussion

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

Week 7 (Operation and Functions)

Class Discussion Slide-14

Numeric Functions, Date &amp; Time Functions File

Review Lectures [Forum]

Midterm Week (Week 8)

Week 8 (Nested Queries)

Class Discussion Slide-15

Class Discussion Slide-16

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

Week 11 (Trigger in DBMS)

Class Discussion Slide

Week 12 (Final Exam Week)

Documents and Slides (Resource Pack)

Forum Discussion

Numeric Functions, Date & Time Functions File