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

Section outline

- Select activity Assignment-1 (ER to Schema Mapping) (PC-A)
  
  Assignment-1 (ER to Schema Mapping) (PC-A)
  
  Not available unless: You belong to PC-A
- Select activity Assignment-2 (RA) (PC-A)
  
  Assignment-2 (RA) (PC-A)
  
  Not available unless: You belong to PC-A
- Select activity Assignment-1 (ER to Schema Mapping) (PC-B)
  
  Assignment-1 (ER to Schema Mapping) (PC-B)
  
  Not available unless: You belong to PC-B
- Select activity Assignment-2 (RA) (PC-B)
  
  Assignment-2 (RA) (PC-B)
  
  Not available unless: You belong to PC-B

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)