Table1 Employee Classification Table
No F Name LName Employee ID S H C Employee type
1 Amos KidulKidula
2343546 S
2 Anthony Barasa 3 Absolom Karanja 4 Alfred
Oluoch 5 Abiud Ochieng Table 1 showing Employee classification
Table 4 Description of terms
Term
Term_Code Term_Description
S Salaried
H Hourly
C Contracted
L Last
F First
Table 2 Invoice
Table 2 showing Employees Invoices
A category table is a vibrant table which tends to portray category information in a sequence of columns and rows. The invoice category table has auto generated IDs while the employee classification table does not have auto generated IDs.
An Object table provides a better way of organizing and arranging work for instance through the use of nested tables and variable lengths arrays. The object table as is the case with the employee classification table enables one to identify the types of objects that can be utilized in each row in the object table.
Table 5: A data base diagram with lists of vendors, invoices, terms codes, employees, and employee classifications
Vendor Activity Summary For 1/1/2013 thru 1/31/2012 Vendor # of Invoices Total Amount Average Invoice Amount Unpaid Amount Employees
Amos
Kidula EClass
S American Standard Plumbing 2 $158,450.00 $53,246.67 $17,860.00 Anthony Barasa C El’s Pipe Supply 3 $14,000.00 $16,000.00 $15,000.00 Absolom Karanja H Grainger Welding Equipment 2 $2,000.00 $2,000.00 $2,000.00 Alfred
Oluoch S Horizon Tape 3 $2,482.50 $2,482.50 $0.00 Abiud Ochieng Kitchen Sink Co. 1 $35,000.00 $16,500.00 $12,000.00 Office Max 1 $980.00 $590.00 $0.00 Skil Tools 1 $7,000.00 $2,500.00 $0.00 Totals 11 $221,212.50 $18,267.71 $45,850.00 Table 5 showing lists of vendors, invoices, terms codes, employees, and employee classifications
