Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
5
Newest
 Student
Impact
~182 people reached

  • 0 posts edited
  • 0 helpful flags
  • 25 votes cast
Oct
16
awarded  Student
Oct
16
awarded  Scholar
Oct
16
comment Duplicate check constraint on multiple tables?
Your answer helped. btw, you have duplicate answers. shouldn't you use edit on the answer?
Oct
16
accepted Duplicate check constraint on multiple tables?
Oct
16
revised Duplicate check constraint on multiple tables?
added 74 characters in body
Oct
16
asked Duplicate check constraint on multiple tables?
Oct
9
comment Foreign keys - link using surrogate or natural key?
I have one little question, does lookup table naturally needed to contain natural key only, with that single column?
Oct
7
comment Foreign key to a subset of rows?
Thanks I was interested to know whether or not this type of constraints can be enforced without trigger or checkss. Thanks
Oct
7
comment Foreign key to a subset of rows?
@MDCCL, Thanks for your reply. I have added more description and clarified the question. also added a diagram
Oct
7
revised Foreign key to a subset of rows?
added 459 characters in body
Oct
6
awarded  Editor
Oct
6
comment Foreign key to a subset of rows?
for design. how to store which courses are eligible for each term.
Oct
6
revised Foreign key to a subset of rows?
added 112 characters in body
Oct
6
asked Foreign key to a subset of rows?
Sep
13
asked Database design advice on a marksheet schema
Dec
30
awarded  Supporter
Nov
15
awarded  Autobiographer