Sumukhabs
commented
3 years ago I will also update in the repository.
On Fri, Jul 2, 2021 at 7:36 PM naamsanam @.***> wrote:
good evening sir,
I doing java project in Student.Attendence Mangement System . before u delete this code this have database sir after u again upload this java project may be u forgot to upload database sir. Code everything fine sir but u didnt upload oracle database sql for student attendence mangement system . please upload oracle sql for this sir. Thank you sir.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Sumukhabs/Student-Attendance-Management-System/issues/1, or unsubscribe https://github.com/notifications/unsubscribe-auth/ANMYDKB2ZQ3MX3EQTTYJW3DTVXBUXANCNFSM47WZJDMQ .
DATABASE OPERATIONS:
-
create table admin(name varchar(20),contact int not null unique,username varchar(20) not null unique,password varchar(20),primary key(name));
-
create table semister(sem varchar(20),primary key(sem));
-
create table coursecode(course_code varchar(20),primary key(course_code));
-
create table years(year int,primary key(year));
-
create table section(sec varchar(10),primary key(sec));
-
create table course(course_id varchar(20),course_name varchar(20),sem varchar(20),lecture_name varchar(20),year int,unique(course_id,year),Foreign key(course_id) references coursecode(course_code),Foreign key(sem) references semister(sem) on delete cascade,Foreign key(lecture_name) references admin(name) on delete cascade,Foreign key(year) references years(year) on delete cascade);
-
create table student(USN varchar(20),name varchar(25),course_id varchar(20),sem varchar(20),sec varchar(10),primary key(USN),Foreign key(course_id) references coursecode(course_code) on delete cascade,Foreign key(sem) references semister(sem) on delete cascade,Foreign key(sec) references section(sec) on delete cascade);
-
create table attendance(USN varchar(20),course_id varchar(20),no_of_attended_classes int,no_of_classes_absent int,total_classes int,year int,attendace_percent,sem varchar(20),Foreign key(USN) references student(USN) on delete cascade,Foreign key(course_id) references coursecode(course_code) on delete cascade,Foreign key(year) references years(year) on delete cascade,Foreign key(sem) references semister(sem) on delete cascade);
-
insert into admin values('admin_name',9898989898,'admin','adminpass'); //similarlay you can add all the admins and their password
-
insert into semister values('3rd Semister');
-
insert into semister values('4th Semister');
-
insert into semister values('5th Semister');
-
insert into semister values('6th Semister');
-
insert into semister values('7th Semister');
-
insert into semister values('8th Semister');
-
insert into coursecode values('17CS31'); //similarly you can add all the coursecode of the department
-
insert into years values(2018);
-
insert into years values(2019); //similarly all the years as per the record
-
insert into section values('A Section');
-
insert into section values('B Section');
21.CREATE or replace PROCEDURE cpr AS begin update attendance set total_classes=total_classes+1; end/ //procdure 1
-
create or replace procedure cpr2 as begin update attendance set attendance_percent=(100*no_of_attended_classes)/total_classes; end/ //procedure 2
-
Create or replace trigger usntr Before insert or update on student For each row Begin If(length(:new.USN)>10) then RAISE_APPLICATION_ERROR(-20002,'Enter Correct USN'); End if; End; //Trigger 1
-
Create or replace trigger usntr2 Before insert or update on student For each row Begin If(length(:new.USN)<10) then RAISE_APPLICATION_ERROR(-20001,'Enter Correct USN'); End if; End; //trigger 2
-
create or replace view v1 as select A.USN,A.course_id,C.course_name,A.no_of_attended_classes,A.no_of_classes_absent,A.total_classes,A.attendance_percent,A.year,A.sem from attendance A,course C where A.course_id=C.course_id //view
naamsanam
good evening sir,
I doing java project in Student.Attendence Mangement System . before u delete this code this have database sir after u again upload this java project may be u forgot to upload database sir. Code everything fine sir but u didnt upload oracle database sql for student attendence mangement system . please upload oracle sql for this sir. Thank you sir.