Design


 * Overview**

Our group is tasked to create a payroll for **UP Department of Computer Science (DCS) student assistants (SAs)**. The UP Accounting Office manages the SAs' payroll along with the other employees'. We decided not to do the payroll anymore because the UPAO is already used to their payroll system software.

However, we discovered that we could improve one part of the long and tedious 'SA process'. Before getting their salary, the SAs need to complete certain requirements. Two of these requirements are the **Daily Time Record** (DTR) and **Report for Duty**. Both of these are handled in the department. Our aim is to improve the rate of getting these requirements done and reduce paperwork. :)

In this page, you will find the necessary requirements to get the project done.

1. **Installing Oracle** (Workshop 2) We wrote a detailed description on how we installed Oracle 10g XE in Windows XP. We added screenshots for easier reading. //Last Updated: December 1, 2010//

2. **Requirements Artifacts** (Workshop 2 and 3) //Last Updated: December 6, 2010//
 * Conceptual Database Design**. Here we compiled the requirement artifacts which are very essential for designing the project. Of course, we should know what the stakeholders need before developing anything. The requirement artifacts are **interview transcript, sample forms and reports, list of queries and initial ERD.**

3//.// **Design Artifacts** (Workshop 4)
 * Physical Database Design.** In this section, we have transformed our conceptual model to a relational model. Entries, relationships and attributes are transformed into tables and columns. Now we have information that the computer (DBMS) could understand.