Section: Week 1 | Database Management System Fall2020

Home Guidelines

Course Menu

CSE Fall 20

Rubaiya Hafiz

Section outline

Week 1
- Select activity Introduction To BLC
  
  Students must
  
  Mark as done
  
  Introduction To BLC

General

Announcements

Course Summary and Objectives

Outline

Notice Board

Announcement

Add New Words(with meaning) you are learning in this course

Courses Introduction

Course Introductory Video

Week 1

Week 2

Lecture 1.1: Introduction to Database Management System (Video)

Lecture 1.2: Purpose of DBMS System (Video)

Lecture 1.1: Introduction to Database Management System (Slide)

Lecture 1.2: Purpose of DBMS System (Slide)

Lecture 2.1: Relational Model in DBMS (Video)

Lecture 2.2: Database Architecture (Video)

Lecture 2.1: Relational Model in DBMS (Slide)

Lecture 2.2: Database Architecture (Slide)

Forum Discussion about pros and cons of Conventional File Processing System

Week 3

Lecture 3.1: Data Abstraction (Video)

Lecture 3.2: Relational DBMS -Keys(Video)

Lecture 3.1: Data Abstraction (Slide)

Lecture 3.1: Relational DBMS -Keys(slide)

Lecture 4: ER model (Slide)

Week 4

Lecture 4: ER model (Slide)

Scenario to ERD Conversion Example (Slide)-1

Week 5

Quiz 1 Question Section O-2

Exercise on Scenario to ERD Conversion (Slide)-2

Use LucidChart to implement your work in 10 Minutes

Exercise On ERD model

ERD symbol Learning

ERD symbol Learning

Assignment 1

Assignment 1

Week 6

ERD to Relational Schema Conversion (Slide)

ER to Schema Mapping (PDF)

Assignment 2

Assignment 2

Week 7

Quiz 2

Week 8

Mid Syllabus

Midterm Exam Guideline For students

Sample exam script

Midterm Question CSE311(Day-O2)

Overall Course Design Feedback

Week 9

Transaction Part 1

Transaction Part 1 Video (Download Link)

Transaction Part 1 SQL Video( Download Link)

Transaction Part 2

Week 10

DBMS Normalization (Video Lecture)

Normalization part 1

Normalization Part 2

Normalization Part 3

Normalization exercise

Week 11

Stored Procedure (Video Lecture)

DBMS Trigger (Video Lecture)

Stored Procedure and views

Trigger in Database

Week 12

Week 13

Final Exam Answer Script Template Fall 2020

Final Exam Guideline

Google Form Submission

Section outline

Week 1

Introduction To BLC