QUESTION 8 (10 MARKS) Below are the data dictionary and data for table student and lecturer. Table Name: student Nam Rull NOT NULL STUDENTID NAME PROGRAM ADDRESS PHONCINO EMAIL YEAR LECTURERID VARCHAR220) VARCHAR2(20) IVARCHAR2(20) IVARCHAR2(30) VARCHAR(203 VARCHARD/80). NUMBEROS VARCHARZ:20] Data for table student STUDENTIURNAMEBOGRAM BALORESSANPHONE NO EMAILOVER LECTURERIE SU BITD PERAK 019-5678543gmail.com L01 mah BITD KEDAK 019-58745700 atimah@gmail.com L01 Ahmad KELANTAN 10146 Ahmad omall.com 3L01 Daud BITD PERAK 019-3458540 Daud gmal.com 3.02 Salmah BITD PERAK 019-3150540 Salmah@gmail.com 3.02 Hamizah BITD PERAK 019-4567546 Hamizah@email.com 3101 Hanio BITD PERAK 019-3908740 Fanta damai.com 3101 INOT NULL Table Name: lecturer Name LECTURERID NAME ADDRESS PHONENO EMAIL TOTAL STD VARCHAR2120) VARCHARZIZO) VARCHAR2(20) IVARCHAR2(20) VARCHAR2(20) VARCHAR2(20) RES Data for table lecturer ERE GATHERION NAME ADRESSE D DL NENO L01 Saldnan PERAK 019-5678540 LOZ Farid PERAK 019-6785546 1761 Sakinah@gmail.com Faridgmail.com Based on the table student and lecturer, you are required to write the appropriate source code using PL/SQL programming language so that the number of students assigned to a lecturer can be limited to EIGHT (8)