Question: Suppose you have 2 data tables. One is the students data table where the columns are student _ id , first _ name, last _

Suppose you have 2 data tables. One is the students data table where the columns are student_id, first_name, last_name, date_of_birth, and advisor_ The second table is the advisors table where the columns are advisor_id, advisor_first_name, advisor_last_name, and advisor_phone. You want to combine the two tables.
What would be the secondary key in the advisors table to link to the student table?
a. last_name
b. advisor_id
c. student_id
d.advisor_name
Suppose you have 2 data tables. One is the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!