Wednesday, January 16, 2008

GP report on "UP ONLINE SCHOLARSHIP APPLICATION DATABASE SYSTEM"

Yesterday, January 16, 2008 at around 11 am, our group (Girl Power) reported the recent development of our project(UP OSADS). We presented the prototypes of the system with an integrated php codes already. Here are the comments of Ma'am Solamo and the revisions she have suggested.

Login - Make the textfield name visible.
In updating the status of the applicant - instead of displaying a list of all the applicants with a drop down menu for "Approved or Disapproved", why not just search the applicant to be updated using his/her student number instead of having a long list of applicant on the screen.
Password - should not be used as a primary key because it changes from time to time.
Username - as a primary key is also not recommended, numbers are preferred.
Email add - can be used as a primary key
Grade - be made into GPA
Primary keys are unique, and cannot be a null value.

** Finalize the normalization to be emailed by monday -- perl
** Develop all interfaces, check and update with the rtm
--start with the must haves scenarios
update with rtm---kc
interfaces -- beth and rona

No comments: