Create a database named "Shopping".

Create a table called Customers that contains five columns, using suitable datatype :

CustomerID$($Id$).$ "Primary Key"

CustomerName$($Name$).$

CustomerMobile$($Mobile$).$ "Not null"

CustomerAddress$($Address$).$

OrderNumber$($Number$).$ "Foreign Key"

Create a table called Products that contains four columns, using suitable datatype:

ProductID$($Id$).$ "Primary Key"

ProductName$($Name$).$ "Not null"

ProductPrice$($Price$).$

CustomerID$($Id$).$ "Foreign key"

Create a table called Orders that contains two columns, using suitable datatype:

OrderNumber$($Number$).$ "Primary Key"

CustomerID$($Id$).$ "Foreign Key"

Table: customers

Columns:

CustomeriD

Customertame

CustomentMoble

CustomerAddress

Ordertiumber

int $9x.$ varchar $(15)$

chart $20$

char$(2)$

Table: products

Columns:

ProductiD

Producttlame

Productence

CustomertD

char$(1)$ PK

varchar$(30)$ decrat $10,2$