Now, in the order given below, make some modifications and populate your tables. Before you start below, make sure your initial code is run. The code is provided in BB. You should drop the tables first. Note, make dates appear as given below. 1. Because you forgot when you created your initial tables, do the following (NOTE: do not change CREATE table commands; the below are modifications): a. Add three fields to the faculty table: hire date (gives the day, month, and year of hiring) teach exper (gives number of months and years of college teaching experience) ave teaching (gives the average time a teacher teaches per year in days, hours, and minutes) b. Add a field to the student table that records a student's class and constrains that class to only FR, SO, JR, SR, or OT (for other). c. Add a constraint that a faculty member's pin must not be null (do not change the table creation above to do this!). I 2. Insert the following records into the tables in an appropriate order. Location (note: locations with 4 or less capacity are offices): # 200 BSA Room 100 Capacity: 35 Capacity: 45 # 201 BSA Room 201 LA's Room 45 Capacity: 50 BSA Room 210 Capacity: 1 BSA Room 211 Capacity: 2 LA's Room 114 Capacity: 4 #210 # 301 # 302 # 444 Faculty (if not tenured, the tenure start date is the exactly one year after the date hired. This date should be in the following format: 2005 JUNE 12). # 13579 Ralph B. Kinner (tenure date: 12 Jun 2003) pin: 98765432 office: BSA 210 teaching exp: 5years, 6mo teaching time: 98 days, 6 hours, 5 minutes #24681 James Cotton (untenured) pin: 34567891 office: BSA 211 Date hired: 4/30/2001 teaching exp: 3years, 10mo teaching time: 188 days, 16 hours phone # 501 339-5674 #36925 Blaine Cultra (tenure date: 18 May 1999) pin: 78901234 office: BSA 211 Date hired: 7/31/1996 teaching exp: 15years, teaching time: 52 days # 24866 Anne L. Masters (untenured) pin: 77553311 office: LA's 114 Date hired: 6/15/2004 teaching exp: 0 years, 9mo teaching time: 101 days, 19 hours Sam T. Chan (adjunct) pin: 34567890 office: LA's 114 Phone: (501) 450- Hire date: 6/10/2018 teaching experience: 2 years 0 months. #45678 2234 Student (all are from Texas): # 56782 # 90123 #34567 #78901 # 90148 advisor: Cotton advisor: Cotton JR advisor: Kinner advisor: Masters FR Grad student advisor: Cultra Hire dates: Tenure dates: Tenure start dates: JR SO Albert C. Bell phone: 432-556-0945 Blair Burton phone: 432-556-6384 Basel Moncrief Anne A. Archer 432-675-3049 John C. Calhoun pin: 55667788 Dates: the following emphasizes the different required date formats: 7/10/2002 10 Jul 2002 2002 JUNE 10 This homework continues our look at the community college at which we are the DBA. We created five tables so far, the SQL code is provided in Blackboard (ModifyInsertHW2Start). Run this script (it will work). TURN THIS IN as a sal file IN BLACKBOARD! Now, in the order given below, make some modifications and populate your tables. Before you start below, make sure your initial code is run. The code is provided in BB. You should drop the tables first. Note, make dates appear as given below.