Section: Topic 4 | Database Management System Theory & Lab (Fall 2024)

Section outline

Lesson 1
Learning Objectives:
Database Introduction, Database History, Flat File Database, Data and Information, Database Application
Problems in Conventional File Processing System, Difficulty in accessing data, Integrity problems, Atomicity problems, Security problems

Introduction to Database Management System
PDF(2.1MB) Purpose of Database System
- Select activity L1:Assessment your Leaning: What have I Learned?
  
  L1:Assessment your Leaning: What have I Learned? Quiz
  
  Students must
  
  View
  
  Receive a grade
- Select activity Click here for Feedback 
  
  Click here for Feedback
- Select activity Lesson 2Learning Objectives: Relational M...
  
  Lesson 2
  Learning Objectives:
  
  Relational Model in DBMS File;
- Select activity Relational_Model
  
  Relational_Model File
- Select activity L2:Assessment your Leaning: What have I Learned about Relational Model?
  
  L2:Assessment your Leaning: What have I Learned about Relational Model? Quiz
  
  Opened: Saturday, 4 January 2025, 2:35 PM
  
  Students must
  
  View
  
  Receive a grade
- Select activity Forum Discussion : Career on Database Management System
  
  Forum Discussion : Career on Database Management System
  
  Students must
  
  View
  
  Make forum posts: 1
- Select activity Click here for Feedback  (copy)
  
  Click here for Feedback
- Select activity Class Feedback
  
  Class Feedback Assignment
  
  Opened: Tuesday, 27 August 2024, 2:00 PM
  
  Due: Tuesday, 27 August 2024, 5:00 PM
  
  Not available unless: You belong to 61_L
- Select activity ER NotationData Isolation Property in DBMS with Ex...
  
  ER Notation
  Data Isolation Property in DBMS with Example

Welcome Database Management System

Announcements

Course Summary and Objectives

OBE Course outline

Course Slides (MID)

Course Slides(Final)

Database Security

NoSQL(Extra)

Topic 2

Topic 3

Topic 4

L1:Assessment your Leaning: What have I Learned?

Relational_Model

L2:Assessment your Leaning: What have I Learned about Relational Model?

Forum Discussion : Career on Database Management System

Topic 5

Quiz: Assessment of learning On level of Abstraction and Architecture of Database

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

ER Diagram week 2 (Slide 2)

Topic 6

Lecture Content: ER to Schema Mapping (Video Lesson)

Lecture Content: ER to Schema Mapping (Video Lesson) (copy)

Five Minutes Practice

Topic 7

Lecture Content: Basic SQL Queries (P-1)

Assessment of Leaning : What have I learned

Ask any question about sql operation

natural join vs inner join

Natural Join

Topic 8

Database SQL: Sub Queries Question

Mid term Week

Week 8

Database Transaction

Database Transaction part 1

Database Transaction part 2

Week Nine(9)

Topic 12

Week 8

Subqueries in DBMS

Week 10

Week 13

Trigger in Database

Week 14

Demo quiz

Topic 17

Assignment (61-K)

Assignment (61_L)

Assignment file dbms

Lab Week 1

Tool Installation

SQL Data Type

Lab Week 2

DDL(TFS)

Lab 2

Lab Week 3

DML 1

DML 2

Lab 3

Topic 23

Aggregate Function

Topic 24

Join Doc 1

Join DOC 2

Join Lab Task

Topic 25

Data of Slide 6

Topic 27

Stored Procedure File

Trigger File

Practice Stored Procedure

Topic 28

View Practice Doc

Trigger-2

Trigger-1

Topic 29

Lab Report Format

Project Report Format

Topic 30