The Complete Beginner’s Guide to SQL Fundamentals

Building an Employee Database with Microsoft SQL Server

Create SQL Server Database Tables, Foreign Keys and Data

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)