CREAT TABLE STUDENT ( STUID NUMBER(6) PRIMARY KEY,NAME VARCHAR2(40),CLASS VARCHAR2(30), MOB NUMBER(14)); CREATE TABLE ABSENT ( ABDATE DATE PRIMARY KEY); CREATE TABLE ABSENT1 ( ABDATE DATE REFERENCES ABSENT(ABDATE),ASTUID NUMBER(6) REFERENCES STUDENT(STUID), AREM VARCHAR2(20)); INSERT INTO STUDENT VALUES (1,'Abc',PREP',923334882088); INSERT INTO STUDENT VALUES (2,'Def',PREP',923334882088); INSERT INTO STUDENT VALUES (3,'Ghi',PREP',923334882088); INSERT INTO STUDENT VALUES (4,'Ijk','TWO',923334882088); INSERT INTO STUDENT VALUES (5,'Lmn',PREP',923334882088); INSERT INTO STUDENT VALUES (6,'Opq',PREP',923334882088); INSERT INTO STUDENT VALUES (7,'Rst','TWO',923334882088); Insert into absent values ('01-APR-2018'); Insert into absent values ('03-APR-2018'); Insert into absent values ('05-APR-2018'); Insert into absent values ('06-APR-2018'); Insert into absent values ('07-APR-2018'); Insert into absent values ('08-APR-2018'); Insert into absent1 values ('01-APR-2018',1,'P'); Insert into absent1 values ('01-APR-2018',2,'P'); Insert into absent1 values ('01-APR-2018',3,'P'); Insert into absent1 values ('01-APR-2018',4,'A'); Insert into absent1 values ('01-APR-2018',5,'P'); Insert into absent1 values ('01-APR-2018',6,'P'); Insert into absent1 values ('03-APR-2018',1,'P'); Insert into absent1 values ('03-APR-2018',2,'P'); Insert into absent1 values ('03-APR-2018',3,'P'); Insert into absent1 values ('03-APR-2018',4,'A'); Insert into absent1 values ('03-APR-2018',5,'A'); Insert into absent1 values ('03-APR-2018',6,'A'); Insert into absent1 values ('05-APR-2018',1,'A'); Insert into absent1 values ('05-APR-2018',2,'P'); Insert into absent1 values ('05-APR-2018',3,'P'); Insert into absent1 values ('05-APR-2018',4,'P'); Insert into absent1 values ('05-APR-2018',5,'A'); Insert into absent1 values ('05-APR-2018',6,'P');