Table 4a and Table 4b represents the data dictionary and existing data for Table Client and Table Viewing Table 4a : Data Dictionary Client & Client Existing Data Column Name Data Type and Size CLIENTNO FLAME LANE TELNO PREFT DE MAURENT CLIENTNO VARCHAR2(10) FNAME VARCHAR2(20) Set 0.84.185 LNAME VARCHAR2(20) GHS3209 TELNO VARCHAR2(20) PREFTYPE Treges 0234-020 VARCHAR2(10) MAXRENT NUMBER(10,0) 000 COMMENTS Table 4b : Data Dictionary Viewing & Viewing Existing Data Column Name Data Type and Size CENTRO PROPERTY VIEWS CLIENTNO VARCHAR2(10) PROPERTYNO VARCHAR2(10) VIEWDATE DATE COMMENTS VARCHAR2(100) PG Based on the data dictionary and existing data for Table Client and Table Viewing as shown above and including the statement shown in Figure 4a, write a trigger that allows the information to be stored as shown in Figure 4b below: CREATE VIEW Vw ClientViewing AS SELECT clientno, Ename, Iname, telno, preftype, maxrent, email, propertyno, viewdate, comments FROM client INNER JOIN viewing USING (clientno) Figure 4a : Create View statement BEGIN INSERT INTO ww_ClientViewing (CLIENTNO, INAME, LNAME, TELNO, PREFTYPE, MAXRENT, EMAIL, PROPERTYNO, VIEWDATE, COMMENTS) VALUES ('CR26', 'Hidayah', 'Rahmalan','0164420191', 'House', 550, 'hidayahutam.edu.my', 'PA14', '12/12/2020', 'nice master bedroom'); END: Figure 4b : PL/SQL statement for vw_clientViewing Table 4a and Table 4b represents the data dictionary and existing data for Table Client and Table Viewing Table 4a : Data Dictionary Client & Client Existing Data Column Name Data Type and Size CLIENTNO FLAME LANE TELNO PREFT DE MAURENT CLIENTNO VARCHAR2(10) FNAME VARCHAR2(20) Set 0.84.185 LNAME VARCHAR2(20) GHS3209 TELNO VARCHAR2(20) PREFTYPE Treges 0234-020 VARCHAR2(10) MAXRENT NUMBER(10,0) 000 COMMENTS Table 4b : Data Dictionary Viewing & Viewing Existing Data Column Name Data Type and Size CENTRO PROPERTY VIEWS CLIENTNO VARCHAR2(10) PROPERTYNO VARCHAR2(10) VIEWDATE DATE COMMENTS VARCHAR2(100) PG Based on the data dictionary and existing data for Table Client and Table Viewing as shown above and including the statement shown in Figure 4a, write a trigger that allows the information to be stored as shown in Figure 4b below: CREATE VIEW Vw ClientViewing AS SELECT clientno, Ename, Iname, telno, preftype, maxrent, email, propertyno, viewdate, comments FROM client INNER JOIN viewing USING (clientno) Figure 4a : Create View statement BEGIN INSERT INTO ww_ClientViewing (CLIENTNO, INAME, LNAME, TELNO, PREFTYPE, MAXRENT, EMAIL, PROPERTYNO, VIEWDATE, COMMENTS) VALUES ('CR26', 'Hidayah', 'Rahmalan','0164420191', 'House', 550, 'hidayahutam.edu.my', 'PA14', '12/12/2020', 'nice master bedroom'); END: Figure 4b : PL/SQL statement for vw_clientViewing