IT213 Lecture: Project #4 Animation Commercial (10% of Final Grade) I. Purpose The purpose of this assignment is to demonstrate your ability to use the various features and functions in Adobe Animate to create a commercial for your fictional company/organization.This assignment is an opportunity to utilize the animation authoring skills that you have learned to develop a creative and original 20-second non-looping animation to deliver a message about your company/organization. II. Steps You must use Adobe Animate to create your commercial. Your animation must meet the following requirements: Submit your FLA file via Blackboard using the Assignments Tool (“Course Tools” à “Assignments” àfollow the “Project 4: Animation Commercial” link). III. Grading Description Points File Format: File does not exceed 800x600 in dimension. File format is FLA. FPS is 12.Platform/Playback type is HTML5 Canvas (preferred) or ActionScript 3.0Duration is at least 20 seconds.Select a background color; Create a “loading” text box and 5 small white squares (3 point)Create a preloader animation (squares sequentially turn to black squares for 0.5 second each, moving from left to right (3 points)Resulting in a color change of any object (2 points)Resulting in a position change of any object (2 points)Resulting in a transformation change of any object (scale, rotation)(2 points)Resulting in a shape change (2 points)Create a button symbol (1 point)Set the following states for the button: (3 points)Upstate: Create a text box on top of the square with the text ‘End’ Over State: Change the color of the text ‘End’.Down State: Change the color of the text ‘End’.Import the Image.gif file (1 point)The animation stops when the button appears (to let the user click on the button) (2 points)The animation continues to play the imported Image.gif movie when the user clicks on the button. (2 points)The imported Image.gif file must run at least once completely without looping (2 point) 1-25 Accessibility (only for ActionScript 3.0 documents) Create the animation with the Accessibility Panel activatedSelect the “Make Movie/Object Accessible” option on movie or individual objectsProvide an alternative equivalent in the Name and Description fieldsNo component of the content flashes more than three times in any 1-second period 1-25 Preloader 6 Motion Tween 6 Shape Tween 2 Button 4 Ending (JavaScript or ActionScript 3.0) 7 TOTAL 25

Write 10 SQL statements against the STUDENT schema (Login information can be provided). Your statements should run error-free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only; and the other document (doc/docx/pdf) include both your statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document.Q1. List all instructors. Show salutation in all lower cases, last name in all upper cases and phone number in the format of '(xxx) xxx-xxxx'. (HINT: use LOWER, UPPER and SUBSTR function)Q2. List all students (display student_id, first name, last name, street address, zipcode, city, and state) who live in New York, NY. Sort results by last name, and then first name, in descending order.Q3. Display the city in which each instructor lives. List first name, last name, zip, city, and state. Display "N/A" for zip, city, and state if an instructor does not have a zipcode. (HINT: left join INSTRUCTOR and ZIPCODE; use NVL function)Q4. Show the number of instructors who live in NY state and has a street number of 518. (HINT: use string functions such as SUBSTR and INSTR)Q5. Display the lowest, highest, and average numeric grade of Project grade type. (HINT: use the MIN, MAX, and AVG function; join GRADE and GRADE_TYPE)-- LEFT JOIN, DATEQ6. List all students (display student_id, first name, last name, and registration date) who registered on or before 2/15/2007 but have not enrolled in any course. (HINT: left outer join STUDENT and ENROLLMENT; use the TO_DATE function)-- COUNT WITH 3-TABLE JOINQ7. Find how many students are enrolled in sections taught by Todd Smythe. (HINT: join INSTRUCTOR, SECTION, and ENROLLMENT)-- 4-TABLE JOINQ8. Show all students who are taking, or have taken the course "Advanced Java Programming course". List student name, enrollment date, and section location. (HINT: join COURSE, SECTION, ENROLLMENT, and STUDENT)-- 4-TABLE JOINQ9. List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.-- 4-TABLE JOIN WITH DISTINCTQ10. List the instructors who teach Advanced Java Programming (having a section with students enrolled), without duplication. Show instructor name and course name. (HINT: use the DISTINCT keyword)Learning Resourceshttps://www.w3schools.com/sql/sql_join.asphttps://docs.oracle.com/database/121/SQLRF/functions.htm#SQLRF006