O'Reilly logo

Active Server Pages 3.0 from Scratch by Nicholas Chase

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required