Question: SQL QUESTIONS: A) Create table PARENT which contains three fields, Field1, Field2, and Field3 with data types of your choosing, one of which must be

SQL QUESTIONS:

A) 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.

B) 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!