1) ii) iii) iv) v) Write an SQL query to fetch common records between two tables. Write an SQL query to fetch records that are present in one table but not in another table. Write an SQL query to fetch the Emplds that are present in both the tables Write an SQL query to fetch the employee full names and replace the space with '-'. Write an SQL query to find the employee id whose salary lies in the range of 9000 and 15000.

First normal form says: a. No nonkey columns depend on another nonkey column b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above

1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.