Tagged Questions
1
vote
3answers
78 views
Need suggestion for placing foreign keys in the databases
I have the database for customers. The customers table is something like this
+------------------+
| Customers |
+------------------+
| id (PK) |
| business_email |
| business_name ...
9
votes
3answers
178 views
Are there any database engines which will intuit the join condition based on the existing foreign keys?
It seems strange to me that, when I've defined a foreign key, the engine cannot use this information to automatically figure out the correct JOIN expressions, but instead requires me to re-type the ...
