Name:Ms. Nabila Kazi

Designation: Asst Prof

Department: BSc IT

Subject: Introduction to Database Management Systems [USIT304]

Class: Second Year Semester: III

• Topic: Introduction to Database System
  Description: Description: This video lecture consists of definition of Data,Database Developer Road Map , What is Frontend and Backend Example of GMAIL account.
  Link: https://youtu.be/UNm30S-F0R0
• Topic: Unit I: Chapter 01 : Introduction to Databases and Transactions:
  Description: The video lecture explains sub topics of Chapter 1: What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management.
  Link:https://youtu.be/WlHLj7EYNvI
• Topic: Unit I: Chapter 02: Data Models
  Description: The video lecture explains sub topics of Chapter 2: The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.
  Link:https://youtu.be/yMwmH7G0Ch8
• Topic: Unit I: Chapter 03: Database Design and Unified Modeling Language
  Description: The video lecture explains sub topics of Chapter 3: Database design& Introduction to UML.
  Link:https://youtu.be/5uVQyqJJKk8
• Topic: Unit II: Chapter 04: Relational Database Model:
  Description: The video lecture explains sub topics of Chapter 04 i.e. Logical view of data, keys, integrity rules, Relational Database design: features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF)
  Link https://youtu.be/UVBLrbugbRY
• Topic: Unit II: Chapter 04: Database Normalization
  Description: The video lecture explains Normalization steps (1NF, 2NF, 3NF, BCNF) in detail with an appropriate example.
  Link https://youtu.be/kC_ROgKOM0g
• Topic: Unit II: Chapter 05: Relational Algebra
  Description: The video lecture explains sub topics of Chapter 05 i.e. introduction, Selection and projection, set operations, renaming, Joins, Division.
  Link https://youtu.be/mVtObsXvblE
• Topic: Unit II: Chapter 06: Relational Calculus
  Description: The video lecture explains sub topics of Chapter 06 i.e. Introduction , Calculus Types: Tuple relational calculus, Domain relational Calculus, Calculus vs Algebra.
  Link https://youtu.be/M5PozD4JpQ8

Faculty Name:Mrs.Raveena Shetty

Designation : Assistant Professor Dept. of Information Technology

Subject : Database Management System

Programme : B.Sc.IT

Class : Second Year Semester III

• Video Lecture 1
  Subject Name : Database Management System
  Topic: Topic-Introduction Part 1
  Description: The video lecture describes about Data, Information, Knowledge and Wisdom.
  Link:https://youtu.be/rRa7H6bam9c
• Video Lecture 2
  Subject Name : Database Management System
  Topic-Introduction Part 2
  Description-The video lecture describes about definition of DBMS,It's various application and purpose of database over file systems.
  Link :https://youtu.be/KFgRmOfUMR8
• Video Lecture 3
  Subject Name : Database Management System
  Topic-Data Abstraction and Relational Table
  Description :The video lecture describes about different level of data abstraction and Basics of Relational table.
  Link : https://youtu.be/8QVdJMzbb48
• Video Lecture 4
  Subject Name : Database Management System
  Topic-Transaction Management,Transaction States and Database Architecture
  Description :The video lecture describes about Atomicity Property in Transaction Management and describes various states of transaction it also describes about 3-tiered architecture of database.
  Link : https://youtu.be/DwnGZoeBKVA
• Video Lecture 5
  Subject Name : Database Management System
  Topic - Data Models,Basic Building Blocks,Evolution of Data Models and Entity Relationship Diagram
  Description :The video lecture describes thebasic building blocks of database , Different types of data models and Entity Relationship model and it also describes about type of entity , attributes and relationship cardinality in database.
  Link : https://youtu.be/UODj7pSUZMY
• Video Lecture 6
  Subject Name : Database Management System
  Topic - Constraints describes constraints and its different types in brief
  Description : The video lecture describes constraints and its different types in brief.
  Link : https://youtu.be/fvm0zuGMu9Y
• Video Lecture 7
  Subject Name : Database Management System
  Topic - Use Case Diagram
  Description : The video lecture describes use case diagram with example
  Link : https://youtu.be/-yw8rAm9EpE
• Video Lecture 8
  Subject Name : Database Management System
  Topic - Sequence Diagram
  Description : The video lecture describes sequence diagram with example
  Link : https://youtu.be/27spfcmoQ7c
• Video Lecture 9
  Subject Name : Database Management System
  Topic - Codd Rule
  Description : The video lecture describes Codd 12 rule in brief
  Link : https://youtu.be/1b0_khO7SAI
• Video Lecture 10
  Subject Name : Database Management System
  Topic - Relational Database Models, Logical View, keys
  Description : The video lecture describes about relational data model and logical view of table in brief and basics of keys in dbms
  Link : https://youtu.be/GYQwLb_HlPA
• Video Lecture 11
  Subject Name : Database Management System
  Topic – Normalize Definition
  Description : The video lecture describes normalization in brief and describes its advantage
  Link : https://youtu.be/TvMnOs6qnjo
• Video Lecture 12
  Subject Name : Database Management System
  Topic - 1NF 2NF
  Description : The video lecture describes the types of normalization in brief
  Link : https://youtu.be/Zgc153v9bE4
• Video Lecture 13
  Subject Name : Database Management System
  Topic – Relational Algebra Calculus unary operation
  Description : The video lecture describes Relational algebra and calculus and unary operation and it's types in brief
  Link : https://youtu.be/GPzk5TjiSjo
• Video Lecture 14
  Subject Name : Database Management System
  Topic – Binary Operators set operators
  Description : The video lecture describes Relational algebra and calculus and binary operation and it's type in brief
  Link : https://youtu.be/apG6keD1GYI