Examlex

Solved

Green Thumb Nursery Is Analyzing Wholesale Customer Purchases and Would

question 15

Essay

Green Thumb Nursery is analyzing wholesale customer purchases and would like to create an Access database of wholesale customers and the wholesale prices for all of the nursery's products. When designing the database, it is necessary to determine the number of tables needed to provide the owner with the names, addresses, and contact information of the customers, as well as the product names and wholesale prices for each product. In addition, it is neccessary to know which products have been purchased by each customer. Andrea, the owner, wants to be able to print reports that show which customers bought specific products from the database. Answer the following questions related to this case.
-What is the minimum number of tables that must be created for this database?


Definitions:

EPS

Earnings Per Share represents the fraction of a firm's profits designated for each share of its common stock, serving as a financial metric.

Stock Dividend

A dividend payment made in the form of additional shares rather than a cash payout, typically to conserve the company's cash.

Capital Accounts

The accounts that show the net worth of a company or individual, including contributions from owners or partners and retained earnings.

Market Price

The current value at which an asset or service can be bought or sold in the marketplace.

Related Questions