4G VOLTE ON 61% 11 19:07 https://drive.google.com... : : test2_Sample.pdf PDF MEIE3284 Design of Industrial Information System SAMPLE TEST2 D. The human resources department of an enterprise maintains a database on the company's employees in order to track their qualifications at various skill levels. The tables are as follows. EMPLOYEE EMPL_ID LAST_NAME FIRST_NAME DEPT ID 1001 Brown George 120 1002 Lee Harry 20 1003 Kirk Bernard 30 1004 James William 130 1005 James Harry 140 SKILL SKILL ID SKILL DESC 110 C Programmer 111 Systems Analyst 112 Project Manager 113 Java Programmer 114 Database Administrator DEPARTMENT DEPT_ID DEPT NAME DEPT LOCATION DEPT EXTENTION 20 ERP Development Room 101 15-2007 30 Technical Assistance Room 103 15-2004 40 Programming Room 105 5-2008 Support EMPLOYEE SKILL_SET EMPL_ID SKILL_ID DATE_QUALIFIED 1001 110 981/1990 1001 7/10/1995 1002 1002 1111 5/10/1992 1002 17 1002 114 6/12/1995 1003 1113 LOS 1004 1004 1110 9/10/1999 0999 1004 6/8/2004 1005 110 1/15/1996 1005 111 2/1/1999 1005 1112 3/3/2001 686/2000 All attributes are text data types except DATE_QUALIFIED, which is a date data type. The database can be downloaded from the web site supporting this book. (a) Identify the primary key(s) and foreign key(s) of each table. (5 Points) (b) Write the SQL commands to return the following data from the database: (1)The first and last names of the employees who work in Department 30 (2 Points) (ii) The first and last names of employees with the SKILL_ID of 110 (2 points) (iii) The number of "Java Programmers" in Department 30 (3 Points) MEIE3284 Design of Industrial Information System SAMPLE TEST2 (iv) The last and first names of the Java Programmers" in Department 30 listed alphabetically by last name. (3 Points) 7 / 5