! Custom eTextbook: Orcale 12C SQL TT Annotations Accessibility Bookmark Quick Tour Print Search In the Chapter 1 case study, you designed the new database for City Jail. Now you need to create all the tables for the database. First, create all the tables using the information outlined in Section A. Second, make the modifications outlined in Section B. Save all SQL statements used to accomplish these tasks. Section A Table Column Data Description Length Scale Default Value Aliases Numeric 6 6 0 Alias Criminal ID Alias Criminal D 10 Numeric Variable character Numeric Variable character 6 Criminals Last 15 First Variable character 10 Street Vanable character 30 E Custom eTextbook: Orcale 12C SQL Variable character Q TT Search Annotations Accessibility Bookmark Quick Tour Print First 10 Street Vanable character 30 City Variable charace20 State Fixed character 2 Zip Fixed character 5 Phone Fixed character 10 1 N (for No) Fixed character Fixed character 1 Not No) V_status P_status Crime ID Criminal D Crimes Numeric 9 0 Numeria 6 Classification Fixed character 1 Dala charged Date Status Fixed character 2 Date Hearing date Appeal cut date Sentence ID Date Sentonces Numero 6 m/reader/ebd0c96e-cdca-49e1-b6d2-86af3b47e0f5/page/3676d5a99f3baBabea2b796cfec857d6 W Custom eTextbook: Orcale 12C SQL Quick Tour Print Search TY Annotations Accessibility Bookmark PCIUS wa Sentences Sentence ID Numeric 6 Criminal ID Numeric 6 Type Fixed character Prob ID Numeric 5 Start date Date End date Date Violations Numeric 3 Prob_officers Prob_ID Numeric 5 Last 15 First 10 Street 30 Variable character Variable character Variable character Variable character Fixed character Fixed character City 20 State 2 Zip 5 Phone Fixed character 10 on 90CCC05780 w Update Custom eTextbook: Orcale 12C SQL a Search TT Annotations Accessibility Bookmark a Quick Tour Print one Email 30 Status Variable character Fixed character Numeric 1 A (for Active) Crime charges Charge ID 10 0 Crime ID Numeric 9 0 3 0 Crime code Charge_status Numeric Fixed character 2 Fine amount Numeric 7 2 Court fee Numeric 7 2 Amount paid Numeric 2 Date Pay_due_date Crime ID Crime_officers Numenc 9 O O Officer ID Numeric 8 Officers Officer ID Numeric 8 0 Last Variable character 15 First Variable character 10 TT Custom eTextbook: Orcale 12C SQL Quick Tour Print Search Annotations Accessibility Bookmar Officers Officer ID 8 0 Last 15 First 10 Precinct Numeric Variable characte Variable character Fixed character Variable character Fixed character Fixed character 4 Badge 14 Phone 10 Status 1 A (for Active) Appeals Appeal ID Numeric 5 Crime ID Numeric 9 0 Date Filing_date Hearing date Date Status Fixed character 1 Pifor Pending) Crime_codes Crime code Numeric 3 O Code_description Variable character 30 Table Column Possible Values Criminals V_status Y (Yes), N (NO) Criminals P status Crimes Classification Crimes Status Sentences Type Y (Yes), N (No) F (Felony), M (Misdemeanor), O (Other), U (Undefined) CL (Closed), CA (Can Appeal), IA (In Appeal) J Jail Period), H (House Arrest), P (Probation) A (Active), 1 (Inactive) PD (Pending), GL (Guilty), NG (Not Guilty) A (Active), 1 (Inactive) P (Pending). A (Approved), D (Disapproved) Prob_officers Status Crime_charges Charge_status Officers Status Appeals Status Print Search Annotations Accessibility Bookmark Crime charges Charge_status Officers Status PD (Pending) GL (Guilty), NG (Not Guilty) A (Active), (inactive P (Pending). A Approved (Disapproved) Appeals Status Section B Add a default value of U for the Classification column of the Crimes table. Add a column named Date_Recorded to the Crimes table. This column needs to hold date values and should be set to the current date by default. Add a column to the Prob_officers table to contain the pager number for each officer. The column needs to accommodate a phone number, including area code. Name the column Pager# Change the Alias column in the Aliases table to accommodate up to 20 characters