Please connect these tables primary key and foriegn key. Facebook PK FaceBook ID

Question

Please connect these tables primary key and foriegn key.

Facebook PK FaceBook ID FaceBook Details My Facebook Accounts PF My ID PF FaceBook ID Date Registered Facebook Messages PK Message ID FK FaceBook ID Date Sen Tags Message Text Other Details Google PK Google ID Google Details My Google+ Accounts PF Google ID PF y ID PK Date Registered Google Circles PK My Google ID PK Google Circle. ember ID FK Google ID FK My ID FK Date Registered Date Created Date Closed Google- Circle Details And this shows the specific Social Networks LinkedIn PK LinkedIn ID LinkedIn Details My LinkedIn Accounts PF My ID PF LinkedIn ID Date Registered LinkedIn Messages FK LinkedIn ID PK Message ID FK My ID Date Sent Message Text Other Details Data Model for Social Media Barry Williams PK y ID DatabaseAnswers.org First Name July 10th. 2012 iddle Name Last Name Gende Date of Birth Other Details Twitter Following PK Twitter ID PK Following ID Twitter Details FK Being Followed Tivitter ID FK Follower Twitter ID From Date To Date My Twitter Accounts PF My ID PF Twitter ID Date Registered

Explanation / Answer

First you need to understand that
a FOREIGN KEY in one table points to a PRIMARY KEY in another table.
According to your image:
the "FaceBook_ID" column in "Facebook" table points to the "My_ID" column in the "Me" table.
the "My_ID" column in the "Me" table is a PRIMARY KEY in the "Me" table.
the "Facebook_ID" column in "FACEBOOK" table is the FOREIGN KEY in the "FACEBOOK" table.
Similarly,
the "Google_ID" column in "Google+" table points to the "My_ID" column in the "Me" table.
the "My_ID" column in the "Me" table is a PRIMARY KEY in the "Me" table.
the "Google_ID" column in "Google+" table is the FOREIGN KEY in the "FACEBOOK" table.
Again same for
LinkedIn
the "LinkedIn_ID" column in "LinkedIn" table points to the "My_ID" column in the "Me" table.
the "My_ID" column in the "Me" table is a PRIMARY KEY in the "Me" table.
the "LinkedIn_ID" column in "LinkedIn" table is the FOREIGN KEY in the "LinkedIn" table.
Again same for
Twitter.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.