Consider the following description of an enterprise. An auction Web site has items for sale that...

Consider the following description of an enterprise.

An auction Web site has items for sale that are provided by sellers. Each item has an opening price, a description, and ending time. Customers submit bids. The highest earliest bid submitted before the ending time is the winning bid and the item is sold to the bidder. Each seller must pay 5% of the winning bid. The auction company wants to be able to analyze the sales behavior of its customers and sellers and so must keep track of all bids and sales.

What entity classes are mentioned in the description?
List seven attributes that will be used in a data model for the auction company.
What relationship types exist between the entity classes of part a?
Give three example entities of each class listed in part a.

Expert Solution

Please find the answers below.

For (a) and (d), look at the first one.

For (a) only side headings like buyer, seller,i tem etc.,
For (d) each class has entities like description, closing price. etc.,

venereology answered 1 month ago

Consider the online auction site described in Problem 2.31 (Chapter 2, Page no 165). Suppose you...

Consider the online auction site described in Problem 2.31 (Chapter 2, Page no 165). Suppose you want to employ the Publish-Subscribe (also known as Observer) design pattern in your design solution for Problem 2.31. Which classes should implement the Publisher interface? Which classes should implement the Subscriber interface? Explain your answer. (Note: You can introduce new classes or additional methods on the existing classes if you feel it necessary for solution.).

Consider the following description below: A furniture company produces several products for sale. Each product (described...

Consider the following description below: A furniture company produces several products for sale. Each product (described by Product ID, name and price) is made up of one or more components (described by Component ID and name). A component can be used in one or more products. A component can be a simple component or compound component. A compound component is one that contains one or more other components (which can be simple or compound components). A simple component is indivisible,...

An online poll at a popular web site asked the following: A nationwide ban of the...

An online poll at a popular web site asked the following: A nationwide ban of the diet supplement ephedra went into effect recently. The herbal stimulant has been linked to 155 deaths and many more heart attacks and strokes. Ephedra manufacturer NVE Pharmaceuticals, claiming that the FDA lacked proof that ephedra is dangerous if used as directed, was denied a temporary restraining order on the ban yesterday by a federal judge. Do you think that ephedra should continue to be...

Question 6. There are two bidders in a sealed-bid, second-price auction. The object for sale has...

Question 6. There are two bidders in a sealed-bid, second-price auction. The object for sale has a common value. Each bidder, i = 1,2, receives a signal i that is independently and uniformly distributed on the interval [0, 1]. The true value of the object, v, is the average of the two signals, v = (σ1 + σ2) / 2 (a) If bidder 1 gets the signal σ = 0.7, how much does he think the object is worth? (b)...

Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you. a recent OM...

Boreki Enterprise has the following 10 items in inventory. Theodore Boreki asks you. a recent OM graduate, to divide these items into ABC classifications. Fill in the blanks and then answer the following questions. (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item Annual Demand Cost/Unit Dollar Volume % of Total Dollar Volume A2 500 300 ◻ ◻ B8 4000 12 48,000 7.02 C7 1500 45 67,500 9.87 D1 20...

The Oklahoma City Zoo has proposed adding to their Web site amajor segment providing a...

The Oklahoma City Zoo has proposed adding to their Web site a major segment providing a virtual tour of the grounds and animals, suitable for both routine enjoyment and educational purposes in class rooms. Survey data indicate that this will have either a neutral or positive effect upon actual zoo attendance. The Web site will be professionally done and have an initial cost of $325,000. Upkeep, refreshing the videos, and developing videos for scientific research and entertainment will cost another...

When browsing a web site, we see the following message. What does it mean that the...

When browsing a web site, we see the following message. What does it mean that the certificate is not issued by a trusted CA? What is considered as a trusted CA? There is a problem with this website’s security certificate. The security certificate presented by this website was not issued by a trusted certificate authority.

Visit the web site of one of the following government agencies: • Federal Drug Administration Search...

Visit the web site of one of the following government agencies: • Federal Drug Administration Search the site for information about the agency’s standards related to information security. Study the information you find and draw some conclusions about it. How are the regulations presented? How easily can businesses access and follow these regulations? Summarize your findings in a brief report (06 - 08 pages)

The PCAOB web site has a section titled “Settled Disciplinary Orders”. Locate the findings involving Kent...

The PCAOB web site has a section titled “Settled Disciplinary Orders”. Locate the findings involving Kent M. Bowman, CPA, of Salt Lake City, Utah, involving the audit of Active Care, Inc. A. Describe the situations and accounting/audit issues that led to the disciplinary action by the PCAOB. B. There was an issue related to an audit confirmation sent to a customer of the client in this case. Please describe the issue and how the Bowman’s audit team handled or responded...

ASSIGNMENTS 1. POSTING (5 pts) Visit the following web site to view some fractures from the...

ASSIGNMENTS 1. POSTING (5 pts) Visit the following web site to view some fractures from the outside and also through x-ray: http://www.surviveoutdoors.com/emergency/fractures.asp Post a message describing what you thought of the web site in the message center:

Question