Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2009
    Posts
    5

    Thumbs up birth-death automation

    hi i m doing a proj on birth - death automation....
    i m new to database so..
    can i hav id or name as primary key....

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by ARAVINTHMP
    hi i m doing a proj on birth - death automation....
    i m new to database so..
    can i hav id or name as primary key....
    If Tw Ppl Cn Hv Th Sm Nm Thn Youll Need 2 Us An Artfcl Idntfier. If Your Creatng Th Nms Yourslf Thn U Could Gt Awy Wth Nms As Th Ky. Pleas Explain Wht Th Prjct Is About

  3. #3
    Join Date
    Jun 2009
    Posts
    5

    Unhappy

    i m in a complete automation for registering of the birth and death in a locality..
    i hav certain prob, i wil list
    1.i m having id as primary key,in tat i hav given evey individual wit an id.ther arise a case tat either father or mother hadnt registered their birth and dont hav id..
    2.in case of issuing death certificate for persons who hadnt registered their birth..

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    1) Couldn't you just create artificial ids for those missing an id ie TEMP000001 etc. Then have some process to assign real ids to those with temporary ids - presumably done by an existing organisation. You'd have to be very careful of people not creating fake ids this way.

    2) Same as above or if you're feeling like making your system wildly efficient you could just delete the person from the database altogether

  5. #5
    Join Date
    Jun 2009
    Posts
    5
    cool..
    shall i keep the date and register no as prim key becoz v hav to reset the regis no for every yr...

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by ARAVINTHMP
    hi i m doing a proj on birth - death automation....
    Check out the movies "Soylent Green" and "Logan's Run" for some tips.
    Last edited by blindman; 06-26-09 at 12:18.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •