Section: Week 2 | Database Management System (Spring 21)

Section outline

- Select activity Level of Abstraction, Data Models, Database Languages
  
  Level of Abstraction, Data Models, Database Languages File
  
  (Class_Lecture_4)
- Select activity Database Architecture
  
  Database Architecture File
  
  Lecture Objectives:
  
  Two Tier Architecture, Three Tier Architecture
- Select activity Types of Keys in Relational Model
  
  Types of Keys in Relational Model File
  
  Lecture Objectives:
  
  Discuss all types of keys in relational DB Model.
  
  (Class_Lecture_5)
- Select activity Entity Relationship (ER) Model
  
  Entity Relationship (ER) Model File
  
  Lecture Objectives:
  
  Entity, Entity Type and Entity Set, Learn how to make ER model using symbol
  
  (Class_Lecture_6)
- Select activity 10 Minutes Practice [Click Here]
  
  10 Minutes Practice [Click Here] URL
- Select activity Use LucidChart to implement your 10 Minutes Work
  
  Use LucidChart to implement your 10 Minutes Work URL
- Select activity Assignment-1 (Draw ER Diagram of your favourite sport team)
  
  Assignment-1 (Draw ER Diagram of your favourite sport team)

General

Announcements

Announcements

Welcome to DBMS Class

Experience with BLC

Join us on TELEGRAM

Course Summary and Objectives

OBE Course outline

Course Introduction

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

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)

Week 3

ER to Schema Mapping

ER to Schema Mapping (Video Lesson)

Assignment-2 (ER to Schema Mapping)

Relational Algebra

Five Minutes Practice

Homework (Relational Algebra)

Quiz-1

Week 4

Basic SQL Queries (P-1)

Assignment-3 (Create Database and Relation)

Week 5

Join Operation in DBMS

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Week 6

SQL queries in Database

Basic SQL Queries (P-2)

Discussion about SQL queries

Week 7

SQL Queries

Numeric Functions, Date &amp; Time Functions File

Quiz-2 (Time:1hour) : Please submit your answer script as ID_Section_Quiz2.pdf by 9.30PM

Week 8

MID TERM EXAM

Week 9

Subqueries in DBMS

Subqueries in DBMS

Week 10

Stored Procedurer and Views

Week 11

Database Normalization

Week 12

Database Transaction

Database Transaction

Quiz-3

Week 13

Trigger in Database

SQL Injection

Submit your assignment on SQL injection and its prevention

Submit your presentation drivelink

Week 14

FINAL EXAM (Please read the instructions first)

Section outline

Lecture Objectives:

Lecture Objectives:

Lecture Objectives:

Numeric Functions, Date & Time Functions File