I’m working on a Accounting exercise and need support.

I’m having trouble with this homework assignment.

Design a relational database to capture information needed by business processes

Your company sells minifigures (e.g., iron man, like the one here). There are more than 3,000 different minifigures listed on your product page. Because there are so many different minifigures, you categorize them into 25 different groups, such as Marvel, Star Wars, Harry Potter, etc. Your company purchases these minifigures from 5 different contracted suppliers (or vendors). Since each supplier can provide any of the product needed, the company does not need to worry about back orders or the risk of out-of-stock. Depending on the shipping arrangements, the suppliers may or may not combine multiple purchases into one shipment. Last, given the number of purchase transactions with these suppliers, to avoid confusion for reconciliation, the company makes one payment for each purchase.

• (1)Draw a UML class diagram based on the operational processes provided above.
• (2)For the UML class diagram, you need to specify how many tables are needed. In addition, for each class and linking table in the UML class diagram, you need to (1) clearly identify the primary key, (2) clearly identify the foreign key, if any, (3) give at least 2 attributes other than the primary key and the foreign key for classes, and (4) give at least 1 attribute other than the primary key and the foreign key for “linking tables” for the many to many relationship, if needed. Explain each multiplicity clearly.