database systems design

A$)M$&$H$ is a clothing retailer that operates worldwide Each store has its own database to manage day$-$to$-$day operations. M&H has several suppliers from which it receives clothing. The company thus tracks a description of what each company supplies. the full name of their primary contact. and the company's address $($including city and postal$/$zip code$).$ Each product has a SKU. a quantity in stock, and price associated with it$.$ The products are categorized into a specific product category ranging from shirts and pants to jewelry and accessories. All suppliers stored in the system have supplied at least $1$ article of clothing. Some products are made in$-$house and thus don't come from a third$-$party supplier. When customers make a purchase, the company asks for their phone number, postal code, and records the total number of items purchased over time as well as the date of their last purchase. Each purchase transaction is also recorded including the date it was made and the employee who made the sale since the staff works on commissions.

Employee data including their individual badge number. start date, and title are stored in the system. When the purchase is made, the items that were sold are deducted from the inventory in the system.