Write SQL statement to create table. Refer to the following table structure, write SQL statement to create table. Field Name Data Type Length Attribute 1 Student ID Numeric 8 Alphabetic 40 Attribute 2 Student Name Attribute 3 Gender Alphabetic 1 Attribute 4 Date of Birth Date Attribute 5 Department Alphabetic 10 Attribute 6 Borrowed Numeric 2 Table name: Borrow Record List the 4 steps in database design. List the 4 steps in database design. Step 2. Entity Relationship Modelling Step 3. Transformation into Data Structures Step 4. Normalization of Data Structures Step 1. Analysis of Requirements Which of the following statement would work? Employee table has three columns: Empid, Lastname, and Salary. Rose wants to enter data for empid 59694, lastname Fong, but not salary. Which of the following statement would work? a. Insert into Employee values (59694, 'Fong'," "); b. Insert into Employee (Empid, Lastname, Salary) values (59694, 'Fong'); O c. Insert into Employee values (59694, 'Fong'); O d. Insert into Employee values (59694, 'Fong, 'NULL"); O e. Insert into Employee (Empid, Lastname) values (59694, 'Fong'); Which of the following statement would not work? Employee table has three columns: Empid, Lastname, and Salary. O a. TRUNCATE TABLE Employee; O b. ALTER TABLE Employee DROP COLUMN Lastname; O c. ALTER TABLE Employee UPDATE (Lastname SHORT TEXT (30)); O d. DELETE FROM Employee WHERE Empid=221; O e. RENAME Employee TO Employee Old