1. Using SQL, write Data Definition Language commands to set up the database schema for an Admission Database System for a University with the tables below: a. STUDENT(sID, sName, GPA, sizeHS) b. COLLEGE(cNames, state, enrollment) c. Apply(SID, cName, major, decision) Hint: i. SlD is unique and not null for each Student ii. clame is unique and not null for each college iii. SLR, cName and major are unique for each record in the Apply table iv. GPA is a decimal value with at least 2 decimal points 2. Research (over google) the SQL syntax of the SQL "INSERT INTO" statement and determine the commands to populate the tables with data below. COLLEGE STUDENT Apply You are provided with the specification requirements below to implement a database management system (DBMS) for "Bank X" to store details about their Branches, Accounts, and Customers. SR-1: A BRANCH has a Branchle that is numeric, a Branch Name, and Branch Address. The BranshID is unique for each branch while Branch Name and Branch Address may not be unique. SR-2: An ACCOUNT has an AccountNe field in numeric characters, Account Type, and Balance. The ACCOUNT_TYPE is either Savings, Checking, Credit Card, or Mortgage. The AscountNe is unique for each account. SR-3: CUSTOMER has an SSN field that is of numeric characters, along with Name, Phone, Address. SR-4: A Branch has multiple accounts linked to it, while an account can be linked to just one branch. SR-5: A customer can possess no more than 4 accounts in the same branch but of different account types. While accounts are not shared between customers. SR-6: A customer can have multiple accounts in different branches. SR-7: Only the customer's phone number may be empty (NULL), all fields in the database are mandatory. 3. Using SQL, write Data Definition Language (DDL) commands to set up the database schema with the below tables. Note: Include a primary key for each table: a. BRANCH (BranchIR, BranchName, BranchAddress) b. ACCOUNT (Accllo, AccTypest, Branch, SSN, Balance) c. ACCOUNT_TYPE (AccTypeld, AccountTyRe) d. CUSTOMER (SSN, Name, Phone, Address) 4. Using SQL, write Data Manipulation Language (DML) commands to populate the tables with data to illustrate SR4 to SR7