+1 vote
in Class 12 by kratos

Consider the table given below :

Salesperson

| Salesperson | Name | Age | Salary |
| 1 | Ajay | 61 | 140000 |
| 2 | Sunil | 34 | 44000 |
| 3 | Chris | 34 | 40000 |
| 4 | Amaaya | 41 | 52000 |

Orders

| Orders | SalespersonID | Amount |
| 10 | 2 | 54000 |
| 20 | 7 | 18000 |

(i) The column in the "Salesperson"

table is the ................. KEY. The SalespersonId column in the "Orders" table is a .................. KEY.

(ii) Can the 'Salespersonld' be set as the primary key in table 'Orders'. Give reason.

1 Answer

+4 votes
by kratos
 
Best answer

(i) Primary, Foreign

(ii) No, as it may be repeated in Orders table.

...