create table attendance1 (
subject varchar2 (10),
reg_no varchar2 (10),
absent_date date,
reason varchar2 (20)
create table subject1(
sub_code varchar2 (10),
name varchar2 (20),
credits number(5),
core_book varchar2 (20),
ref_book1 varchar2 (20),
ref_book2 varchar2 (20),
practical_flag varchar2 (10),
core_flag varchar2 (10),
program varchar2 (2),
area varchar2 (20)
create table faculty1(
emp_id varchar2 (20),
name varchar2 (20),
cubical varchar2 (5),
designation varchar2 (20),
qualification varchar2 (20),
work_exp varchar2 (30),
phone number(10),
email varchar2 (30),
area varchar2 (20),
campus varchar2 (20)
create table groups1(
reg_no varchar2 (10),
group_id varchar2 (10)
create table groups2
Reg_no varchar2(10),
Group_ID varchar2(20)
create table Group_subject1
Group_ID varchar2(20),
Sub_code varchar2(15),
Description varchar2(50)
Create table classroom1
CR_no varchar2(5),
Floor varchar2(10),
Capacity varchar2(15),
Computers varchar2(20)
create table student5 (
Reg_no varchar2 (10) primary key,
Name varchar2 (20),
Address varchar2 (40),
Phone_no Number (10),
Email varchar2 (20),
Fathers_name varchar2 (20),
Mothers_name varchar2 (20),
DOB date,
Gender varchar2 (1),
Program varchar2 (2),
Stream varchar2 (10),
Blood_group varchar2 (3),
Nationality varchar2 (10),
CAT_percent varchar2 (5),
MAT_percent varchar2 (5),
Languages varchar2 (20),
Scholarship varchar2 (1),
Physical_disability varchar2 (10),
s10th_percent Number (5),
s12th_percent Number (5),
UG_university varchar2 (40),
UG_percent Number (5),
Marital_status varchar2 (1),
UG_year varchar2 (10),
Work_exp varchar2 (50)
create table results5 (
reg_no varchar2 (10),
sub_code varchar2 (15),
internal_marks number(3),
external_marks number(3),
project number(3),
viva number(3),
term number(3),
primary key (reg_no,sub_code)
create table attendance5 (
subject varchar2 (10),
reg_no varchar2 (10),
absent_date date,
reason varchar2 (20),
primary key (subject,reg_no,absent_date)
create table subject5(
sub_code varchar2 (10) primary key,
name varchar2 (20),
credits number(5),
core_book varchar2 (20),
ref_book1 varchar2 (20),
ref_book2 varchar2 (20),
practical_flag varchar2 (10),
core_flag varchar2 (10),
program varchar2 (2),
area varchar2 (20)
create table faculty5(
emp_id varchar2 (20) primary key,
name varchar2 (20),
cubical varchar2 (5),
designation varchar2 (20),
qualification varchar2 (20),
work_exp varchar2 (30),
phone number(10),
email varchar2 (30),
area varchar2 (20),
campus varchar2 (20)
create table groups5(
reg_no varchar2 (10),
group_id varchar2 (20),
primary key (reg_no,group_id)
)
create table Group_subject5
Group_ID varchar2(20),
Sub_code varchar2(15),
Description varchar2(50),
primary key (Group_ID,sub_code)
Create table classroom5
CR_no varchar2(5) primary key,
Floor varchar2(10),
Capacity varchar2(15),
Computers varchar2(20)
CREATE OR REPLACE FUNCTION Gradefind (Marks Number)
RETURN VARCHAR2 AS
GradeOut VARCHAR2(10);
BEGIN
IF Marks>100 Then GradeOut:='invalid';
ELSIF Marks>90 and marks <=100 Then GradeOut:='A';
ELSE GradeOut:='f';
END IF;
RETURN (GradeOut);
END;
CREATE OR REPLACE PROCEDURE PrintOutGrade(marks NUMBER) as
Ans Varchar2(10);
BEGIN
Ans:=GradeFind(Marks);
DBMS_OUTPUT.PUT_LINE(Ans);
END;
BEGIN
Printoutgrade(182)
END;
create or replace procedure att_report (sub varchar2) is
cursor attcursor is
select * from attendance5
where subject = sub;
vsub varchar2(10);
vstudent varchar2(10);
vabsdate date;
vreason varchar2(50);
begin
open attcursor;
loop
fetch attcursor into
vsub, vstudent, vabsdate, vreason;
exit when attcursor%Notfound;
DBMS_OUTPUT.PUT_LINE (Vsub||' '||vstudent||' '||vabsdate||' '||vreason);
end loop;
close attcursor;
end;
