create theShoppertable with appropriate data types for the attributes described below.

Column Name Constraints DESCRIPTION

Shopperid PRIMARY KEY Unique id of the shopper. For ex. 2001, 2003

Shopper NameNOT NULLName of the Shopper. It cannot be more than 20 characters.

Gendershould be only 'Male' or 'Female'Gender of the Shopper. It cannot be more than 6 characters.

MobileNo NOT NULL Mobile number of the Shopper in numeric form. Characters like brackets and hyphens are not allowed.

AddressAddress of the Shopper. It cannot be more than 50 characters. For ex. Allen Street, New York