can anyone help me with this question
thanks
Introduction
The Hammer family run a small auction business. Mike is the auctioneer; Mary
the accountant and
manager; and Tom and Terry look after the day-to-day operations of the
business.
They specialise in motor vehicle (MV), antique (AN), and business
liquidation (BL) auctions, and
their clients include charities, government departments, and accountant /
lawyer / receivers.
The Auction Business Process
The following details outline the important activities involved in the
Hammer's auction business.
Before auction day...
An auction event is added to their list when a client rings and books them
for a particular date. Apart
from the client's name, Mary needs to know details such as:
· the date of the auction,
· the location of the auction, and
· type of auction (the three types of auctions have their own, different
conditions and commissions)
Sometime before the auction day Tom, Terry and a representative from the
client's organisation take
inventory of all the goods. All items are allocated a lot number, which is
recorded along with the:
· item description
· owner
· reserve price.
Additionally, if the item is:
· a motor vehicle - the VIN number and car's mileage are also recorded.
· electrical or photographic equipment - the serial number and year of
manufacture are also
recorded,
· a computer - the CPU type, amount of RAM and disk size are also recorded.
On auction day...
All people who intend to bid at the auction must first register. Details
such as the bidder's:
· name,
· address,
· contact phone number,
· business name (if representing a business),
· how they found out about the auction (choice of: newspaper advertisement,
trade publication,
word-of-mouth)
are recorded, and a unique registration number is printed on a piece of
paper and given to the
attendee.
Mike has a list of all the items to be auctioned, ordered by lot number and
with details of the item's
description and reserve price. All items are auctioned one item at a time,
with the sale being made to
the highest bidder. At the time of sale Mike records on his listing the
registration number of the
highest bidder and the relevant item's sale price. If an item does not reach
reserve price then it is
"passed in" (not sold). The completed list is then given to Mary who handles
payments.
Winning bidders cannot take possession of their items until they have been
paid for. Payment is
made to Mary by either cash or bank cheque, and she prints out an itemised
receipt - showing details
of all the goods purchased at the auction, individual prices, and the total
price paid.
The receipt can then be given to either Tom or Terry, who give the listed
items to the successful
bidder. To avoid any confusion over delivery of goods, the following details
are recorded at the time
of hand-over:
· the receipt number,
· the items,
· the time.
A delivery note with these details is then printed, which is signed by the
successful bidder upon
receiving the goods. Tom or Terry also sign the bidder's receipt to indicate
that the goods have been
collected.
Payment and collection of goods must be made on the day of the auction.
After auction day....
Sometime after the auction (usually the next business day) a complete
listing of all items sold, paid
for and delivered is made - showing the lot number, item description and
sale price. A listing of all
items not sold at the auction is also made, and both lists are taken to the
client where final payment is
handed over - less the Hammer's commission!
Requirements
Draw an extended entity relationship diagram to model the above.
Include any assumptions you have made and any rationale you used when making
modeling choices.
Received on Wed Sep 12 2001 - 02:56:03 CDT
