locked
Database for Resume information RRS feed

  • Question

  • Hi All,

      I am designing a database in sqlServer 2008. The database is for a webapplication that allows a user to log in and fill in his personal Experience, schools he attended, languages tests he has taken ... and so forth.

    As I was designing I noticed that I have many tables such as (Experience table, schools table, languages table) and all those tables are referencing one table in my database which is User. Since the user table contains the primary ID of the person who is actually logging in to the website and filling the information.

    When many child tables reference one table in the database, is this considered a good design. I am talking about One user table and 10 or 15 tables referencing the primary key in that user table.

     

    Please advise...  

    Wednesday, October 19, 2011 7:14 AM

Answers

  • I don't see any bad design in what you've described.

    At least you've normalized your tables and your are keeping relevant things separately by referencing them to the user entity.

     

    Can you post the design of user tables with some other related tables?


    ~manoj | email: http://scr.im/m22g
    http://sqlwithmanoj.wordpress.com
    MCCA 2011
    • Marked as answer by Stephanie Lv Wednesday, October 26, 2011 9:42 AM
    Wednesday, October 19, 2011 8:43 AM

All replies

  • I don't see any bad design in what you've described.

    At least you've normalized your tables and your are keeping relevant things separately by referencing them to the user entity.

     

    Can you post the design of user tables with some other related tables?


    ~manoj | email: http://scr.im/m22g
    http://sqlwithmanoj.wordpress.com
    MCCA 2011
    • Marked as answer by Stephanie Lv Wednesday, October 26, 2011 9:42 AM
    Wednesday, October 19, 2011 8:43 AM
  • Hi

    your design is normal to me and nothing happens when you have foreign keys to one table from many. you are doing good.


    Regards Ahmad
    Thursday, October 20, 2011 5:59 AM