Class > Pl Assignment 1

-course table------------create table tb_course(vch_cor_id varchar2(15),vch_cor_name varchar2(15),vch_duration varchar2(15), num_cor_fees number(8)); create or replace procedure course (course varchar,cname varchar,d uration varchar,fees number)is begin insert into tb_course values(course,cname,duration,fees); commit; end; -registration table-------create table tb_register(vch_app_id varchar2(5),vch_cor_id varchar2(10),vch_cor_name varchar2(15), vch_stu_name varchar2(15),vch_stu_address varchar2(15),num_ph_no number(12),vch_stu_email varchar2(25), num_app_fee number(5)); create or replace procedure register(appid varchar,corid varchar, corname varchar,sname varchar,saddr varchar,phno number,mail varchar,apfee numbe r)is begin insert into tb_register values(appid,corid,corname,sname,saddr,phno,mail,apfee); commit; end; -admission table--------create table tb_admission(vch_app_id varchar2(5),vch_cor_id varchar2(5),vch_stu_name varchar2(15), dat_admi_dat date) create or replace procedure admission(appid varchar,corid varchar ,sname varchar,dat date)is begin insert into tb_admission values(appid,corid,sname,dat); commit; end; -student table------create table tb_stu_details(vch_stu_id varchar2(8),vch_cor_id varchar2(8),vch_stu_name varchar2(15), vch_father_name varchar2(15),vch_sex varchar2(15),dat_dat_of_birth date); create or replace procedure student(stuid varchar,corid varchar,n ame varchar,fname varchar,sex varchar,birth date)is begin insert into tb_stu_details values(stuid,corid,name,fname,sex,birth); commit; end; -department table-----create table tb_department(vch_dept_id varchar2(8),vch_dept_name varchar2(15));

create or replace procedure department(deptno varchar,depname var char)is begin insert into tb_department values(deptno,depname); commit; end; -staff table------------create table tb_staff_details(vch_dept_id varchar2(5),vch_staff_id varchar2(5),vch_staff_name varchar2(15), vch_staff_status varchar2(10)); alter table tb_staff_details add (dat_hire_date date, num_experiance number(5), vch_sub_id varchar2(15)) -subject table-----------create table tb_subject_details(vch_sub_id varchar2(8),sub_sub_name varchar2(15),vch_book_name varchar2(20), vch_author_name varchar2(15)); create or replace procedure subject(subid varchar,subname varchar ,bookname varchar,autname varchar)is begin insert into tb_subject_details values(subid,subname,bookname,autname); commit; end;