Kennesaw State University Department of Computer Sciences

1
Kennesaw State UniversityDepartment of Computer
Sciences

• Financial Aid Application

Usa Rungratchakanon
CS 8630 Database Administration Fall 2005
2
Objective

• The objective of this project is to create the
  package that will be applied to the KSU database
  system in order to support the future database
  for the Financial Aid Department at Kennesaw
  State University so that the Students can apply
  for their financial aid online.

3
Characteristic of Application

• The Financial Aid application follows by the
  requirement should be
• Student can apply for the Financial Aid Loan
  online and the Financial Aid application should
  support for both student and co-loaner because
  the information that the Financial Aid requires
  for co-loaner form is more than the student
  information form.
• Financial Aid officer can retrieve the Financial
  Aid application from the database.

4
Technologies Used

• Oracle 9i Personal Edition
• PL/SQL Web toolkit
• HTML

5
Gantt Chart
6
Step of progress

• Studying for the database system and Programming
  language
• Gathering the requirement
• Creating the E-R Diagram
• Creating the Relational Schema
• Create table in the database
• Develop PL/SQL web application
• Testing the application
• Sending to the Financial Aid officer to approve
• Submit to the ACS

7
E-R Diagram
8
Relational Schema
9
CRUD Matrix
10
Screen

• Financial main page

11
Screen

• Student Address

12
Screen

• Modify Student Address

13
Screen

• Financial Aid for student

14
Screen

• Financial for Student Result

15
Screen

• Financial for Co-loaner

16
Screen

• Financial for Co-loaner Result

17
Screen

• Financial Aid Search

18
Conclusion

• Difficulties Encountered
• Dealing and gathering the requirement
• Setup the system to the same platform of KSU.
• The not null variables have to be checked before
  submit to the database

19
Question?

• ????????????????????????????????????????????
• ??
  ??
• ?? Feel free to ask me the question!!
  ??
• ??
  ??
• ??
  ??
• ??
  ??
• ????????????????????????????????????????????

20

• Thank you