Design+Artifacts

=Physical Schema=

media type="custom" key="8153140"
Edit here: [] =Description of Tables and Columns=

Student
contains the Student Assistants' information
 * **sn** - Student Number, primary key
 * **fname** - first/given name
 * **mname** - middle name
 * **lname** - last name
 * **birthdate**
 * **placeofbirth**
 * **presentadd** - present address of SA
 * **permadd** - permanent address of SA
 * **contactno** - contact number

** Faculty **
contains the Faculty Member (Supervisor)'s information
 * **fid** - Faculty Number, primary key
 * **fname**- first/given name
 * **lname**- last name

** DTR **
//**Daily Time Record.**// This serves as a log of the hours the SAs spend working. Each SA is required to create and keep this document and have it signed by their supervisor (the faculty member assigned to them) at the end of the month.
 * **sn** - Student Number, primary key, foreign key references Student
 * **month** - Month the DTR was created, primary key
 * **year** - Year the DTR was created, primary key
 * **fid** - Faculty ID of the supervisor, foreign key references Faculty
 * **arrival** - official arrival hour of the SA (ie. official start time of work everyday)
 * **departure** - official departure hour of the SA (ie. official end time of work everyday)

//Note: fname (first name of SA) and lname (last name of SA) were omitted because they could be retrieved from the Student table using **sn**. total (total hours) was omitted because it can be computed from the information in Records.//

** Record **
Contains the date, time in and time out of the SA when s/he works.
 * **sn** - Student Number, primary key, foreign key references Student
 * **date** - primary key
 * **in** - time in
 * **out** - time out

** CRD **
//**Certificate for Report of Duty.**// A document required for each SA. This is checked every month before paychecks are released.
 * **sn** - Student Number, primary key, foreign key references Student
 * **unit** - the department or office wherein the SA is delegated
 * **position** - nature of job in the office
 * **salary**
 * **actualRD** - actual date of report for duty
 * **purpose**

//Note: fname, mname and lname were also omitted, because we could get this from the Student table.//