If there were no foreign keys/triggers or something like that (please provide more info about that), the inserts would look like this:
insert into language (languageID, language) values (1, 'german')
insert into language (languageID, language) values (2, 'english')
insert into word (id, language, text) values (1, 2, 'lucky')
insert into word (id, language, text) values (2, 2, 'happy')
insert into word (id, language, text) values (3, 1, 'glücklich')
insert into translation (word1_id, word2_id) values (1, 3)
insert into translation (word1_id, word2_id) values (2, 3)
1
solved how would look a sql insert for this database tables? [closed]