Basic Personnel Database

[Liz1911]

Hi I work for a small charity (10 Employees) I am hoping to create a small database to try and replace the manual records we hold.
I have made one or two databases before but struggle with tables how many and what to have in them!
I wondered if there was a sample Personnel Database that I could look at and either copy the format or look and be able to see the basic set up.


What I'm looking for would be a record for each employee, with the option to add training carried out, salary, policies signed, sickness record, holiday records, appraisal record etc.
If someone could point me in the right direction I would be grateful.
Thanks

 

[jdraw]

Here are 2 tutorials that will help you identify business facts and from them:
design tables and relationships.
You have to work through the tutorials about 40-50 minutes each. But since you have built other databases, the time to do the tutorial may be shorter.

You start with a business description regardless of the details of the approach you use.

Work through 1 or both of these to gain the experience of the procedure.

Class Info
Consolidated widgets

You should also be familiar with Normalization.

Good luck.

 

[pbaldy]

FYI, thread moved out of moderated sample databases forum and both posts approved.

 

[Liz1911]

Thanks Guys I will work through your suggestions