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 data tables. One is the students data table where the columns are studentid firstname, lastname, dateofbirth, and advisor The second table is the advisors table where the columns are advisorid advisorfirstname, advisorlastname, and advisorphone. You want to combine the two tables.
What would be the secondary key in the advisors table to link to the student table?
a lastname
b advisorid
c studentid
dadvisorname
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
