113 reputation
6
bio website
location Charlotte, NC
age 27
visits member for 2 years, 7 months
seen Aug 21 at 19:34

My twin brother and I have a CD; you can check it out on

Let us know what you think about it on our Facebook page!


I find very few things in life serious enough to take all that seriously =)


I have an Amazon wishlist.


Jun
9
awarded  Popular Question
Mar
30
comment Do I need a separate Id column for this “mapping” table?
@ypercube Thanks for clarifying that. I can see how that would be more clear. And, as Aaron said, it would be consistent across all tables (which is nice).
Mar
30
awarded  Scholar
Mar
30
accepted Do I need a separate Id column for this “mapping” table?
Mar
30
comment Do I need a separate Id column for this “mapping” table?
+1, thanks! Question regarding your last paragraph: I thought it was bad practice to include the name of the table before the column name (Products.ProductId, rather than just using Products.Id). Am I wrong (or perhaps confused) about that?
Mar
30
comment Do I need a separate Id column for this “mapping” table?
"you wouldn't need to have an additional key, as the combination of ProductId/ProducerId would ultimately be unique" - Ah, that makes sense! Exactly what I was wondering about.
Mar
30
awarded  Editor
Mar
30
revised Do I need a separate Id column for this “mapping” table?
Clarified the many-to-many confusion I created.
Mar
30
comment Do I need a separate Id column for this “mapping” table?
Ah, I did not make that clear. Yes, there is the relationship would be (I think) many to many. A product could be produced by more than one producer, and a producer and can carry multiple products.
Mar
30
awarded  Student
Mar
30
asked Do I need a separate Id column for this “mapping” table?
Mar
8
awarded  Supporter
Jan
25
comment Could Stack Overflow run on SQL Server Web Edition?
Possibly check out this SO podcast which discusses some of their scaling problems.
Jan
25
awarded  Autobiographer