Nice Lawn Sales Narrative
Nice Lawn sells lawn ornaments online to other businesses. Nice Lawn customers place an online order. Nice Lawn processes the customer order by verifying with the accounting department that the customer's credit is in good standing with the company (the customer's account is paid on time). The items are verified for availability. Shipping is authorized. The warehouse packages the items and sends them to the customer. The warehouse notifies the accounting department the items were shipped. An invoice is generated from the sales information and emailed to the customer.
-What are the datastores (database tables)in the Nice Lawn Sales Narrative?

Question

Quizplus · Accepted Answer

The narrative mentions customers placing online orders, which would require a Customer table to store the customer information. The items being processed and shipped would require an Item table to store the inventory. The order processing and invoicing would require a Sales Order table and Sales Order Line table to store information about each order, and an Invoice table to store information about each invoice. The Vendor table and Price table are not mentioned in the narrative as necessary datastores.