Learn · Data Base Management System
Lecture 20 of 40Week 4
Lecture 20 : Relational Database Design (Contd.)
Prof. Partha Pratim Das and Prof. Samiran Chattopadhyay · IIT Kharagpur
Credits and licence
- From
- Data Base Management System, IIT Kharagpur (at NPTEL)
- Licence
- CC BY-NC-SA, as NPTEL states it. Non-commercial use only.
- Attribution
- NPTEL states: "Distributed under Creative Commons Attribution-ShareAlike / CC BY - NC - SA", beside a BY-NC-SA badge.
- Who can watch
- Tweens profiles and older. How courses are placed
All the lectures
- Lecture 1 : Course Overview
- Lecture 2 : Introduction to DBMS/1
- Lecture 3 : Introduction to DBMS/2
- Lecture 4 : Introduction to Relational Model/1
- Lecture 5 : Introduction to Relational Model/2
- Lecture 6 : Introduction to SQL/1
- Lecture 7 : Introduction to SQL/2
- Lecture 8 : Introduction to SQL/3
- Lecture 9 : Intermediate SQL/1
- Lecture 10 : Intermediate SQL/2
- Lecture 11 : Advanced SQL
- Lecture 12 : Formal Relational Query Languages
- Lecture 13 : Entity-Relationship Model/1
- Lecture 14 : Entity-Relationship Model/2
- Lecture 15 : Entity-Relationship Model/3
- Lecture 16 : Relational Database Design
- Lecture 17 : Relational Database Design (Contd.)
- Lecture 18 : Relational Database Design (Contd.)
- Lecture 19 : Relational Database Design (Contd.)
- Lecture 20 : Relational Database Design (Contd.)
- Lecture 21 : Application Design and Development
- Lecture 22 : Application Design and Development (contd.)
- Lecture 23 : Application Design and Development (contd.)
- Lecture 24 : Storage and File Structure : Storage
- Lecture 25 : Storage and File Structure : File Structure
- Lecture 26: Indexing and Hashing/1 : Indexing/1
- Lecture 27: Indexing and Hashing/2 : Indexing/2
- Lecture 28: Indexing and Hashing/3 : Indexing/3
- Lecture 29: Indexing and Hashing/4 : Hashing
- Lecture 30: Indexing and Hashing/5 : Index Design
- Lecture 31: Transactions/1 : Serializability
- Lecture 32: Transactions/2 : Serializability
- Lecture 33: Transactions/3 : Recoverability
- Lecture 34: Concurrency Control/1
- Lecture 35: Concurrency Control/2
- Lecture 36 : Recovery/1
- Lecture 37 : Recovery/2
- Lecture 38 : Query Processing and Optimization/1 : Processing
- Lecture 39 : Query Processing and Optimization/2 : Optimization
- Lecture 40 : Course Summarization