CSE 311+CSE 311L (FTJ-212): ER Diagram

To operate the Blended Learning Center(BLC) at optimal level, maintenance will be performed every day at 8:30 AM and at 5:00 PM regularly which can take up to 30 minutes. Please consider scheduling your activity in the BLC platform accordingly.

Database Management System Theory and Lab [PC-A : Eve] (Summer-21)

FORUM ON WEEK 4

ER Diagram

◄ ER model & schema
Schema ►

The cut-off date for posting to this forum is reached so you can no longer post to it.

What is ER diagram in DBMS?

◄ ER model & schema
Schema ►

Announcements

Outline

Review on midterm syllabus

FORUM ON WEEK 1

FORUM ON WEEK 2

FORUM ON WEEK 3

FORUM ON WEEK 4

FORUM ON WEEK 7

FORUM on WEEK 8 and 9

Lab evaluation 1

Lab Evaluation 2

Lab Evaluation 3

Lab Evaluation 4

DRAWING ER DIAGRAM

Lecture 1: Introduction to Database

Lecture 2: Relational Model in DBMS (Slide)

Lecture 3: Data Abstraction

Lecture 4 [Part-1] :Database Architecture

Lecture 4 [Part-2] : keys in database

Introduction to Relational Model

Lecture 5 [Scenario to ER Model Drawing]

Lecture 6 [ER model to Relational Schema/Table]

Relational Algebra part 1 for Lab and Theory

Necessary Resources

Class Lecture

week 6

Assignment on Schema

MIDTERM EXAM

Midterm exam expectation

Relational Algebra Part 2 (doc)

Transaction

Stored Procedure and views

Stored Procedure (Video Lecture)

DBMS Trigger (Video Lecture)

Trigger in Database

Presentation

Database Management System Theory and Lab [PC-A : Eve] (Summer-21)

FORUM ON WEEK 4

ER Diagram

ER Diagram

General

Announcements

Course Summary and Objectives

Outline

Notice Board

Review on midterm syllabus

IMPORTANT LINKS

FORUM LINKS (COMPLETED)

FORUM ON WEEK 1

FORUM ON WEEK 2

FORUM ON WEEK 3

FORUM ON WEEK 4

FORUM ON WEEK 7

FORUM on WEEK 8 and 9

QUIZ

Lab Evaluation

Lab evaluation 1

Lab Evaluation 2

Lab Evaluation 3

Lab Evaluation 4

Assignment

DRAWING ER DIAGRAM

Week 1

Lecture 1: Introduction to Database

Lecture 2: Relational Model in DBMS (Slide)

Week 2

Lecture 3: Data Abstraction

Lecture 4 [Part-1] :Database Architecture

Lecture 4 [Part-2] : keys in database

Week 3

Introduction to Relational Model

Lecture 5 [Scenario to ER Model Drawing]

Lecture 6 [ER model to Relational Schema/Table]

Relational Algebra part 1 for Lab and Theory

Week 4

Necessary Resources

Class Lecture

week 5

week 6

week 6

Assignment on Schema

Week 7

MIDTERM EXAM

Midterm exam expectation

Week 8

Relational Algebra Part 2 (doc)

Transaction

Week 9

Week 10

Stored Procedure and views

Stored Procedure (Video Lecture)

DBMS Trigger (Video Lecture)

Trigger in Database

PRESENTATION

Presentation

Week 13

LAB FINAL

FORUM ON WEEK 4

ER Diagram