Section: Week 2 (Data Model and Languages) | Database Management System (Fall 2020)

Lecture Objectives:

Level of Abstraction, Data Models, Database Languages
Two Tier Architecture, Three Tier Architecture
Discuss all types of keys in relational DB Model.

Expected outcome

Able to know the level of abstraction, database languages and make relational model with keys.

Class Discussion Slide-4 URL

Lecture Video

Class Discussion Slide-5 URL

Class Discussion Slide-6 URL

Lecture Video

Self Assessment URL

Class Discussion Slide-7 URL

Lecture Video

Forum Discussion

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)

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