4.5 Programming Activity 1: Writing an Application with GraphicsIn this programming activity, you will create an application that uses graphics to draw a picture of your own design. The objective of this programming activity is to gain experience with the window coordinate system, the stroke and fill graphics methods, and using colors.Start with the ShellGraphicsApplication class, change the name of the class to represent the figure you will draw, and add an import statement for the Color class. Remember to include the JIGraphicsUtility.java file in the same folder.Create a drawing of your own design. It’s helpful to sketch the drawing on graph paper first, then translate the drawing into the coordinates of the application window. Your drawing should define an anchor point, and include at least two each of rectangles, ovals, and lines, plus a path. Your drawing should also use at least three colors, one of which is a custom color.Label your drawing using the fillText method.Be creative and have fun with your drawing!DISCUSSION QUESTIONS 1. If you define the starting (x, y) coordinate of the drawing as (800, 400), you might not be able to see the drawing. Explain why.2. What is the advantage to drawing a figure using a starting (x, y) coordinate as an anchor point

Download, unzip, and attach the sample database ITCO630_A from the link below. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time.Download the database for this assignment.The following are the tables and data in the ITCO630_A database:Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."Create a view called v_no_points with all the columns of the assignment table except the points column.Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.Reading AssignmentHoffer, chapter 6You may be required to enter the e-book email and password you created to gain access to download and read chapters from your e-bookTitleTypePublisherEditionISBNTermCourse CodeModern Database Management by Hoffer, Kenkataramane-Book - VitalSourcePearson1297801344021092001CITCO630-01

In our slides we talked about a simple shell. For this assignment you will implement your own shell that runs on top of the regular command-line interpreter for Linux.  Your shell should read lines of user input, then parse and execute the commands by forking/creating new processes. For each command, your shell should call fork() followed by execvp().  Following each command, your shell should wait for its child process to complete, and then print the child PID and the return result from the child.  The user should be able to specify the command to execute by giving a path to the executable file (e.g. /bin/ls) or by using path expansion to locate the executable file (i.e. searching each directory in the PATH environment variable). (Note that the execvp() function perform this processing automatically; you do not need to program it yourself.) If your shell encounters an error while reading a line of input it should report the error and exit.  If your shell encounters EOF while reading a line of input, it should exit gracefully without reporting an error. Ensure that you do not overflow a 1024 byte buffer when fetching the line of input (functions that do not accept the size of your buffer are not able to prevent overflows whereas functions that do accept a size generally do; be sure to check the manpage of any function you use carefully).