Saved Bookmarks
| 1. |
Consider the tables given below.SalespersonOthers(i) The Salespersonld column in the “Salesperson” table is the .... KEY. The Salespersonld column in the “Orders” table is a ..... KEY.(ii) Can the ‘Salespersonld’ be set as the primary key in table ‘Orders’. Give reason. |
|
Answer» (i) Primary, Foreign (ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column. |
|