By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,616 Members | 2,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,616 IT Pros & Developers. It's quick & easy.

Can a table be both parent and child to another table? Newsdatabase with comments

P: 1
I'm writing a school project where i have the following three tables:

users_tbl (t1), news_tbl (t2) and comments_tbl (t3).

news_tbl contains a foreign key(username) to users_tbl, and comments_tbl containes a foreign key (news_id) to news_tbl.

I'm not sure if t1 or t2 is the parent table and the two others is child tables, in case which one is it then?

Or if t1 and t2 is both parent and child tables to each other?
Dec 17 '12 #1

✓ answered by Rabbit

users is the "parent" of news. news is the "parent" of comments.

Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,359
users is the "parent" of news. news is the "parent" of comments.
Dec 17 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.