Question regarding Database Design

Posted on 2011-05-05
Last Modified: 2012-05-11
I have two tables a UserInfo table that stores user specific information and a TransactionResponse table that holds the transaction response information. Both these tables have a requestID that is common to both tables. What would be the most optimum way to design the said database.

Question by:pmac38CDS
    LVL 29

    Expert Comment

    by:Paul Jackson
    Is the requestID the primary unique value for either table?
    Is the requestID the primary unique value for any other table in the database?
    LVL 1

    Author Comment

    No it is not a primary key for any of the tables.
    LVL 29

    Expert Comment

    by:Paul Jackson
    Are you likely to be querying the database tables using the RequestId in the where clause?
    LVL 29

    Accepted Solution

    I would have 3 tables

    UserInfo Table
    UserInfoId PK

    TransactionResponse Table
    TransactionResponseId PK

    Request Table
    RequestId PK
    UserInfoId FK
    TransactionResponseId FK

    This will fulfill the requirements of normalisation by removing duplicate data from tables.
    LVL 1

    Author Closing Comment

    That is exactly what I was thinking. Having a mapping table that would link the two tables. Thanks for your help.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now