4. [SQL] Create Table Employee with column names: personid (30 characters, primary key), firstname (40 characters), middlename (20 characters), and lastname (55 characters). (5 points)5. [SQL] Use DML to insert one record of your choice (make up some values) into the table Employee that you created in question 4. (5 points)

CREATE TABLE with SQL Server

Learn SQL: CREATE DATABASE & CREATE TABLE Operations