pmac38CDS
asked on
Question regarding Database Design
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.
Thanks,
Aditya
Thanks,
Aditya
ASKER
No it is not a primary key for any of the tables.
Are you likely to be querying the database tables using the RequestId in the where clause?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is exactly what I was thinking. Having a mapping table that would link the two tables. Thanks for your help.
Is the requestID the primary unique value for any other table in the database?