Question

Rob creates a Product_Details table that has four columns: Product _ID, Product_Name, Category, Price and Discount. A product may have a 10% discount if it is on sale. Which field should Rob assign as a primary key in the table?
Rob should assign the field as the primary key in this table. Ok

Answer 1

It should go under the category discount