Let the description help you answer the questions in the attached word document.

 

Use the following descriptions of the operations of Mac-Carthy Company to complete thishomework.Mac-Carthy Company 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 notcurrently available, it is placed on back order at the customer’s discretion. (Back orders are notcharged to a customer until the order is shipped.) When a customer completes a transaction, theinvoice 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 shippingcontainer. The customer credit card charges are transmitted to the CC Bank, at which Mac-Carthy Company maintains a commercial account.Mac-Carthy Company tracks customer purchases and periodically sends out promotionalmaterials. Because the management at Mac-Carthy Company requires detailed information toconduct its operations, numerous reports are available. Those reports include, but are not limitedto, customer purchases by product category and amount, product turnover, and revenues byproduct and customer. If a product has not recorded a sale within four weeks of being stocked, itis removed from inventory and scrapped.Many of the customers on the Mac-Carthy customer list have bought Mac-Carthy products.However, Mac-Carthy Company also has purchased a copy of theFineScale Modelermagazinesubscription list to use in marketing its products to customers who have not yet bought fromMac-Carthy Company. In addition, customer data are recorded when potential customers requestproduct information.Mac-Carthy Company orders its products directly from the manufacturers. For example, theplastic models are ordered from Tamiya, Academy, Revell/Monogram, and others. Decals areordered from Aeromaster, Tauro, WaterMark, and others. (Note:Not all manufacturers in theMac-Carthy Company database have received orders.) All orders are placed via themanufacturers’ Web sites, and the order amounts are automatically handled through RC_Models’commercial bank account with the CC Bank. Orders are automatically placed when productinventory reaches the specified minimum quantity on hand. (The number of product unitsordered 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.

Attachments:

• 1495510657-Grading Rubric.docx