Consider the following diagram. Which of the following best describes how the relationship between Sales Orders and Products will be implemented in the resulting database?

A. The Sales Order ID will be included as a foreign key in the Products table.
B. A new table will be created that contains both Sales Order ID and Product ID as its composite primary key.
C. The Product ID will be included as a foreign key in the Sales Orders table.
D. The Quantity Ordered field will be included as a foreign key in the Products table.


Answer: B

Business

You might also like to view...

The trade-off between ease of finding merchandise and providing a varied and interesting layout is determined by

A. how often there is a shipment from the distribution center. B. the simplicity of the merchandise. C. the needs of the customers shopping at the store. D. well-trained, design-oriented managers. E. legal requirements.

Business

The account Allowance for Uncollectible Accounts is closed at the end of the accounting period

Indicate whether the statement is true or false

Business

Shorter, simpler words or expressions make your writing look and sound _____________

a. simplistic b. juvenile c. professional d. inexperienced

Business

Summarize the provisions of SFAS No. 142 related to the definition of goodwill, impairment testing of goodwill, and the proper handling of goodwill in the event of the sale of an acquired subsidiary.

What will be an ideal response?

Business