The sales database contains a customer table and an order table. For each order there is one and only one customer, and for each customer there can be zero or more orders. How should primary and foreign key fields be placed into the design of this database?
Correct Answer: A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the customer_id field in the order table
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More ASP.NET With SQL Server MCQ Questions