Results 1 to 3 of 3
  1. #1
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117

    Question How to designe Database

    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.

  2. #2
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117

    Smile

    hi database admins,

    kindly have a look on my request.

  3. #3
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 AM
  2. Replies: 20
    Last Post: 08-08-2011, 01:34 PM
  3. Replies: 3
    Last Post: 05-15-2011, 10:52 PM
  4. Replies: 1
    Last Post: 11-03-2010, 10:41 AM
  5. Replies: 4
    Last Post: 08-12-2010, 08:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums