Two part question: Review the DDL script below and answer th…
Two part question: Review the DDL script below and answer the following two questions: 1. Identify and describe two distinct (cannot be the same issue in a different place) script-related problems in this code. These issues could potentially cause errors or unwanted outcomes. Upper and lower cases do not cause issues. 2. Assuming the issues are fixed and the script ran without errors, what will be the result after it runs meaning what will exist in the database? CREATE TABLE members ( uteid varchar(20) primary key, first_name varchar(30), last_name varchar(40), email char(15), phone varchar(12), grade number(1), birthdate date ) CREATE TABLE committees ( committee_id NUMBER(5) PRIMARY KEY, committee_name VARCHAR(30), semester_year VARCHAR(4) ) CREATE TABLE member_committees ( uteid VARCHAR(20), committee_id NUMBER(5), CONSTRAINT uteid_committtee_pk PRIMARY key (committee_id), CONSTRAINT uteid_fk FOREIGN KEY (UTEID) References members (UTEID), CONSTRAINT committee_fk foreign key (committee_id) references committees (committee_id) ) DROP TABLE member_committees DROP TABLE members DROP TABLE committees