Why do we need “Relationships” between tables at all?

I think the main reason is for data integrity. If you have a relationship between two tables invoice and invoice_item. You won’t be able to add an invoice item that does not related to an invoice. This is what you want!

It’s called referential integrity. It can get pretty messy in your database if you don’t have foreign keys because you could delete and corrupt your data easily.

e.g. You could delete invoice and not it’s corresponding invoice items. This is considered bad.

I think this gives you something to go on.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  3. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  4. ORA-00904: invalid identifier
  5. Self Join to get employee manager name
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. Case statement in MySQL
  8. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  9. What is the difference between JOIN and UNION?
  10. Error Code: 2013. Lost connection to MySQL server during query
  11. how to drop partition without dropping data in MySQL?
  12. How to SUM two fields within an SQL query
  13. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  14. What is it exactly a BLOB in a DBMS context
  15. The backend version is not supported to design database diagrams or tables
  16. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  17. “You tried to execute a query that does not include the specified aggregate function”
  18. Postgres Error: More than one row returned by a subquery used as an expression
  19. How do I reset a sequence in Oracle?
  20. MySQL equivalent of DECODE function in Oracle
  21. what is the difference between triggers, assertions and checks (in database)
  22. Solutions for INSERT OR UPDATE on SQL Server
  23. How do I count unique items in field in Access query?
  24. “select * into table” Will it work for inserting data into existing table
  25. SQL WITH clause example [duplicate]
  26. The wait operation timed out. ASP
  27. SQL query to select dates between two dates
  28. Must declare the scalar variable
  29. How can I do a FULL OUTER JOIN in MySQL?
  30. How do I escape a single quote in SQL Server?
  31. How to update multiple columns in single update statement in DB2
  32. T-SQL split string based on delimiter
  33. Finding duplicate values in a SQL table
  34. MySQL Cannot Add Foreign Key Constraint
  35. How do I restore a dump file from mysqldump?
  36. Oracle error : ORA-00905: Missing keyword
  37. How do I import an SQL file using the command line in MySQL?
  38. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  39. Difference between JOIN and INNER JOIN
  40. MySQL Multiple Joins in one query?
  41. “CASE” statement within “WHERE” clause in SQL Server 2008
  42. ORA-00972 identifier is too long alias column name
  43. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  44. Combining “LIKE” and “IN” for SQL Server
  45. 1052: Column ‘id’ in field list is ambiguous
  46. 1052: Column ‘id’ in field list is ambiguous
  47. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  48. SQL Server WITH statement
  49. Oracle “Partition By” Keyword
  50. What is the equivalent of ‘describe table’ in SQL Server?
  51. Add a column with a default value to an existing table in SQL Server
  52. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  53. Using group by on multiple columns
  54. How do you force mysql LIKE to be case sensitive?
  55. What is the difference between a stored procedure and a view?
  56. Bulk load data conversion error (truncation)
  57. How to order by with union in SQL?
  58. PostgreSQL create table if not exists
  59. DATEDIFF function in Oracle
  60. How to do a batch insert in MySQL
  61. GROUP BY and COUNT using ActiveRecord
  62. MySQL – Get row number on select
  63. How to truncate the text returned for a column in a MySQL query
  64. Display data from a non wordpress database on a page template
  65. How to auto login user again after change user_login
  66. Bulk Update of Custom Post Type Post Status through SQL
  67. How do I add indexes to WordPress Database?
  68. How To Write An Inner Join With WP Query
  69. Block search SQL from happening
  70. Update user_login, user_nicename, and display_name
  71. Change sticky status of posts from phpMyAdmin
  72. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  73. Transferring working local PHP site to wordpress – with database (MySQL)
  74. Create table from array with prepare
  75. How to import a Typo3 database to a wordpress site?
  76. Does deleting a Plugin via the WordPress admin ‘completely’ remove the code?
  77. Is it possible to query from external database? [duplicate]
  78. Is it possible to have more than 1 MySQL database in my WordPress blog?
  79. Using AND and bracket grouping in SQL not working
  80. How to Assign / Move all Deleted post to a category
  81. Delete/Replace words from X to Y in post content
  82. How to delete a particular row in a database table
  83. Clean up very big and very dirty database
  84. Getting value from database table depending on field value
  85. How can I convert everything from category X to have post format Link
  86. custom tables in wordpress Database? (can i just create them with sql?)
  87. Bulk delete WordPress Post and all metadata, etc using SQL query
  88. Accidently changed the GUID
  89. Translating WP query into to SQL query
  90. Reset post IDs with all post meta
  91. Help posting values to DB on submit using $wpdb->query
  92. Alter the cost of products using phpmyadmin sql query
  93. How to Add or Change Post Title
  94. Why does DROP TABLE-ing the `wp_options` reset my user session?
  95. How to create index (sql) to a meta_key?
  96. How to refactor DB queries for better TTFB in WordPress?
  97. query sql-table and change entities
  98. Backtick (MySQL norm) added to SQL Server Query causing error
  99. $wpdb not working
  100. Deleting the MySQL database

Leave a Comment