Engineering Ed Section (C) Coding and Relational Algebra (Each question 2.5 marks) [25 marks] 1. What will be the result of the following query? Give explanation? CREATE TABLE Employee(Emp id NUMERIC NOT NULL, Name VARCHAR(2 0), deriname VARCHAR(20), Salary NUMERIC UNIQUE(Emp id. Name)); INSERT INTO Employee VALUES(1002, Ross, CSE, 10000) INSERT INTO Employee VALUES(1006, Ted, Finance. ); INSERT INTO Employee VALUES(1002,Rita Sales 20000): 2. Write an SQL query that returns for each article, its ID title and the number of authors 3. Write SQL statements that correspond to the following relational algebra expression. II title year(year-2008(Articles)) glish (United States