Question

NEED ANSWER ASAP

Lance has three tables in his database. He wants to generate a report to show data from the three tables. So, 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

INT is not correct

Step-by-step explanation:

Answer 2

Lance must or probably use INT type of field to create relationships. INT is the term used in MySQL. To link the three tables, Lance has to identify an ID in his tables. These fields must be set to PRIMARY KEY so the other tables can refer to this field. Commonly, INT type of field is used for Primary keys in the Database.