Implementation

1. **Database User Account**

//Administrator Account// The administrator account will have the capability of adding, deleting and monitoring student and employer accounts.

//Employer Account// The employer account will have the power to add student records whenever a student assistant is employed. Moreover, it will have access to the student assistants' records but will not have the power to edit field entities, except for the DTR record. The employer account can access and update the DTR records, giving it the capability to log in or out a student.

//Student Account// The student account will only have access to its own records. It can only update its own information and access records pertaining to its unique student number.

[|EmptyDatabase Updated]
 * 2. Clean Database**

[|Clean Database with PreDefined Codes]
 * 3. Clean Database with Pre-defined Codes**

[|Stable Instances of Database]
 * 4. Stable Instances of Database**

= = [|Queries Updated]
 * 5. Queries**



__**Installation Guide**__
>
 * 1) Download and install Xampp: Get Xampp Here!
 * 2) Download the php.ini file from our site and replace the php.ini file in the xampp folder(This is to easily activate the oci8 driver needed for the compatability of oracle with php)
 * 1) Alternate to step number 2: uncomment the line containing **extension=php_oci8.dll** and the following lines under the OCI8 subsection

[OCI8] oci8.privileged_connect = Off

oci8.max_persistent = -1

oci8.persistent_timeout = -1

oci8.ping_interval = 60

oci8.connection_class =

oci8.events = Off

oci8.statement_cache_size = 20

oci8.default_prefetch = 100

oci8.old_oci_close_semantics = Off

4.Download the and install oracle 10g systemGet Oracle Here! 5.Download and extract files the website files

SAP Database 6.Import the database into oracle using an administration account and the account to be use in the php database integration. This can be done in two ways.The first is by copying the file used under the clean database heading in the first part of this page The second is to use the imp function of oracle.Instructions for importing can be found in the Oracle Reference Materials entitled 2 Day DBA.

7.Put the whole 197 folder into the htdocs folder found inside the xampp folder 8. Open the database file found in the application folder then config folder 9.Change the username and password accordingly to your own username and password of an oracle database administrator account 10.To open the homepage,type the web address if running in xampp:localhost/197/index.php 11.Use the administration account to add a new account Userid:000000001 password:123 12.Start using the software!

**__Improvements and Bugs__**
1. The formula for the DTR is still incorrect.It does not correctly compute the total hours.The error is reflected in all DTR pages and the printing of the File.(Possible Solution: restructure the database to split the hours and minutes into separate columns) 2. Automatic Time out if the account exceeds the official work hours(ie. Maximum Work Hours per day:5 hours) 3.Ability to save the bill and other documents into PDF format for an offline archiving. 4.Add search feature to be able to search for students from large records.(case insensitive search). 5.Edit the GUI to make it more standard among different web browsers.