DIU-BLC
Database Management System Fall 2020
0%
Previous
Basic SQL
General
Announcements
Welcome to DBMS Class
Social forum
Course Summary and Objectives
OBE Course outline
Course Introduction
Welcome to the course!
Week 1
Introduction to Database Management System
Purpose of Database System
What have I Learned
Relational Model in DBMS
Forum Discussion about pros and cons of Conventional File Processing System
Week 2
Level of Abstraction, Data Models, Database Languages
Dive Deep Into Relational Model
Simple Quiz on RDBMS for PC-A (01-06-2020)
Simple Quiz on RDBMS for PC-B (02-06-2020)
Week 3
Entity Relationship (ER) Model
Use LucidChart to implement your 10 Minutes Work
10 Minutes Practice [Click Here]
ER to Schema Mapping
ER to Schema Mapping (Video Lesson)
Week 4
How to convert ER Diagram to Schema Diagram
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-A
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-B
Week 5
Basic SQL
Basic SQL Practice
Week 6
Mid Term Week (Week 7)
Week 8
Week 9
Week 10
Week 11 (Final Examination)
Week 12
Week 13
Week 14
Next
DIU-BLC
Side panel
Guidelines
For Teachers
For Students
Search
Close
Search
Toggle search input
Log in
Username
Password
Remember username
Forgot Password?
Log in
Create new account
Course Overview
Sections
General
1
Announcements
Forum
Welcome to DBMS Class
Forum
Social forum
Course Summary and Objectives
2
OBE Course outline
File
Course Introduction
3
Welcome to the course!
File
Week 1
4
Introduction to Database Management System
File
Purpose of Database System
File
What have I Learned
Quiz
Relational Model in DBMS
File
Forum Discussion about pros and cons of Conventional File Processing System
Week 2
5
Level of Abstraction, Data Models, Database Languages
File
Dive Deep Into Relational Model
File
Simple Quiz on RDBMS for PC-A (01-06-2020)
Simple Quiz on RDBMS for PC-B (02-06-2020)
Week 3
6
Entity Relationship (ER) Model
File
Use LucidChart to implement your 10 Minutes Work
URL
10 Minutes Practice [Click Here]
URL
ER to Schema Mapping
File
ER to Schema Mapping (Video Lesson)
URL
Week 4
7
How to convert ER Diagram to Schema Diagram
Lesson
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-A
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-B
Week 5
8
Basic SQL
File
Basic SQL Practice
URL
Skip to main content
Database Management System Fall 2020
Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Fall 20
CSE311SMP
Week 5
Basic SQL
Basic SQL
Mark as done
Basic SQL
Download the attached file for this lesson.
Here we will learn all the basic and intermediates of SQL. Also check the lab files
Also a video is embedded for better understanding the CRUD operation
watch
Click
3.2 SQL_1.ppt
link to view the file.
Previous Activity
Jump to...
Jump to...
Announcements
Welcome to DBMS Class
Social forum
OBE Course outline
Welcome to the course!
Introduction to Database Management System
Purpose of Database System
What have I Learned
Relational Model in DBMS
Forum Discussion about pros and cons of Conventional File Processing System
Level of Abstraction, Data Models, Database Languages
Dive Deep Into Relational Model
Simple Quiz on RDBMS for PC-A (01-06-2020)
Simple Quiz on RDBMS for PC-B (02-06-2020)
Entity Relationship (ER) Model
Use LucidChart to implement your 10 Minutes Work
10 Minutes Practice [Click Here]
ER to Schema Mapping
ER to Schema Mapping (Video Lesson)
How to convert ER Diagram to Schema Diagram
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-A
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-B
Basic SQL Practice
Next Activity