As it's obvious,
joomla doesn't use relation views and foreign keys. It seems that everything is handling in the application level (not in the database).
For example, a reference value can be deleted , and still the foreign key can exists! It violates the databases rules. Isn't it?