Course: Database Management System (Summer 20), Section: Week 8

10. Week 8
- More on Subqueries File
  
  This file provides more detailed information on Subqueries. Download this ppt file and have a look
- Join Operation File
  
  Download the ppt file for Join Operation Lecture
  Also see the video provided here (MUST SEE) to have a better understanding
- Database Normalization File
  
  Download all 3 files. PPT file will contain the description of normalization. Other files will provide examples.
  https://drive.google.com/file/d/1tD-IfEVaiYuBEPJS95SCHANFeEYM0W5I/view?usp=sharing
  https://drive.google.com/file/d/1-WNPOAM07sBQXkT1aQHp1e5yDRkr7ffb/view?usp=sharing
- Database Normalization (Video Contents) Lesson
  
  See the following videos for better understanding on Database Normalization
  
  (1)
  (2)
  (3)
  (4)
- Queries on Week 8 Forum
- DBMS, PC-B, New Class, (19-06-2020) Lesson
  
  Restricted Not available unless: You belong to PC-B
  DBMS, PC-B, New Class, (19-06-2020)
  https://drive.google.com/file/d/1UjtPkLf_6h-lxvlhE5g2HCwQeds77uJf/view?usp=sharing
- DBMS, PC-A, New Class, (19-06-2020) Lesson
  
  Restricted Not available unless: You belong to PC-A
  DBMS, PC-A, New Class, (19-06-2020)
  https://drive.google.com/file/d/1TfWSKI8drAqh3GZRfsWYeAWHKZF4PuP2/view?usp=sharing
General
Course Summary and Objectives
Course Introduction
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Mid Term Week (Week 7)
Week 9
Week 10
Week 11 (Final Examination)
Week 12
Week 13
Week 14

◄Mid Term Week (...

Week 9►

General

Announcements

Welcome to DBMS Class

Social forum

Course Summary and Objectives

OBE Course outline

Course Introduction

Welcome to the course!

Week 1

Introduction to Database Management System

Purpose of Database System

What have I Learned

Relational Model in DBMS

Forum Discussion about pros and cons of Conventional File Processing System

Week 2

Level of Abstraction, Data Models, Database Languages

Dive Deep Into Relational Model

Week 3

DBMS, PC-B, New Class, (09-06-2020)

Entity Relationship (ER) Model

Use LucidChart to implement your 10 Minutes Work

10 Minutes Practice [Click Here]

ER to Schema Mapping

ER to Schema Mapping (Video Lesson)

Week 4

How to convert ER Diagram to Schema Diagram

DBMS, PC-A, New Class, (14-06-2020)

DBMS, PC-A, New Class, (15-06-2020)

DBMS, PC-B, New Class, (14-06-2020)

DBMS, PC-B, New Class, (16-06-2020)

Week 5

Basic SQL

Basic SQL Practice

DBMS, PC-A, New Class, (22-06-2020)

DBMS, PC-B, New Class, (23-06-2020)

Week 6

Like Operator

SQL queries in Database

50 SQl Query Practicer

Subquery Understanding

Discussion about SQL queries

DBMS, PC-A, New Class, (28-06-2020)

DBMS, PC-A, New Class, (29-06-2020)

DBMS, PC-B, New Class, (28-06-2020)

DBMS, PC-B, New Class, (30-06-2020)

Mid Term Week (Week 7)

Online Exam Response Submission Template

Online Exam Guideline

Week 8

More on Subqueries

Join Operation

Database Normalization

Database Normalization (Video Contents)

Queries on Week 8

Week 9

Week 10

Stored Procedurer and Views

Introduction to PL/SQL

PL/SQL Example and Stored Procedure

Trigger, Rollback, Savepoint etc

Week 11 (Final Examination)

Exam Guidelines

Answer Script Template

Final Exam Question

Week 12

Week 13

Week 14

10. Week 8

This file provides more detailed information on Subqueries. Download this ppt file and have a look

Download the ppt file for Join Operation LectureAlso see the video provided here (MUST SEE) to have a better understanding watch

Download all 3 files. PPT file will contain the description of normalization. Other files will provide examples. https://drive.google.com/file/d/1tD-IfEVaiYuBEPJS95SCHANFeEYM0W5I/view?usp=sharinghttps://drive.google.com/file/d/1-WNPOAM07sBQXkT1aQHp1e5yDRkr7ffb/view?usp=sharing

See the following videos for better understanding on Database Normalization

DBMS, PC-B, New Class, (19-06-2020)

DBMS, PC-A, New Class, (19-06-2020)

General

Course Summary and Objectives

Course Introduction

Week 1

Week 2

Week 3

Download the ppt file for Join Operation Lecture
Also see the video provided here (MUST SEE) to have a better understanding

Download all 3 files. PPT file will contain the description of normalization. Other files will provide examples.
https://drive.google.com/file/d/1tD-IfEVaiYuBEPJS95SCHANFeEYM0W5I/view?usp=sharing
https://drive.google.com/file/d/1-WNPOAM07sBQXkT1aQHp1e5yDRkr7ffb/view?usp=sharing