Reference no: EM131154038

Use the following descriptions of the operations of Mac-CarthyCompany to complete this homework.

Mac-CarthyCompany sells its products-plastic models (aircraft, ships, and cars)

Customers use their Web site to select the products and to pay by credit card. If a product is not currently available, it is placed on back order at the customer's discretion. (Back orders are not charged to a customer until the order is shipped.) When a customer completes a transaction, the invoice is printed and the products listed on the invoice are pulled from inventory for shipment. (The invoice includes a shipping charge.) The printed invoice is enclosed in the shipping container. The customer credit card charges are transmitted to the CC Bank, at which Mac-CarthyCompany maintains a commercial account.

Mac-CarthyCompany tracks customer purchases and periodically sends out promotional materials. Because the management at Mac-CarthyCompany requires detailed information to conduct its operations, numerous reports are available. Those reports include, but are not limited to, customer purchases by product category and amount, product turnover, and revenues by product and customer. If a product has not recorded a sale within four weeks of being stocked, it is removed from inventory and scrapped.

Many of the customers on the Mac-Carthycustomer list have bought Mac-Carthyproducts. However, Mac-CarthyCompany also has purchased a copy of the FineScale Modeler magazine subscription list to use in marketing its products to customers who have not yet bought from Mac-CarthyCompany. In addition, customer data are recorded when potential customers request product information.

Mac-CarthyCompany orders its products directly from the manufacturers. For example, the plastic models are ordered from Tamiya, Academy, Revell/Monogram, and others. Decals are ordered from Aeromaster, Tauro, WaterMark, and others. (Note: Not all manufacturers in the Mac-CarthyCompany database have received orders.) All orders are placed via the manufacturers' Web sites, and the order amounts are automatically handled through RC_Models' commercial bank account with the CC Bank. Orders are automatically placed when product inventory reaches the specified minimum quantity on hand. (The number of product units ordered depends on the minimum order quantity specified for each product.)

Question.

Create a fully labeled and implementable Crow's Foot ERD founded on the given scenario. You must involve all entities, relationships, and cardinalities.