Examlex

Solved

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:

Formed Element

Components of blood, including red blood cells, white blood cells, and platelets, that are crucial for carrying oxygen, fighting infections, and clotting.

Formed Element

Components of blood, such as red blood cells, white blood cells, and platelets, that are either cellular or cell fragments.

Platelet

Small blood cells essential for blood clotting, which prevent excessive bleeding when blood vessels are injured.

Erythrocyte

A red blood cell that is responsible for carrying oxygen throughout the body.

Related Questions