G
Guest
I want to design a data base that records a employees hours by the week and
computes his pay. How many tables do I need ?
computes his pay. How many tables do I need ?
V
Vincent Johns
12 Tables. 
Seriously, how many Tables you need will depend on what kinds of
information you want to collect and store. You might check out the
"Time and Billing" sample database. To create that, use File --> New,
choose the Databases tab, and choose "Time and Billing". You might not
need some of the objects that the Database Wizard will create for you,
but I think that playing around with the database will be instructive.
As an alternative, you might consider looking for a commercial program
to do this accounting. There are legal requirements attached to
computing people's pay, so making a mistake in your database could
become pretty expensive (= possibly more expensive than the accounting
package).
-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
Seriously, how many Tables you need will depend on what kinds of
information you want to collect and store. You might check out the
"Time and Billing" sample database. To create that, use File --> New,
choose the Databases tab, and choose "Time and Billing". You might not
need some of the objects that the Database Wizard will create for you,
but I think that playing around with the database will be instructive.
As an alternative, you might consider looking for a commercial program
to do this accounting. There are legal requirements attached to
computing people's pay, so making a mistake in your database could
become pretty expensive (= possibly more expensive than the accounting
package).
-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.