Create table Student ( Stuid number(5) primary key, Status varchar2(10),name varchar2(300) Class varchar2(30),mob varchar2(30)); Insert into Student values (1, 'PRESENT', 'ABC','PREP','+923008664447'); Insert into Student values (2, 'PRESENT', 'A','PREP','+923008664447'); Insert into Student values (3, 'PRESENT', 'BC','PREP','+923008664447'); Insert into Student values (4, 'PRESENT', 'DABC','TWO','+923008664447'); Insert into Student values (5, 'PRESENT', 'FABC','TWO','+923008664447'); Insert into Student values (6, 'PRESENT', 'AGBC','PREP','+923008664447'); Insert into Student values (7, 'PRESENT', 'AC','PREP','+923008664447'); create table subject ( sno number(4) primary key,class varchar2(30), subj varchar2(40)); Insert into Student values (1, 'PREP','ENGLISH'); Insert into Student values (2, 'PREP','URDU'); Insert into Student values (3, 'PREP','MATH'); Insert into Student values (4, 'TWO','ENGLISH'); Insert into Student values (5, 'TWO','URDU'); create table exam ( exid number(4) primary key , exam_type varchar2(50)); Insert into Student values (1, '1st Term 2016'); Insert into Student values (2, '2nd Term 2016'); Insert into Student values (3, 'Final term 2016'); create table Test ( ID Number(5) Primary key,CLASS VARCHAR2(30),exid number(4) references exam(exid) class varchar2(30),sno number(4) references subject(sno),tmarks number(3)); Insert into Test values (1, 'PREP',2,1,50); Insert into Test values (2, 'PREP',2,2,50); Insert into test values (1, 'PREP',2,3,50); Insert into test values (1, 'TWO',1,4,50); Insert into test values (1, 'TWO',1,5,50); create table Test1 ( id number(5) references test(id),tstuid number(5) references student(stuid) obtmarks number(5,2)remarks varchar2(50)); Insert into Test1 values (1, 1,30,'PAS); Insert into Test1 values (1, 2,16.7,'PAS'); Insert into test1 values (1, 3,23,'PAS',); Insert into test1 values (1, 4,10,'FAIL'); Insert into Test1 values (2, 1,39,'PAS); Insert into Test1 values (2, 2,16.7,'PAS'); Insert into test1 values (2, 3,23,'PAS',); Insert into test1 values (2, 4,10,'FAIL'); Insert into Test1 values (3, 1,3,'PAS); Insert into Test1 values (3, 2,11,'PAS'); Insert into test1 values (3, 3,2,'PAS',); Insert into test1 values (3, 4,1,'FAIL'); create table msgout ( id number(7) primary key,msgto varchar2(20),msg varchar2(1000),send varchar2(30));