This is a lab assignment that involves multiple tables in a database: Requirements: 1. Please write your SQL instructions for table creations and query answering into one executable file. 2. The file should be runnable on the database of your computer without any problems to create required tables and give answers to the required queries. [70 marks] 3. A README documenting how well you have complete the requirements: what requirements are completely finished, what requirements are partially finished, what are not done at all, etc. (10 marks] 4. Screenshots to show how well your program works which should be consistent with README. [20 marks) 5. Each group just need to submit one copy and please indicate your group members. Assume the following attribute data types for tables: Student_ID: integer . Student_Name: 25 characters Faculty_ID: integer Faculty_Name: 25 characters Course_ID: 25 characters Course_Name: 15 characters Date_Qualified: date Section_ID: integer Semester: 7 characters Write SQL queries to answer the following questions: 1. Display the course ID and course name for all courses with an ISM prefix. 2. Display all the courses (Course_Name) for which Professor Berndt has been qualified. 3. Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930? 4. How many students are enrolled in section 2714 during semester 1 - 2001? 5. Which students were not enrolled in any courses during semester 1 - 2001? STUDENT (Primary key: Student_ID) IS_QUALIFIED (Primary key: Faculty_ID, Course_ID) Student ID Student Name Faculty ID 2143 Course_I D ISM3112 Date Qualified 9/1988 38214 Letersky 3467 ISM4212 9/1995 54907 Altvater 3467 ISM4930 9/1996 66324 Aiken 4756 ISM3113 9/1991 70542 Marra 4756 ISM3112 9/1991 FACULTY (Primary key: Faculty_ID) SECTION (Primary key: Section_ID) Faculty_ID Course ID Section_ID Faculty Name 2143 Birkin 2712 ISM3113 3467 Berndt 2713 ISM3113 4756 Collins 2714 ISM4212 2715 ISM4930 COURSE (Primary key: Course_ID) IS REGISTERED (Primary key: Student_ID, Section_ID) Course ID Student ID Section_ID Semester Course Name Syst Analysis ISM3113 38214 2714 I - 2001 ISM3112 Syst Design 54907 2714 I - 2001 ISM4212 Database 54907 2715 I - 2001 ISM4930 Networking 66324 2713 I - 2001