For views that are not automatically updatable, the trigger system can be used to make them updatable. The seller_account_information view, which shows the information about the seller account, is not automatically updatable because it has INNER JOIN:
CREATE OR REPLACE VIEW car_portal_app.seller_account_info AS SELECT account.account_id, first_name, last_name, email, password, seller_account_id, total_rank, number_of_advertisement, street_name, street_number, zip_code , city FROM car_portal_app.account INNER JOIN car_portal_app.seller_account ON (account.account_id = seller_account.account_id);
To verify that the preceding view, seller_account_information, is not updatable, we can check the information schema, ...
