SQL Help:

1. Create table PARENT which contains three fields, Field1, Field2, and Field3 with data types of your choosing, one of which must be numeric. Define the primary key at the column level. Include two constraints of different types, also defined at the column level. Name all constraints using the class naming convention. Create the constraints in the same command when the table is being created. Do NOT create the table in one command, and later add the constraints.

2. Create table CHILD which contains three fields, FieldA, FieldB, and FieldC with data types of your choosing. Define the primary key at the table level. Include two constraints of different types which are different from the constraints in the previous problem. All constraints are to be defined at the table level. Name all constraints using the class naming convention. Create the constraints in the same command when the table is being created. Do not create the table in one command, and later add the constraints.

3. Create a view based on the ORDERS table which displays the customer#, order#, order date, and shipping date for all unshipped orders (the ship date is null). The name of the order date column will be ORDER_DATE (without quotes). The user should be able to update the order date column but not the ship date column.

4.