Meaning of “n:m” and “1:n” in database design

by

m:n is used to denote a many-to-many relationship (m objects on the other side related to n on the other) while 1:n refers to a one-to-many relationship (1 object on the other side related to n on the other).

More Related Contents:

  1. MySQL InnoDB foreign key between different databases
  2. MySQL foreign key to allow NULL?
  3. Foreign key constraints: When to use ON UPDATE and ON DELETE
  4. How to find all the relations between all mysql tables?
  5. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  6. 1052: Column ‘id’ in field list is ambiguous
  7. How to do a batch insert in MySQL
  8. Count the occurrences of DISTINCT values
  9. Codeigniter – multiple database connections
  10. JOIN queries vs multiple queries
  11. Is the primary key automatically indexed in MySQL?
  12. Can a foreign key reference a non-unique index?
  13. Storing Data in MySQL as JSON
  14. MySql Error 150 – Foreign keys
  15. MySql: MyISAM vs. Inno DB! [closed]
  16. MySQL: Cloning a MySQL database on the same MySql instance
  17. DOs and DONTs for Indexes [closed]
  18. How to change the default port of mysql from 3306 to 3360
  19. Is it possible to reference one column as multiple foreign keys?
  20. How to insert values in table with foreign key using MySQL?
  21. How to set a MySQL row to READ-ONLY?
  22. MySQL: LAST_INSERT_ID() returns 0
  23. mySQL – Create a New Table Using Data and Columns from Three Tables
  24. Case Sensitive collation in MySQL
  25. How to use django models with foreign keys in different DBs?
  26. Can’t import database through phpmyadmin file size too large
  27. What is the best way to do incremental backups in MySQL?
  28. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  29. How to Get True Size of MySQL Database?
  30. MySQL: Computed Column

Leave a Comment