Question

Lance has three tables in his database. He wants to generate a report to show data from the three tables. Therefore, he decides to link the tables. What type of fields will help Lance to create the relationships? Lance will have to identify the _____ in his tables to help him link the tables.

Answer 1

this is your correct answer

Answer 2

"If Lance has three tables in his database, he can easily generate the report with the help of these tables. Generating the link to combine the three tables will help lance to create the relationship, and it is possible through the below method:

Among the three tables available, two tables should have foreign keys and that keys should get linked to the remaining one table. By this way, the report for the table can be easily generated."