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

Primary Key:

A primary is a column in the table which uniquely identifies a row. Every table has a single primary key. A primary key has a more than one columns of a table. PK refers to the primary key in the given figure.

Foreign Key:

A foreign key is a set of columns in a table, which points to the primary key of another or in the sample table that must contains a unique feature.

Connect the tables in the figure using foreign and primary keys are as follows:

Facebook table has a primary key of FaceBook_ID

So, connect two tables Facebook and Facebook_Messages using the primary key and foreign key is FaceBook_Id

For Google+ table has the primary key of Google_ID which connects with the foreign key of the Google_ID in the table Google+Circles.

For Linkedln have a primary key Linkedln_ID and a foreign key of Linkedln_ID in the table Linkedln_Messages.

So, in the Twitter table primary key is the Twitter_ID is connect with the foreign key of the Twitter_Id in the another tables called Re_Tweets. Where Tweets table has a primary key of Tweet_ID is connected with the foreign key Tweet_Id in the Re_Tweets table.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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