Student Project GuideOnline College Fee Payment System project is for educational institute. An Educational institutes running colleges at multiple locations.They want an centralized application to pay Fees by student online.Project must also manage salary of accountant and Details of Student.Various customized report must be generated as per requirement.student must be able to pay Fees online.
User’s of the System:-
- Admin of the System:-
- Manage Accountant of Various Colleges-means Insert,Update or Delete Accountant Details after LogIn
- Search and Generate report of Accountant.
- Search and Modify Details of Student.
- Accountant of Colleges
- Accountant can Search For Particular Student.
- Update Details of Student.
- Enroll New Student in the System.
- Student of the System
- Student can pay their Fees Online.
- Search History of Paid Fees.
Tools and Technology used:-
1.Use any Java integrated IDE to develop this project.you can use eclipse or netbeans for this project.
2.Oracle as a back end for the database.
3.Apache Tomcat as a web server to run this project.
Table Fields:
CREATE TABLE "STUDENT2"
( "ID" NUMBER,
"NAME" VARCHAR2(4000),
"COURSE" VARCHAR2(4000),
"MOBILE" VARCHAR2(4000),
"FEESUB" VARCHAR2(4000),
"FEE" VARCHAR2(4000),
"PAID" VARCHAR2(4000),
"BALANCE" VARCHAR2(4000),
"ADDRESS" VARCHAR2(4000),
"FATHERNAME" VARCHAR2(4000),
"MOTHERNAME" VARCHAR2(4000),
"DATEOFBIRTH" VARCHAR2(4000),
"QUALIFICATION" VARCHAR2(4000),
"DATEOFJOINING" VARCHAR2(4000),
"DESCRIPTION" VARCHAR2(4000),
"TRAINER" VARCHAR2(4000),
CONSTRAINT "STUDENT2_PK" PRIMARY KEY ("ID") ENABLE
)
/
CREATE OR REPLACE TRIGGER "BI_STUDENT2"
before insert on "STUDENT2"
for each row
begin
select "STUDENT3_SEQ".nextval into :NEW.ID from dual;
end;
/
ALTER TRIGGER "BI_STUDENT2" ENABLE
/
----------------------------------------------------------------
CREATE TABLE "PAYREGISTER"
( "ID" NUMBER,
"USERNAME" VARCHAR2(4000),
"USERPASS" VARCHAR2(4000),
"BRANCH" VARCHAR2(4000),
"DATEOFJOINING" VARCHAR2(4000),
"DATEOFBIRTH" VARCHAR2(4000),
"SALARY" VARCHAR2(4000),
CONSTRAINT "PAYREGISTER_PK" PRIMARY KEY ("ID") ENABLE
)
/
CREATE OR REPLACE TRIGGER "BI_PAYREGISTER"
before insert on "PAYREGISTER"
for each row
begin
select "PAYREGISTER_SEQ".nextval into :NEW.ID from dual;
end;
/
ALTER TRIGGER "BI_PAYREGISTER" ENABLE
/
Download Project source code:
₹499Add to cart
🔥5.1 K Views
15 Comments
ntivuguruzwa vedaste
August 6, 2019 - 8:12 PMwhich relation ship with sudent and colle?
Student Project Guide
August 6, 2019 - 8:12 PMI didn’t get you.. Can you elaborate what you said?
ntivuguruzwa vedaste
May 20, 2019 - 1:01 PMwhich relation ship with sudent and colle?
Student Project Guide
May 20, 2019 - 6:32 PMI didn’t get you.. Can you elaborate what you said?
khalidajamal
August 6, 2019 - 8:12 PMhow to execute it,can u plzz commenet me execution steps
Shiva Prasad
September 2, 2019 - 11:16 PMWe will update this in one month.
kalidsjamal
August 6, 2019 - 8:12 PMhow to execute it??
can u plzz help me with the execution process
Student Project Guide
August 6, 2019 - 8:12 PMHi kalid s jamal
We creating video video tutorial for all our project. once we complete that we will inform you.
Khalida Jamal
August 30, 2019 - 11:06 PMHi
I m waiting for your tutorial video
Shiva Prasad
September 2, 2019 - 11:16 PMOk we will create video on this. Please wait for one week time.
khalidajamal
July 26, 2019 - 9:10 PMhow to execute it,can u plzz commenet me execution steps
kalidsjamal
July 26, 2019 - 9:12 PMhow to execute it??
can u plzz help me with the execution process
Student Project Guide
July 26, 2019 - 9:42 PMHi kalid s jamal
We creating video video tutorial for all our project. once we complete that we will inform you.
srisurya kalidindi
November 3, 2019 - 11:45 PMcan u tell me how to execute it
Student Project Guide
November 5, 2019 - 6:58 AMDid you installed all necessary softwares..
omary
September 12, 2020 - 9:55 AMHi!.
Aman Bastia
October 9, 2020 - 11:18 PMcan u please send the video how to execute it!!!