Using MS Visio to depict the ER diagrams for the following scenario. State any expectations you believe you have to make in order to develop a complete diagram.
Stillwater Antiques buys as well as sells one of a kind antiques of all kinds for instance furniture, jewellery, china and cloths. Each time is exclusively identified by an item number as well as it's also characterized by description, asking price and condition and open-ended comments. Stillwater works with many different individuals and called clients who sell items to and buy items from the store. Some clients only sell items to Stillwater few only buy items as well as some others both sell and buy. A client is identified by a client number as well as also described by a client name and client address. When Stillwater sells an item to a client the owners need to record the commission paid the actual selling price, sales tax and date sold. When Stillwater buys an item from a client and the owner want to record the purchase cost, date purchased and condition at the time of purchase