Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns

should be CatCode and CatDesc. The CatCode column should store a maximum of $2$ characters, and the CatDesc column should store a maximum of $10$ characters.

Create a new table containing these four columns: Emp#$,$ Lastname, Firstname, and Job$\_$class. The table name should be EMPLOYEES. The Job$\_$class column should be able to

store character strings up to a maximum length of four, but the column values shouldnt be padded if the value has less than four characters. The Emp# column contains a

numeric ID and should allow a five$-$digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.

Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system

date. The second column, named EndDate, contains employees' date of termination.

Modify the Job$\_$class column of the EMPLOYEES table so that it allows storing a maximum width of two characters.

Delete the EndDate column from the EMPLOYEES table.

Rename the EMPLOYEES table as JL$\_$EMPS.

Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail, and Category. The name of the ISBN column should be ID$,$ and the other

columns should keep their original names. Name the new table BOOK$\_$PRICING.

Mark the Category column of the BOOK$\_$PRICING table as unused. Verify that the column is no longer available.

Truncate the BOOK$\_$PRICING table, and then verify that the table still exists but no longer contains any data.

Delete the BOOK$\_$PRICING table permanently so that it isn't moved to the recycle bin. Delete the JL$\_$EMPS table so that it can be restored. Restore the JL$\_$EMPS table and

verify that it's available again.

Please make sure you submit the SQL$\text{'}$s $($queries$)$ and the results of the queries. Write the query, do not use the GUI $($Graphical User Interface$)$ to create tables. Run your actual

DDL statements in Oracle Live SQL$.$ Same as in Hands$-$On $02.$