create table dept
(
dept_id number(10) primary key
);

create table grade
(
grad vachar2(5)not null,
start_marks number(4)not null,
end_marks number(4)not null,
gp number(5)not null
);


create table student
(
s_id number(10) primary key,
dept_id number(10) ,
constraint var_fk_dpid foreign key(dept_id) referances dept(dept_id)
);



create table course (
code number(10) primary key ,
credit number(10) unique ,
dept_id number(10),

);


create table (

);


create table result(
id number(10) primary key,
t_id number(10) unique,
code number(10) unique,

semister varchar2(10),
ct number(10),
mid number(10),
final number(10),
attendence number(10)

);



create table f_result(
id number(10) primary key,
code number(10) ,
semester varchar2(10),
total_marks number(10),
grade varchar2(10),
gpa number(10)
);













create or replace trigger in
after insert on f_result
for each row
declare
v_id number(10);
v_semister varchar2(10);
v_