Lab 3 Creating tables First, create all the tables using the information outlined in Section A. Second, make the modifications outlined in Section B. Save screen captures of all SQL statements used to accomplish these tasks. Save your screen captures in a word document which must be named in the format of yourname_DB_lab3.doc. Note: remember to include your name, assignment# , question and question# in screen captures. Suggested steps to accomplish the task in each Section: 1. Create/Modify each table 2. Describe (DESC) table 3. View the table where it can be done. scale Default Value length 4 15 Section A: Create new tables as the structure given below: Table_name Column_name Data Type Client C_Number Numeric C Name Variable character C_Address Variable character C_City Variable character C_State Fixed character C_Zip Fixed character C_Phone Fixed character C Contact_name Variable character Status Fixed Character Invoice |_number Number |_date Date Shipping_Instructions | Variable Character 30 20 2 7 10 20 1 4 Sysdate 20 Section B: Create / Make modification in the existing tables as instructed below: 1. Add a default value of A for the Status column of the CLIENT table. Describe the table. 2. Add a column named C_NUMBER to the INVOICE table. This column needs to hold Numeric data upto 4 digits. Describe the table 3. Add a column to the INVOICE table to contain the PAYMENT TERMS that is variable character. The column needs to accommodate the value that can consist of 25 characters. Describe the table 4. Change the C_ADDRESS column in the CLIENT table to accommodate up to 25 characters. 5. Create another table named BOOK_TEMP from existing BOOKS table, that consist of ISBN , TITLE, RETAIL, DISCOUNT and CATEGORY. ISBN column should be saved under Book_ID. View the contents in BOOK_TEMP table. 6. Drop column Discount from BOOKS_TEMP table. Confirm it by describing the table. 7. Drop BOOKS_TEMP table, confirm it is dropped. 8. Recover the dropped table BOOK_TEMP from recycle bin and view its contents again