DatabaseClass2

desc form;
desc test_result;
drop table test_result;
create table test_result
(
tsno number(10),
rollno number(4),
slno number(10),
dateofpublish date,
marks number(3),
constraint var_pk_tr1 primary key(tsno),
constraint var_fk_tr1 foreign key(slno) references form(slno),
constraint var_uq_tr1 unique(rollno,dateofpublish)
);
create table student
(
tsno number(10),
id number(9),
name varchar2(100) not null,
dept_id varchar2(10),
semester varchar2(12) not null,
year number(4),
constraint var_pk_std2 primary key(id),
constraint var_fk_std2 foreign key(tsno) references test_result(tsno),
constraint var_chk_std2 check (year BETWEEN 2000 and 2030)
);
desc student;
select * from form;
desc test_result;
insert into test_result
values(1,50,1,'09/19/2018',48);
insert into test_result
values(2,49,1,'09/19/2018',48);
desc student;
insert into student
values(1,201720450,'Sunny','cse','summer',2015);