Write SQL CODE to Add a new column in the table COURSE, name it "DEPT_CODE". Split the major code out of the CRS_CODE (i.e., take "ACCT" out of "ACCT-211"), and save that in the "DEPT_CODE" column. Table: ENROLLCLASS_CODE1001410014100181001810021Table: PREREQUISITECRS_CODECIS-420QM-261QM-362QM-362Table: PROFESSORSTU_NUM321452324257321452324257321452EMP_NUM DEPT_CODE PROF_OFFICE103HIST104ENG105ACCT106MKT/MGT110BIOLDRE 156DRE 102KLR 229DKLR 126AAK 160***ENROLL_GRADEсBABсPRE TAKECIS-220MATH-243MATH-243QM-261PROF_EXTENSION67835561866538993412wwwPROF_HIGH_DEGREEPh.D.MAPh.D.Ph.D.Ph.D. Table: CLASSCLASS_CODE CRS_CODE CLASS_SECTION1001210013100141001510016Table: COURSEACCT-211ACCT-211ACCT-211ACCT-212ACCT-212CRS_CODEACCT-211ACCT-212CIS-220CIS-420MATH-243Table: EMPLOYEE12312CLASS_TIMEMWF 8:00-8:50a.m.HenryRosemaryRonaldPrestonMWF 9:00-9:50a.m.TTh 2:30-3:45 p.m.MWF 10:00-10:50a.m.Th 6:00-8:40 p.m.CRS_DESCRIPTIONAccounting IAccounting IIIntro. to MicrocomputingDatabase Design and ImplementationMathematics for ManagersROOM_CODE PROF_NUMBUS311BUS200BUS252BUS311BUS252***♡ ♡ +331054105342CRS_CREDIT33301301EMP_NUM EMP_LNAME EMP_FNAME EMP_INITIAL EMP_JOBCODE EMP_HIREDATE EMP_DC100WorleyJamesFCUST2/23/1978 6/12/19101RamsoBCUST11/15/1994 11/2/19102EdwardsTECH7/23/19907/3/195103DonellyPROF7/1/1987 10/2/19104YukonPROF5/1/1992 2/23/19

SQL (Structured Query Language) is a programming language used to manage and manipulate data stored in relational database management systems (RDBMS). It is a standard language for working with relational data, and is used to perform a wide range of operations on database systems, including data definition (DDL), data manipulation (DML), and data control (DCL) operations. In simple terms, SQL allows users to write queries to extract, modify, and delete data from a database. It provides a consistent and declarative way to work with data, and allows users to specify the exact information they want to retrieve from a database in a clear and concise manner. SQL is a powerful and widely-used language that is essential for working with data in a relational database.SQL Code: ALTER TABLE COURSEADD DEPT_CODE VARCHAR(4); UPDATE COURSESET DEPT_CODE = SUBSTR(CRS_CODE, 1, INSTR(CRS_CODE, '-') - 1); Explanation: In this query, we first use the ALTER TABLE statement to add a new column called "DEPT_CODE" to the COURSE table. We specify that the column should be a variable-length character string with a maximum length of 4 characters, which should be sufficient to hold the major code for any course. In this query, we use the UPDATE statement to update the values in the "DEPT_CODE" column of the COURSE table. We use the SUBSTR() function to extract a substring from the CRS_CODE column, starting at the first character and continuing for a length equal to the position of the first dash (-) character in the CRS_CODE column minus one.