Product

The Product table contains data regarding each of Xtreme Mountain Bikes' products.

Table B-8: Product data

Field Name	Data Type	Length	Description
Product ID	Number	Long Integer	Unique identification number assigned to each product.
Product Name	Text	50	Name of the product.
Color	Text	20	Color of the product.
Size	Text	10	Size of the product.
M/F	Text	10	States whether product is for men or women specifically.
Price (SRP)	Currency	Currency	The price of the product.
Product Type ID	Number	Long Integer	Unique identification number assigned to each product type.
Product Class	Text	50	The product class.
Supplier ID	Number	Long Integer	Unique identification number assigned to each product supplier.