Building e-Commerce Sites with the .NET Framework

Product Spotlight Database Object

To implement the MyGolfGear.NET product spotlight feature, we added three new database objects. Specifically, we added a new table called FeaturedItems. Additionally, we added the two new stored procedures spInsertFeaturedItem and spGetFeaturedItems.

The FeaturedItems Table

The new MyGolfGear table named FeaturedItems was added. This simple table has only four columns: FeatureID, ProductID, StartDate, and EndDate. Table 7.1 describes the fields and types used in this table.

Note

Some sites rotate their spotlight features based on page views. We chose to rotate the MyGolfGear.NET product spotlights based on the date.

Table 7.1. The FeaturedItems Table

Field Name	Data Type	Description
FeatureID	int	An identity ...