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

Section outline

- Select activity Lesson 3Learning Objectives: Data Models,...
  
  Lesson 3
  Learning Objectives:
  
  Data Models, Schemes & Instances,
  
  DBMS Vs RDBMS, ACID Properties.
  
  Two Tier Architecture, Three Tier Architecture
  
  Lecture Content: Level of Abstraction, Data Models, Database Languages
  
  Lecture Content: Database Architecture
  
  Video Lecture
- Select activity Quiz: Assessment of learning On level of Abstraction and Architecture of Database
  
  Quiz: Assessment of learning On level of Abstraction and Architecture of Database
  
  Opened: Wednesday, 8 January 2025, 1:06 AM
  
  Students must
  
  View
  
  Receive a grade
- Select activity Lesson 4Learning Objectives: Di...
  
  Lesson 4
  Learning Objectives:
  
  Discuss all types of keys in relational DB Model, Design, Entities, attributes and Entity sets, Relationships and Types of Attributes
  
  Lecture Content
  
  Lecture Content: Types of Keys in Relational ModelFile
  
  Lecture Content: Entity Relationship (ER) ModelFile
- 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 Click here for Feedback  (copy) (copy) (copy)
  
  Click here for Feedback
- Select activity ER Diagram week 2 (Slide 2)
  
  ER Diagram week 2 (Slide 2) File

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