Courses
Database Management Systems
Course material for an undergraduate database course: unit-wise lessons and handbook
AI generated by Nikhil Kumar Rajput
27 chapters
Contents¶
Front matter
Chapters
Lesson 8: ER Notation, Weak Entities and Case Studies
- 8.1 The Complete Chen Notation
- 8.2 A Seven-Step Design Procedure
- 8.3 Case Study 1 — The College Database (our running example)
- 8.4 Case Study 2 — The COMPANY Database (the textbook standard)
- 8.5 Case Study 3 — A Hospital Database (with a weak entity)
- 8.6 Design Traps
- 8.7 A Glimpse of the EER Model
- 8.8 Solved Questions
- 8.9 Exercises
Lesson 23: Lossless Join and Dependency Preservation
About this book¶
Complete teaching and learning material for the Database Management Systems course: purpose and architecture of database systems, ER modelling, the relational model and relational algebra, SQL, normalisation, file organisation and indexing, transactions and concurrency.