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

question 59

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.Which data type is best for the field that will contain the customer's street address?

---

Definitions:

Software

A set of instructions, data, or programs used to operate computers and execute specific tasks.

Interface

Refers to the point of interaction between two systems, devices, or programs, often allowing them to communicate or work together.

Data

Information that is collected, stored, and used for analysis or processed to inform decisions, often structured in digital form.

Information

A data that is processed, organized, and structured or presented in a given context to make it meaningful.