How to designe Database

[waqas]

hi Database experts.

kindly suggest, i am not really getting idea how to designe and create relation between tables.

i want to keep employees data i am confusing how to manage it.

i want to add new employees in master list and want to keep their promotion data, department change, grade cnange, title change when any employee got all these at which date and when terminated and retired.



i want to keep all the records but when i will give past date range in given range employees should appear even terminated, old position and new joiners in given date range.

[waqas]

hi database admins,

kindly have a look on my request.

[alansidman]

Here is whitepaper on database design.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

This should help you get started in setting out your design. It is a good practice to lay out your schema on paper before beginning to create your tables.

Alan