1. Create the following table with name Employee2020:

Field	Data type	Constraint
Eid	Number(4)	Primary key
Ename	Varchar2(20)
Sal	Number(8,2)	Default value =3000.00
Dept	Number(3)

2. Insert the following values into the above table, which record insertion is violating the constraints:

Eid	Ename	Sal	Dept
2017	Nasma	3500.00	12
2016	Reem	4000.00	12
2018	Nahe		11
2014	Baya	5600.00	12
2019	Nasar	5200.00	14

3. Select all the employees whose dept =12. 

4. Find the details of the employees whose ename starts with the letter ‘N’ using like clause. 

5. Sort the table in ascending order of Eid. 

6. Delete the record with ‘Eid= 2017’ from the Employee2020 table.

7. Alter the table Employee2020 by adding the following column, “Admin” whose data type is number.

8. Display the sum of sal. 

9. Count the number of employees group by dept. 

10. Write the query to unite two tables without duplicates.

1	Final lab Assignment ITEC211