jgt@uhccux.uhcc.hawaii.edu (John Tsang) (09/11/89)
Among those inexpensive databases: Reflex+, Reflex for the
Mac (Are they the same?), File, FileMaker, DBM in Works,
Panorama, DAtabase, Record for the xxxxx, etc., which ones
are relational type?
(I think) I need a relational DBM, because it is for
a company personnel records, which need a file for the
application data, a file for the hiring data (W2, State W2,
Payroll form, I-9, etc.), a file for Absence, No-Show, Late,
..... etc., a file for daily performance checklist, a file
for Sales &/or # of customers handled each night, a file for
hours worked per week &/or per day -- to keep track of the
full-time employees, and, a file about med. insurance given.
Oftentimes, it is essential, for example, to search
who has been full-time but hasn't given the med. insurance,
or, who has dropped to part-time but still hasn't been
cancelled insurance; or, to check the Performance Checklist
(file) against the Sales &/or # of customers records -- to
check if the employees are good in sales, efficiency,
service and other duties & performance. Thus, it needs to cross search
several files simultanously. [It probably may be too slow
to put all the data of one person in one record in one
file.] (By the way, it is for a restaurant with about 70-50
employees -- and will expand to 100 in the near future.)
I don't want to incur the expenses and time on heavy-duty
DBM software, such as, Foxbase, Double Helix, 4th Dimension,
dbMac, etc.
However, I'm not eliminating to consider them, if
it's necessary.
Or, I actually don't need a relational database.
(Both database for the Mac or pc are suitable: we have access to both
systems -- however, preferably for the Mac.)
* Please reply directly via E-mail.jgt@uhccux.uhcc.hawaii.edu (John Tsang) (09/20/89)
Among those inexpensive databases: Reflex+, Reflex for the
Mac (Are they the same?), File, FileMaker, DBM in Works,
Panorama, DAtabase, Record for the xxxxx, etc., which ones
are relational type?
(I think) I need a relational DBM, because it is for
a company personnel records, which need a file for the
application data, a file for the hiring data (W2, State W2,
Payroll form, I-9, etc.), a file for Absence, No-Show, Late,
..... etc., a file for daily performance checklist, a file
for Sales &/or # of customers handled each night, a file for
hours worked per week &/or per day -- to keep track of the
full-time employees, and, a file about med. insurance given.
Oftentimes, it is essential, for example, to search
who has been full-time but hasn't given the med. insurance,
or, who has dropped to part-time but still hasn't been
cancelled insurance; or, to check the Performance Checklist
(file) against the Sales &/or # of customers records -- to
check if the employees are good in sales, efficiency,
service and other duties & performance. Thus, it needs to cross search
several files simultanously. [It probably may be too slow
to put all the data of one person in one record in one
file.] (By the way, it is for a restaurant with about 70-50
employees -- and will expand to 100 in the near future.)
I don't want to incur the expenses and time on heavy-duty
DBM software, such as, Foxbase, Double Helix, 4th Dimension,
dbMac, etc.
However, I'm not eliminating to consider them, if
it's necessary.
Or, I actually don't need a relational database.
(Both database for the Mac or pc are suitable: we have access to both
systems -- however, preferably for the Mac.)