Case 1 -2 Green Thumb Nursery Is Analyzing Wholesale Customer Purchases and Would

question 18

Short Answer

Case 1 -2
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:

Market Yield

The annual income return as a percentage of the market price of an investment.

Zero-Coupon Bond

A type of bond that does not pay interest during its life but is sold at a deep discount, providing profit at maturity when it is redeemed for its face value.

Matures

The point at which a financial instrument, such as a bond or loan, reaches its due date and the principal is to be paid back.

Yield-To-Maturity

The total return anticipated on a bond if the bond is held until its maturity date, considering all interest payments and the principal repayment.