Lecture 8 of 43Database Design
ER Model to Relational Mapping
Prof. Prof. S. Srinath and Prof. D. Janaki Ram · IISc Bangalore
Credits and licence
- From
- Database Design, IISc Bangalore (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
- Introduction to Database Management System
- Conceptual Designs
- Conceptual Designs
- Relational Model
- Relational Model
- Structured Query Language
- Structured Query Language II
- ER Model to Relational Mapping
- Functional Dependencies and Normal Form
- ER Model to Relational Model Mapping
- Storage Structures
- Indexing Techniques Single Level
- Indexing Techniques Multi-Level
- Constraints and Triggers
- Query Processing and Optimization
- Query Processing and Optimization II
- Query Processing and Optimization - III
- Transaction Processing Concepts
- Transaction Processing and Database Manager
- Foundation for Concurrency Control
- Concurrency Control Part - I
- Concurrency Control Part - 2
- Concurrency Control Part - 3
- Concurrency Control Part - 4
- Distributed Transaction Models
- Basic 2-Phase and 3-phase commit protocol
- Concurrency Control for Distributed Transaction
- Introduction to Transaction Recovery
- Recovery Mechanisms II
- Recovery Mechanisms III
- Introduction to Data Warehousing and OLAP
- Introduction to Data Warehousing and OLAP
- Case Study : MYSQL
- Case Study ORACLE and Microsoft Access
- Data Mining and Knowledge Discovery
- Data Mining and Knowledge Discovery Part II
- Object Oriented Databases
- Object Oriented Databases II
- XML - Introductory Concepts
- XML Advanced Concepts
- XML Databases
- Case Study - Part One Database Design
- Case Study - Part 2 Database Design