You have been provided with the following UML conceptual model for Happy Thought

Question

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 WKP’s 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:

Explanation / Answer

If you have any doubts, please give me comment...

Inventory:
ItemID, Description, Stanadard_unit_cost

Purchases:
ReceivingReport#, Date, DistributorID, DisbursmentID, DisbursmentAmount

Stockflow1:
ItemID, ReceivingReport#, Actual_unit_cost, Quantity_purchased

Cash:
cashAccount#, accountType, Location

CashDisbursment:
DisbursementID, Date, TotalAmount, cash_account#, DistributorID

Distributor:
DistributorID, Name, QuantityRating

Note:

Underline indicates primary key

Italic indicates foreign key

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.