Solve the following DDL queries.

1.Create the following tables with all the required constraints. (Include Both table level and Column level constraints)

A) PATIENT: (PATIENT_NO, PNAME, AGE, JOIN_DATE, DOC_ID)

B) DOCTOR (DOC_NO, DNAME, DMAJOR, DATE_OF_BIRTH)

DOC_ID in the PATIENT table is a foreign key. Create it with CASCADE SET NULL option.

2.Insert 1 record into the PATIENT table using an Interactive script.