Sketch er diagram for buying antiques

Assignment Help Software Engineering

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.

Reference no: EM1371569

Questions Cloud

What is the spring constant : A 4 kg model rocket is launched, expelling 40.00 g of burned fuel from its exhaust at a speed of 550m/s. What is the velocity of the rocket after fuel has burned? Hint: Ignore the external forces of gravity and air resistance.

Illustrate what wage would a monopoly union demand : Illustrate what wage would a monopoly union demand Explain how many workers would be employed under union contract.

Explain the avoidance strategy : Explain The avoidance postponement, strategy, hedging, speculation, control and transferring or sharing risk

Explain annual catch exceed maximum sustainable fish catch : If average income increases from US$5,000 to US$5,500 and if technological advances reduce cost of catching fish from US$2,500 per ton to US$2,000 per ton, by ExplainING how much will annual catch exceed maximum sustainable fish catch.

Sketch er diagram for buying antiques : Sketch the ER diagram for following situation (State any assumptions you believe you have to make to develop complete diagram): Stillwater antiques buys and sells one-of-a-kind antiques of all kinds

What is the amplitude of the motion : A girl rides an escalator that moves her upward at a constant speed. As the girl rises, how do her gravitational energy and kinetic energy change.

Find the position at which a third charge : What minimum coefficient of kinetic friction is required to bring the crate to a stop over a distance of 5.0 m along the lower surface.

Importance of communicating vision in change management : What is the importance of communicating vision in change management - actual example, outline the aspects of creating and communicating a clear vision of the organizational future state to successfully implement and execute the change.

Illustrate what is natural rate of unemployment : structural unemployment of 2 percent, seasonal unemployment of 0.5 percent and cyclical unemployment of 2 percent, illustrate what is natural rate of unemployment.

User Account

All Pages