Using the guidance provided in Box $1$ of the poster, create an SQL script file that has the same content as the Unnormalized Form $($UNF$)$ but eliminates the First Normal Form $(1$NF$)$ violations. Do not normalize beyond $1$NF$.$

Your script should contains three sections:

An anonymous PL$/$SQL block that drops any existing tables having the same name as those that will be created later in the file. $($Note that you will want to drop the tables in the reverse order of creation. This helps to ensure that child rows in one$-$to$-$many and many$-$to$-$many relationships are removed before their parents, so that drops are not abandoned due to key constraint violations.$)$

CREATE statements for two tables, which should be named nf$\_$puppies$\_1$nf and nf$\_$tricks$\_1$nf$.($See the Scoring Guide below for details on features that must be present in these tables to earn full credit.$)$

A series of INSERT statements that populate your two tables with the same data as in the UNF version, but refactored into $1$NF form. $($See Box $2$ on the poster for an example of how the data should appear in the Trick table after conversion to $1$NF$,$ and compare with the data in the UNF version.$)$