sql – Can There be a Table in a Relational Database that Doesnt Have a Relationship to Any Other Table?

sql – Can There be a Table in a Relational Database that Doesnt Have a Relationship to Any Other Table?

Yes you can. The only thing that could happen is that those table wouldnt have a relationship to other table. i would not say that this is the best way to go, because all depend in your situation. And, like the answer says: It can still be given a relationship later.

Either Im misreading your question, or there actually is a relationship between NewKeyWords and KeyWordsForPost. Its a value (Keyword) thats common to both tables, and could be used for a relational join. That might be a stupid join that no one would want to do, it might be real slow, for lack of a relevant index, and the keywords arent a declared key anywhere, but its still a relationship.

The relationship is inherent in the data, whether you have declared it or not.

sql – Can There be a Table in a Relational Database that Doesnt Have a Relationship to Any Other Table?

I am going to take @rlartiga s approach guys. I am going to create a Keywords table with the column Keyword and have it as the primary key. Then I am going to have both KeywordsForPost and NewKeywords tables refer to Keyword in Keywords. Thanks for your support guys! Comment if you think this is not the appropriate move.