Blog

Employee Classification Table
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 w

ith 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