Furniture Outlet sells both new furniture and consignment furniture items. Current-production household items that complement or are
Question:
Furniture Outlet sells both new furniture and consignment furniture items. Current-production household items that complement or are useful with the itemsare also sold. For example, the store sells dining room tables and new tablecloths. The consigned items (also keep track of the condition of the item) are purchased (date, qty, price) from both individuals (record taxID)and wholesalers (record discount percent), and the new items are purchased(date, qty, price) from distributors (record Contact person). The store’s customers include individuals, owners of bed-and-breakfast operations, and local interior designers who work with both individuals and small businesses. The consigned items are unique, although some multiple items, such as dining room chairs, may be available as a set (sets are never broken). The new items are not unique, and a new item may be reordered if it is out of stock (include reorder point. Householditems are also available in various sizes and colors (for example, a particular style of tablecloth may be available in several sizes and in a variety of colors).Other attributes include the following: (ItemID, ItemDescription, Manufacturer, Model, ItemCost, VendorName, VendorPhone, VendorEmail, VendorURL, CustomerLastName, CustomerFirstName, Street, City, State, Zip, CustomerPhone, SaleDate, RetailPrice, Tax, SaleAmount).
Draw an ERD diagram for this situation
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale