Active Server Pages 3.0 from Scratch

Auction Data Model

The first thing that we need to do is decide how we're going to store all of this information in the database. Let's look at the entities involved:

Figure 6.1. Entities for the auction section. Sellers may place for sale one or more items. Items must be placed by exactly one seller. Each item may have one or more bids, each of which must apply to one and only one item, and bidders may place one or more bids.

This entity relationship diagram (ERD) can be read like a sentence: Each seller may be selling one or more items, each of which may have one or more bids. Each bidder may place one or more bids, but each of them must ...