Section: Week 3 | Database Management System Theory and Lab SSH(Fall-2020)

ER to Schema Mapping File

Er to schema mapping File

ERD File

ERD_exercise_1 File

ERD_exercise_2 File

ERD_exercise_3 File

ER to Schema Mapping (Video Lesson) URL

Class: 12-10-2020 (PC-A) URL

Class: 12-10-2020 (PC-B) URL

Feedback (12-10-2020) (PC-A & PC-B) Choice

Today's Class was:

Class (17-10-2020) (PC-A) URL

Feedback (17-10-2020) (PC-A & PC-B) Choice

Today's Class was:

Review Assignment (class: 17-10-2020) (PC-A & PC-B)

ERD to Relational Schema Mapping

Discussion about ERD to relational schema mapping Forum

Class (17-10-2020) PC-B URL

Relational Algebra File

Lecture Objectives:

Selection Operator, Projection Operator, Cartesian Product

Expected outcome

Able to learn mapping with different relations in Database and mathematical structure (Relational Algebra) of relations.

Five Minutes Practice File

Discussion (Relational Algebra) Forum

Feedback (19-10-2020) (PC-A & PC-B) Choice

Today's Class was:

Class (19-10-2020) (PC-A) URL

Class (19-10-2020) (PC-B) URL

Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B) Choice

Lab Class-3 (19-10-2020) (PC-B) URL

Lab Performance-3 Assignment

Not available unless: You belong to PC-B

Lab Performance-3 (PC-A) Assignment

Not available unless: You belong to PC-A

Lab Class-3 (PC-A) (20-10-2020) URL

General

Announcements

Welcome to DBMS Class

Course Summary and Objectives

OBE Course outline

Lab Docs

DBMS Project List

Week 1

Introduction to Database Management System

Purpose of Database System

Relational Model in DBMS

What have I Learned

Forum Discussion about pros and cons of Conventional File Processing System

Class (03/10/2020) (PC-A)

Class (03/10/2020) (PC-B)

LAB-1 (06/10/2020)

Feedback (Lab-1 (06-10-2020))

Discussion about Lab-1

Lab Class-1 (06-10-2020)

Week 2

Level of Abstraction, Data Models, Database Languages

Database Architecture

Types of Keys in Relational Model

Entity Relationship (ER) Model

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

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

Feedback (05-10-2020)

Class (05-10-2020) PC-A

Lab-2 (12-10-2020) (PC-B)

Feedback (Lab-2) (PC-A &amp; PC-B)

Lab-2 (PC-A)

Quiz-1

Week 3

ER to Schema Mapping

Er to schema mapping

ERD

ERD_exercise_1

ERD_exercise_2

ERD_exercise_3

ER to Schema Mapping (Video Lesson)

Class: 12-10-2020 (PC-A)

Class: 12-10-2020 (PC-B)

Feedback (12-10-2020) (PC-A &amp; PC-B)

Class (17-10-2020) (PC-A)

Feedback (17-10-2020) (PC-A &amp; PC-B)

Review Assignment (class: 17-10-2020) (PC-A &amp; PC-B)

Discussion about ERD to relational schema mapping

Class (17-10-2020) PC-B

Relational Algebra

Five Minutes Practice

Discussion (Relational Algebra)

Feedback (19-10-2020) (PC-A &amp; PC-B)

Class (19-10-2020) (PC-A)

Class (19-10-2020) (PC-B)

Feedback-Class (19-10-2020) Lab-3 (PC-A &amp; PC-B)

Lab Class-3 (19-10-2020) (PC-B)

Lab Class-3 (PC-A) (20-10-2020)

Week 4

Basic SQL Queries (P-1)

Feedback (27-10-2020) (PC-A &amp; PC-B) (Basic SQL Queries-1)

Discussion

Class (27-10-2020) (SQL-1)

Week 5

Class: 12-10-2020 (PC-A)

Join Operation in DBMS

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Feedback (27-10-2020) (PC-A &amp; PC-B) (SQL Join operation)

Class (27-10-2020) (SQL-2)

Week 6

SQL queries in Database

Basic SQL Queries (P-2)

Discussion about SQL queries

Feedback (27-10-2020) (PC-A &amp; PC-B) (Basic SQL Queries-2)

Class (27-10-2020) (SQL-3)

Week 7

SQL Queries

Numeric Functions, Date &amp; Time Functions File

Feedback (Lab-2) (PC-A & PC-B)

Feedback (12-10-2020) (PC-A & PC-B)

Feedback (17-10-2020) (PC-A & PC-B)

Review Assignment (class: 17-10-2020) (PC-A & PC-B)

Feedback (19-10-2020) (PC-A & PC-B)

Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B)

Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1)

Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation)

Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2)

Numeric Functions, Date & Time Functions File

Feedback (stored procedure) (pc-a & pc-b)

Feedback (normalization) (pc-a & pc-b)

Feedback (LAB-23-11-2020) (pc-a & pc-b)

Feedback (28-11-2020) (PC-A & PC-B)