You have been provided with the following UML conceptual model for Happy Thoughts Gift Shop (HTGS) below. Although, this model is incomplete it contains enough entities and relationships to give you valuable practice at a creating logical. Do NOT add any additional entities, relationships, or attributes to the model.

Additional Information: HTGS eventually pays for nearly all (99%) of its purchases; only very rarely does HTGS return merchandise to a distributor.

HTGS hires a payroll specialty firm (WKP, which stands for We Know Payroll) to handle writing paychecks to employees. Thus HTGS writes one check per month to WKP to cover the employees gross pay plus WKPs processing fees. Occasionally HTGS also writes checks for other things such as loan re-payments and general and administrative service acquisitions; however, most of its cash disbursements (approximately 85 out of every 100 checks) apply to purchases of inventory from distributors.

Required: Convert the conceptual model into a logical level model using the relational model. That is, prepare relational table structures on paper using the following format:

TABLE NAME:

Primary key (PK)

Attribute 1

Attribute 2

Attribute3

Foreign key (FK)

Inventory Purchases Item ID (PK) - Description -Standard unit cost -Receiving report # (PK) - Date Stockflow1 Actual unit cost Quantity purchased Participation1 Distributor Duali amount applied to purchase -Distributor ID (PK) - Name Quality rating 0..1 0..1 1..1 Cash Cash Disbursement Stockflow2 Participation2 -Cash account # (PK) Account type - Location - Disbursement ID (PK) - Date - Total amount