Microsoft
98-364 · Question #73
You work as a Database Designer for Realtech Inc. You want to create two tables, Product and Order, such that a row in the Order table does not exist without a corresponding row in the Product…
The correct answer is D. Create the Product table, and then create the Order table that has a foreign key constraint. See the full explanation below for the reasoning.
Question
You work as a Database Designer for Realtech Inc. You want to create two tables, Product and Order, such that a row in the Order table does not exist without a corresponding row in the Product table. The structure of the Product and Order tables with their respective columns is given below:
- Product
- ProductID
- ProductNumber
- Date_of_manufacturing
- SupplierID
- ProductPrice
- ProductQty
- Order
- OrderID
- OrderDate
- OrderQuantity
- OrderPrice
Based on this information, while maintaining the integrity of this rule, what will you do to accomplish the task?
Options
- ACreate the Product table, and then create the Order table.
- BCreate the Product table, and then create the Order table that has a primary key referenced
- CCreate the Product table, and then create the Order table.
- DCreate the Product table, and then create the Order table that has a foreign key constraint
How the community answered
(57 responses)- A5% (3)
- B2% (1)
- C9% (5)
- D84% (48)
Community Discussion
No community discussion yet for this question.