Update was made to have foreign key constraints on the tables.
Relationships on the tables have been modified also with the an additional
key indexing on foreign keys to optimize search. Development can start
with the current version with testing in place. Decisition on table
trigger still to be discussed