Reference no: EM131181838
Consider an ONLINE_AUCTION database system in which members (buyersand sellers) participate in the sale of items.
The data requirements for thissystem are summarized as follows:¦ The online site has members, each of whom is identified by a uniquemember 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 addressrecorded in the database.
A seller has a bank account number and routingnumber recorded in the database.¦ Items are placed by a seller for sale and are identified by a unique itemnumber assigned by the system. Items are also described by an item title, adescription, starting bid price, bidding increment, the start date of theauction, and the end date of the auction.¦ Items are also categorized based on a fixed classification hierarchy (forexample, a modem may be classified as COMPUTER?HARDWARE?MODEM).¦ Buyers make bids for items they are interested in. Bid price and time ofbid is recorded.
The bidder at the end of the auction with the highest bidprice is declared the winner and a transaction between buyer and sellermay then proceed.¦ The buyer and seller may record feedback regarding their completedtransactions.
Feedback contains a rating of the other party participatingin the transaction (1-10) and a comment.
Design an Enhanced Entity-Relationship diagram for the ONLINE_AUCTIONdatabase and build the design using a data modeling tool such as ERwin orRational Rose.
|
Explain the relationship among the variables
: The manager of Haines Company observes that the morale of employees in her company is low. She thinks that if their working conditions are improved, pay scales raised, and the vacation benefits made attractive, the morale will be boosted. List and la..
|
|
Find the accounting return on investment for a project
: Find the accounting return on investment for a project that costs $10,000.- Determine the payback period for a capital investment that costs $40,000 and has the following after-tax profits.
|
|
Optimize a multiprogrammed batch system
: Contrast the scheduling policies you might use when trying to optimize a time-sharing system with those you would use to optimize a multiprogrammed batch system.
|
|
Deliver an onsite training session
: "Prepare a script which you could use to deliver an onsite training session to teach in experienced secretaries to:
|
|
Design an enhanced entity-relationship diagram
: Design an Enhanced Entity-Relationship diagram for the ONLINE_AUCTIONdatabase and build the design using a data modeling tool such as ERwin orRational Rose.
|
|
John kotter-resistance to change
: View the video titled "John Kotter - Resistance to Change" (3 min 36 s) below. You may also view the video athttps://www.youtube.com/watch?v=Wdroj6F3VlQ. Conclude whether or not Kotter believes that all individuals who are resistant to change can ..
|
|
Discuss whether leonard had legal standing to sue globe
: Globe Life Insurance Company has undertaken a new sales program that targets neighborhoods in Los Angeles where drive-by shootings were a nightly occurrence. Two such shootings occurred in which children were killed as they sat in their living rooms...
|
|
Components of contemporary business
: What are the main components of contemporary business?
|
|
Which antenna types will become the dominant players
: A local engineering group ask you to present the merits of different antenna, such as yagi, horn, and celluar antennas. Research these technologies in details and pay specific attention to how they are used as well their strengths and weakness.
|