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. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  26. What’s the best way to search for a UPC code in a Database?
  27. What is an MDF file? [closed]
  28. What is the difference between UNION and UNION ALL?
  29. Selecting COUNT(*) with DISTINCT
  30. Case in Select Statement
  31. What is a stored procedure?
  32. SQL WITH clause example [duplicate]
  33. Unknown column in ‘field list’ error on MySQL Update query
  34. Unknown column in ‘field list’ error on MySQL Update query
  35. SQL Inner-join with 3 tables?
  36. The wait operation timed out. ASP
  37. What is SELF JOIN and when would you use it? [duplicate]
  38. The wait operation timed out. ASP
  39. Conversion failed when converting date and/or time from character string while inserting datetime
  40. How do I UPDATE from a SELECT in SQL Server?
  41. how to fix oracle ORA-01722 invalid number error
  42. SQL query to select dates between two dates
  43. MySQL – Operand should contain 1 column(s)
  44. SQL SELECT WHERE field contains words
  45. Conversion failed when converting date and/or time from character string while inserting datetime
  46. When should I use CROSS APPLY over INNER JOIN?
  47. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  48. Insert Data Into Temp Table with Query
  49. MySQL create table if not exists and insert record only if table was created
  50. error, string or binary data would be truncated when trying to insert
  51. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  52. NOT IN vs NOT EXISTS
  53. SQL SELECT WHERE field contains words
  54. Online SQL Query Syntax Checker
  55. How can I do an UPDATE statement with JOIN in SQL Server?
  56. Must declare the scalar variable
  57. ORA-00979 not a group by expression
  58. ORA-00907: missing right parenthesis
  59. How do I use properly CASE..WHEN in MySQL
  60. Must declare the scalar variable
  61. What is “Advanced” SQL?
  62. Rename column SQL Server 2008
  63. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  64. Using group by on multiple columns
  65. Efficiently convert rows to columns in sql server
  66. How can I do a FULL OUTER JOIN in MySQL?
  67. Nested select statement in SQL Server
  68. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  69. Using group by on multiple columns
  70. SQL SELECT WHERE field contains words
  71. MySQL query String contains
  72. How do I escape a single quote in SQL Server?
  73. What’s the difference between VARCHAR and CHAR?
  74. How to update multiple columns in single update statement in DB2
  75. T-SQL split string based on delimiter
  76. How to declare a variable in MySQL?
  77. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  78. Finding duplicate values in a SQL table
  79. ORA-01843 not a valid month- Comparing Dates
  80. MySQL Cannot Add Foreign Key Constraint
  81. How do I restore a dump file from mysqldump?
  82. Drop a temporary table if it exists
  83. How do I escape a single quote in SQL Server?
  84. ORA-00918: column ambiguously defined in SELECT *
  85. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  86. How Stuff and ‘For Xml Path’ work in SQL Server?
  87. IDENTITY_INSERT is set to OFF – How to turn it ON?
  88. Oracle error : ORA-00905: Missing keyword
  89. How to split the name string in mysql?
  90. How to reset AUTO_INCREMENT in MySQL
  91. How do I import an SQL file using the command line in MySQL?
  92. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  93. mysql Foreign key constraint is incorrectly formed error
  94. How do I limit the number of rows returned by an Oracle query after ordering?
  95. Sql Server equivalent of a COUNTIF aggregate function
  96. Oracle SELECT TOP 10 records
  97. MySQL: Invalid use of group function
  98. must appear in the GROUP BY clause or be used in an aggregate function
  99. Column name or number of supplied values does not match table definition
  100. Inserting data into a temporary table

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)