Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Should I create a ID column for the Briding table or not?

Posted on 2011-10-11
2
Medium Priority
?
210 Views
Last Modified: 2012-06-27
I am creating a Briding table between two tables with a many-to-many relationship.

The columns which I am including are:

ID from table 1.
ID from table 2.

Should I create a ID column for the Briding table or not?
0
Comment
Question by:Mr_Shaw
2 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 2000 total points
ID: 36948031
no need of ID column for the Briding table

as  ID from table 1 and ID from table 2 will work as primary key
0
 

Author Closing Comment

by:Mr_Shaw
ID: 36948080
thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

564 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