A table ALBUMS of your own similar to the one used so far as

A table ALBUMS of your own (similar to the one used so far) as well as an index table that contains album id and individual words in a title. Be careful not to forget constraints. A user----written function that sanitizes a title, removing punctuation and replacing accented letters with their unaccented equivalent, and finally turning everything to the same case (upper or lower doesn\'t matter). You\'ll probably want to use the translate() PostgreSQL function. In your solution, you can use the following list for accented letters: and the following list for punctuation: A function that will take two parameters, an album id and a title, and will populate the table containing album id and words (after sanitizing the title). Your function will ignore one----letter words. A trigger on your ALBUMS table that uses the preceding functions to automatically index titles when they are inserted or updated (updates will delete and replace words associated with the previous version of the title). (Write 3 INSERT into ALBUMS statements that will help you show that your functions/trigger work as required (by subsequently executing a SELECT * on the index table).

Solution

5) Let albums table be

and index table suppose has two rows indexname index id

now , select * from index; //gives us the table indexes updated