Section: Week 5 | Database Management System (Fall 20)

Section outline

- Select activity Lecture Objectives: Inner Join Out...
  
  Lecture Objectives:
  
  Inner Join
  
  Outer Join
  Join Operation using SQL
- Select activity Expected outcomeAble to learn the  basic Join...
  
  Expected outcome
  Able to learn the basic Join operation with SQL query.
- Select activity Lecture Slide-12
  
  Lecture Slide-12 URL
- Select activity Class Lecture-12
  
  Class Lecture-12 URL
  
  Students must
  
  Mark as done
- Select activity Extra Resource- Join Operation Example
  
  Extra Resource- Join Operation Example URL
- Select activity Discussion Forum
  
  Discussion Forum
  
  Students must
  
  Mark as done

General

OBE Course outline

Lecture Slide-16

Students Interest Feedback

Attendance

Week 1

Lecture Slide-1

Lecture Slide-2

Lecture Slide-3

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

Lecture Slide- 4

Lecture Slide- 5

Lecture Slide- 6

Lecture Slide- 7

Class Discussion Lecture-4

Class Discussion Lecture-5

Class Discussion Lecture-6

Class Discussion Lecture-7 (part-1)

Class Discussion Lecture-7 (part-2)

Assignment-1 ( ER Diagram Drawing)

ER Diagram Example

Discussion Forum

Week 3

Lecture Slide-8

Lecture Slide-9

Scenario to ER Diagram

Class Lecture-8 ( ERD to Schema)

ER to Schema Mapping (Video Lesson)

Lecture Slide-10

Class lecture-10

Class lecture-10- (Part-1)

Class lecture-10- (Part-2)

Assignment-2 (ER to Schema Mapping)

Homework (Relational Algebra)

Week3 Discussion Forum

Quiz-1

Quiz-1 for Section-O2

Week 4

Lecture Slide-11

Class Lecture-11

Week-4-Assignment (Create Database and Relation)

Discussion Forum

Week 5

Lecture Slide-12

Class Lecture-12

Extra Resource- Join Operation Example

Discussion Forum

Week 6 (Basic SQL Queries)

Lecture Slide-13

Class Lecture-13

SQL queries in Database

Discussion Forum Week-6

Week 7

Lecture Slide-14

Class Lecture- 14

Numeric Functions, Date &amp; Time Functions File

Week-7 Discussion Forum

Quiz-02

Quiz-2 Eve Section O2

Midterm Week (Week 8)

Mid Term Examination Fall-2020 (O-2) Assignment

Online Exam Response Submission Template Fall-2020 (Answer Script)

[Google Form] Mid Exam Answer Script Submission for O-2 Section

Week 8 (Nested Queries)

Lecture Slide-15

Lecture Slide-16

Class Lecture 15 &amp; 16

Week-8 Feedback Assignment

Week-8 Discussion Forum

Week 9 (Stored Procedure and Normalization)

Lecture Slide-17

Class Lecture-17

Lecture Slide-18

Extra Resource: Normalization

Class Lecture- 18

Numeric Functions, Date & Time Functions File

Class Lecture 15 & 16