Using Oracle SQL Developer

1. Create a new table called CATEGORIES. 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. 2. Create a new table called WOKERS containing four columns: Emp#, Lastname, Firstname, and Job_class. 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. 3. Add two columns to the WOKERS 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. 4. Modify the Job_class column of the WOKERS table so that it allows storing a maximum width of two characters. 5. Delete the EndDate column from the WOKERS table. 6. Rename the WOKERS table as EMPS. 7. Create a new table called NOVEL: It will have the following columns: ISBN, Cost, Retail, and Category. 8. Rename the new table PRICING_OF_BOOK. 9. Mark the Category column of the PRICING_OF_BOOK table as unused. Verify that the column is no longer available. Add some data into PRICING_OF_BOOK table. 10. Truncate the PRICING_OF_BOOK table, and then verify that the table still exists but no longer contains any data. 11. Delete the PRICING_OF_BOOK table permanently so that it isnt moved to the recycle bin.