mySQL help!

1. Write SQL scripts for Creating Tables with Identify Primary and Foreign Keys based on structure given below 2. Write SQL script for creating index on product name Customer CustomertD INT NOt NULL Auto Increment Not NULL Auto Increment Name Address1 Varchar(50) Not Null Address2Varchar(50)1Null CityVarchar(20) Not Null Varchar(50) Not NULL - State Varchar(2) Not Null Product ProductID Int Not Null Auto Increment Name Varchar(20) Not Null QtyInHand Int Not Nul Orders OrderID Int Not Null Auto Increment Orderoty nt Not Null ProductID Int CustomerID Int ShippingDetails ShippingID Int Not Null Auto Increment ON Date Null ReceivedOn Date Not Null OrderID Int