Re: ACCESS 2007: need help in database breakdown and table creation

i would have something like

tblemployee
Employeeid,autonum
LastName,text
FirstName,text
DateHired,date/time
ApprenticeLevel,text or number depending on format of field
PreviousRate,currency
CurrentRate,currency
DateofRaise,date/time
ApprenticeSchoolStartDate,date/time
ApprenticeSchoolEndDate,date/time
Comments,memo or text depending on length

tbljobsite
jobsiteid,autonum
Jobsitename,text
employeeid,number
ProjectLeader,yes/no

if you want to track the pay increases over time not juts the last pay
increase you need another table

tblpay
payid,autonum
employeeid,number
PreviousRate,currency
CurrentRate,currency
DateofRaise,date/time

so you would stick everyone in the employee table including project
leaders i added the ProjectLeader,yes/no field to job site but this is
only useful if an employee can be both a project leader and a normal
employee on another site. if this is not the case then the
projectleader,yes/no would be added to the employee table instead.

i hope this makes sence

Regards
Kelvan
.

Relevant Pages

  • Re: Relational-to-OOP Tax
    ... depending on the size of the SQL statements ... cleaner or more well-factored code. ... insert into employee values ...
    (comp.object)
  • Re: constructors
    ... "Mike Wahler" wrote in message ... > Employee emp(1, ... depending on exactly what that was supposed to mean in this ... then the OP should stick with his/her original code for this ...
    (alt.comp.lang.learn.c-cpp)
  • Re: block remote desktop
    ... depending on their importance to the company. ... they have no regard for company policy. ... He is just like any employee who takes offense to ...
    (microsoft.public.windowsxp.general)
  • Re: Create object in runtime
    ... http://msdn.microsoft.com/en-us/library/6sh2ey19.aspx that allows to store a ... Also depending on what the application does, ... program should be able to create an object by itself for that employee. ... user needs only 30 object or may be the user needs more than 50 object. ...
    (microsoft.public.dotnet.framework.aspnet)