Create the tables and appropriate constraints based on the following ER diagram.
Use appropriate data types. Note that the product category column should only accept S, M, or L
and the product description should be unique. In addition the quantity and price columns should
have values greater than zero. Make the cid in the customers table an identity column. All
columns are required.

 

Customers cid (pk)* cname cemail *identity attribute Orders oid (pk) odate cid (fk) productid (fk) quantity Products pid (pk) description category(S/M/L) price