How to do Inheritance Modeling in Relational Databases?

by

Martin Fowler discusses this extensively in his book Patterns of Enterprise Application Architecture book. Get this book and look into:

  1. Single Table Inheritance

Blockquote

  1. Class Table Inheritance

enter image description here

  1. Concrete Table Inheritance

Blockquote

The Website should give you some idea. You might also want to read the section on inheritance mappers. Each of the different approaches have their pros and cons so choose wisely.

More Related Contents:

  1. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Binary Data in MySQL [closed]
  4. Using an Alias in SQL Calculations
  5. Can a table field contain a hyphen?
  6. Adding a leading zero to some values in column in MySQL
  7. Auto Generate Database Diagram MySQL [closed]
  8. View’s SELECT contains a subquery in the FROM clause
  9. MySQL : Multiple row as comma separated single row
  10. How to design a multi tenant mysql database
  11. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  12. Case statement in MySQL
  13. SQL Order By Count
  14. Export a MySQL Database to SQLite Database
  15. What resources exist for Database performance-tuning? [closed]
  16. How to find out the MySQL root password
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. How to display open transactions in MySQL
  19. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  20. MySQL query, MAX() + GROUP BY
  21. How to get multiple records against one record based on relation?
  22. Easiest way to copy a table from one database to another?
  23. What is the best way to store media files on a database?
  24. How to use a user variables in MySQL LIKE clause?
  25. remove all numeric characters from column mysql
  26. WooCommerce: Finding the products in database
  27. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  28. Create a new database with MySQL Workbench
  29. Optimistic locking in MySQL
  30. How to search and replace all instances of a string within a database?

Leave a Comment