USING SQL EITHER ACESS OR ORACLE LIVE

Lab: Chapter 2 Employee Table 1. Create a table with the following fields Field Name EmpID Fname Lname Addressl Address2 Cit State Zi Number Varchar Varchar Varchar VarChar VarChar Varchar Number Len 4,0 30 30 30 30 20 9,0 2. Alter the table making EmpID the Primary Key 3. Insert 10 records into the EmpID Table 4. Using a select statement display all the records in the Table