Reference no: EM1371569

Draw an ER diagram for the following situation (State any assumptions you believe you have to make in order to develop a complete diagram): Stillwater antiques buys and sells one-of-a-kind antiques of all kinds (e.g., furniture, jewelry, china, and clothing). Each item is uniquely identified by an item number and is also characterized by a description, asking price, condition, and open-ended comments. Stillwater works with many different individuals, called clients, who sell items to and buy items from a store. Some clients only sell items to Stillwater, some only buy items, and others both buy and sell. A client is identified by a client number and is also described by a client name and address. When Stillwater sells and item in stock to a client, the owners want to record the commission paid, the actual selling price, sales tax( tax of zero identifies a tax exempt sale (is this OK?!), and date sold. When Stillwater buys an item from a client, the owners want to record the purchase cost, date purchased, and condition at time of purchase.