Styles

$4.$ Use the sample data provided to determine appropriate datatypes for each column. For this exercise, you will use varchar$2,$ number, or date datatypes. Like columns must have the same datatype and length.

$\backslash$table$[[$Column name,Datatype$],[$DIR$\_$NUM,NUMBER$(3)],[$DIR$\_$NAME,VARCHAR$2(20)],[$DIR$\_$DOB,DATE$],[$PLAY$\_$CODE,NUMBER$(4)],[$PLAY$\_$NAME,VARCHAR$2(30)]]$

Log into our database and create the DIRECTOR and PLAY tables. You have been provided with the code below.Next, enter all the data above into each table. Since there is a foreign key defined on the play table for dir num, the director table must be populated before the play table. This is sometimes referred to as hierarchy. DIRECTOR is the parent of PLAY.a$.$ Director Table:INSERT INTO director $($dir num, dir, lname$,$ dir dob$)$VALUES $(100,$ 'BroadwaY', $\text{'}12-$JAN$-1965\text{'})$:Complete add all three rows.Issue a COMMIT to save data.b$.$ Play Table:INSERT INTO play $($play code, play name, dix. numn$)$VALUES $(1001,$ 'Cat on a Cold, Bare Roof', $\text{'}102\text{'})$;