Employee Eid Dnumber Fname Lname Ssn Job Id Bdate Address Sex Salary Department Dnumber Ma Q30163211
EMPLOYEE (EID, DNUMBER, FNAME, LNAME, SSN, JOB ID, BDATE, ADDRESS, SEX, SALARY) DEPARTMENT (DNUMBER, MANAGER NO, DNAME, MGRSTARTDATE) DEPT LOCATIONS (DNUMBER, DLOCATION) PROJECT (PNUMBER, DNUMBER, PNAME, PLOCATION) WORKS ON (EID, PNUMBER, HOURS) DEPENDENT (EID, DEPENDENT_NAME, SEX, BDATE, RELATIONSHIP) EID employee id SSN-Social Security Number DNUMBER-department number OB ID-job title/position FNAME -first name LNAME-last name BDATE birth date MGRSTARTDATE -manager start date DLOCATION-department location DNAME- department name PLOCATION-project location PNUMBER project number PNAME- Project name The salary attribute in the employee table is Monthly Salary Figure 1: Employee DB Answer the following question based on Figure 1 given above (a) Retrieve the birth date and address of the employee(s) whose name last name is John (4 marks) (b) Retrieve all the attributes of employees(s) who works for the ‘Research’ department. (6 marks) (c) Retrieve the information of employee(s) who is earning more than 120,000 annually You are required to choose appropriate columns to devise the query. 6 marks) (d) Retrieve EID, salary and job_id of the employee(s) who is earning salary within the range of 6,000 to 15,000 and working aS ‘IT PROGRAMMER (6 marks) (e) Retrieve employee’s full name, department name, department location, project name and hours spent on project IT (18 marks) Show transcribed image text