Question

Consider the following table EMPLOYEE, which stores EmployeeID, Name, Department and Salary.

Table: EMPLOYEE

EmployeeID	Name	Department	Salary
101	Aman	IT	60000
102	Rahul	HR	50000
103	Priya	IT	70000
104	Neha	Finance	55000
105	Rahul	IT	60000

1. Which attribute in the Table can be considered as the Primary Key? Provide justification for your answer.
2. Write a suitable SQL query to add a new column, Experience, of numeric data type to the table.
3. Write the output of the following SQL Query.
   SELECT Department, COUNT(*) FROM Employee GROUP BY Department;

Answer 1

1. EmployeeID can be considered as Primary Key because it uniquely identifies each employee in the table.
2. ALTER TABLE Employee ADD Experience INT;
3. 
   

   Department	COUNT(*)
   IT	3
   HR	1
   Finance	1