Question

In: Computer Science

Consider an ONLINE_AUCTION database system in which members (buyers and sellers) participate in the sale of...

Consider an ONLINE_AUCTION database system in which members (buyers and sellers) participate in the sale of items. Design an ER/EER diagram for this ONLINE_AUCTION database. The data requirements for this system are summarized as follows:
• The online site has members, each of whom is identified by a unique member number and is described by an e-mail address, name, password, home address, and phone number.
• A member may be a buyer or a seller. A buyer has a shipping address recorded in the database. A seller has a bank account number and routing number recorded in the database.
• Items are placed by a seller for sale and are identified by a unique item number assigned by the system. Items are also described by an item title, a description, starting bid price, bidding increment, the start date of the auction, and the end date of the auction.
• Items are also categorized based on a fixed classification hierarchy (for example, a modem may be classified as COMPUTER → HARDWARE → MODEM).
• Buyers make bids for items they are interested in. Bid price and time of bid is recorded. The bidder at the end of the auction with the highest bid price is declared the winner and a transaction between buyer and seller may then proceed.
• The buyer and seller may record feedback regarding their completed transactions. Feedback contains a rating of the other party participating in the transaction (1–10) and a comment.

Solutions

Expert Solution


Related Solutions

Consider a market in which there are many potential buyers and sellers of used cars. Each...
Consider a market in which there are many potential buyers and sellers of used cars. Each potential seller has one car, which is either of high quality (a plum) or low quality (a lemon). A seller with a low-quality car is willing to sell it for $4,500, whereas a seller with a high-quality car is willing to sell it for $8,500. A buyer is willing to pay $5,500 for a low-quality car and $10,500 for a high-quality car. Of course,...
Consider a market for used cars. There are 100 sellers and 100 buyers. The sellers know...
Consider a market for used cars. There are 100 sellers and 100 buyers. The sellers know the qualities of their cars, but the buyers only know that the quality θ of each used card is uniformly distributed over interval [0, 1]. The seller’s value of a car with quality θ is θ. (Thus, market supply is S(p) = 100p for 0 ≤ p ≤ 1 and S(p) = 100 for p > 1.) Each of 50 buyers values a car...
Consider a market with 22 sellers and 21 buyers. Of 22 sellers, there are 15 "high-cost"...
Consider a market with 22 sellers and 21 buyers. Of 22 sellers, there are 15 "high-cost" sellers with production costs of $30 per unit and 7 "low-cost" sellers  with costs of $10 per unit.  Of 21 buyers, there are 14 "high-value" buyers with values of $40 per unit and 7 "low-value"   with values of $20 per unit.  For this market, identify and graph the demand and supply curves. Finally, predict the equilibrium price and quantity in the market.
Consider a market for used cars. There are many sellers and even more buyers. A seller...
Consider a market for used cars. There are many sellers and even more buyers. A seller values a high quality car at 800 and a low quality car at 200. For any quality, the value to buyers is m times the value to sellers, where m > 1. All agents are risk-neutral. Sellers know the quality of their own car, but buyers only know that 2/3 of the cars are low quality and the remaining 1/3 of them are high...
Which of the following are characteristics of a perfectly free economy? A. All buyers and sellers...
Which of the following are characteristics of a perfectly free economy? A. All buyers and sellers can freely and immediately enter or leave the market. B. There are numerous buyers and sellers, none of whom has a substantial share of the market. C. Every buyer and seller has full and perfect knowledge of what every other buyer and seller is doing, including knowledge of the prices, quantities, and quality of all goods being bought and sold. D. All of the...
Consider a pricing problem with two sellers, A and B, and 12 buyers, who each have...
Consider a pricing problem with two sellers, A and B, and 12 buyers, who each have a unit demand for a good provided the price is no more than 4. Each seller can produce a good on order at price 1. Sellers announce prices simultaneously, pA and pB respectively. Buyers 1-6 see Player A's price but not Player B's. Likewise buyers 7-12 see Player B's price but not Player A's.Each buyer can choose to buy from the seller whose price...
For a market to be competitive, why is it important that there be buyers and sellers...
For a market to be competitive, why is it important that there be buyers and sellers and easy entry and exit?
Consider a local used car market with an unlimited number of buyers, 50 sellers of high-quality...
Consider a local used car market with an unlimited number of buyers, 50 sellers of high-quality cars, 30 sellers of medium-quality cars and 20 sellers of low-quality cars. Each seller offers up to 1 car for sale. Sellers of high-quality cars value their car at $15,000, sellers of medium-quality cars at $7,000, and sellers of low-quality cars at $3,000. Buyers value high-quality cars at $20,000, medium-quality cars at $10,000, and low-quality cars at $5,000. Answer the following questions according to...
Consider a market with 30 sellers and 30 buyers. Of 30 sellers, there are 10 ”high-cost” sellers with production costs of $25 per unit and 20 ”low-cost” sellers with costs of $5 per unit.
Consider a market with 30 sellers and 30 buyers. Of 30 sellers, there are 10 ”high-cost” sellers with production costs of $25 per unit and 20 ”low-cost” sellers with costs of $5 per unit. Of 30 buyers, there are 15 ”high-value” buyers with values of $30 per unit and 15 ”low-value” buyers with values of $10 per unit.a.) Identify the demand schedule for this market.b.) Identify the supply schedule for this market.c.) Graph the demand and supply schedules for this...
Buyers and sellers of securities for themselves in the money markets are called:
Buyers and sellers of securities for themselves in the money markets are called:
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT