The assignment discription is in the uploaded files underneath are some supporting materials. There are multiple videos that I can't upload through studypool, you can give me a email address so that I can send you all the Programming Assignment 6 Test ScriptThis is a scenario that you can use to test Programming Assignment 6. It is not an exhaustive test, but tests almost all of the conditions your program should handle.When you submit your PA 6, all the tables in the database should be empty except the Rooms Table and the Dates Table. The Rooms table should contain three rooms, such as 101 with 60 seats, 102 with 40 seats, and 201 with 20 seats, which will be used in this script. The Dates table should contain two dates, which will be expressed as date1 and date2 in this script.This scenario assumes that is the case.The faculty names will be a, b, c, d, etc. to simplify input and this script.The dates will be real dates but will be represented in this script by the symbolic names date1 and date2.Script:-Add faculty aNote: after adding a faculty, the faculty should appear in the drop down list on the Reserve panel.-Add faculty b-Add faculty c-Add faculty d-Add faculty e-Reserve a, date1, 20a reserves room 201-Reserve b, date1, 50b reserves room 101-Reserve c, date1, 50c gets waitlisted-Reserve d, date1, 40d reserves room 102-Reserve e, date1, 20e gets waitlisted-Reserve c, date2, 20c reserves room 201-Status date1 a reserved 201 b reserved 101 d reserved 102-Status date2 c reserved 201-Status Waitlist c date1 50 e date1 20General conditions of testing:the results of any action are displayed to the user immediately after the action is performed without the user needing to check Status.All affected combo boxes are updated immediately after each action is performed.Creating a timestamp field in JavaThe following is sample code to insert a Timestamp field into a table column:// declare a timestamp field. java.sql.Timestamp currentTimestamp = new java.sql.Timestamp(Calendar.getInstance().getTime().getTime());// use the timestamp in an insert to the wait list. getWaitList = dbConnection.prepareStatement("insert into waitlist (flight, day, customerName, timeStamp) values (?, ?, ?)"); getWaitList.setString(1, entry.getFlightName()); getWaitList.setString(2, entry.getDay()); getWaitList.setString(3, entry.getCustomerName()); getWaitList.setTimestamp(4, currentTimestamp); count = getWaitList.executeUpdate(); Make sure the column in the database table is specified as Timestamp and not Time.

Write a complete bash script that monitors the number of processes per user on the current CSE Linux machine (e.g., cse01, cse02, etc.) where the script is running. In particular, you will count all processes and total them per user every 5 seconds and report each user ID with the number of processes running during that time frame. Note this will include system processes. If the user enters a list of user IDs as arguments to the program it should only report processes for those users. In addition, you will install a custom signal handler to trap the SIGINT (i.e., ^C). This signal handler should prompt the user if they really want to exit. If they enter “Y” or “y”, your program should exit. If anything else is entered, the program should continue to run. You will also print out the current date and time, a heading before listing the users and process count followed by a line containing the total number of users and total number of processes running. The users column and the counts should line up to look nice. Add a blank line between each output to make it easier to see each report. The output of each line

you do NOT have to include the youtube video CITIZEN DATA SCIENCE Assignment for MAR 3613Use the database provided in canvas.Here are the list of requirements:A Tableau dashboard of at least 3 visualizations.The dashboard should be interactive: clicking on the filters and the visualizations themselves should change the data in the dashboard.The video should be at least 3 minutes.The video should include:a brief introduction (name, U#, please show your face),an explanation of the dataset and the assignment (less than a minute),and the rest should be an explanation of multiple insights found while navigating the dashboard.The link should be uploaded to the Tableau assignment in canvas.Please review the grading rubric to be sure you have met all required criteria.To qualify for the Citizen Data Certificate, you must take the Certificate quiz located at the bottom of this module.RubricTableau RubricTableau RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeAssignment submitted on timeMinus one point per day for late submissions5.0 ptsFull Marks0.0 ptsNo Marks5.0 ptsThis criterion is linked to a Learning OutcomeSubmission of unlisted YouTube URL and USF Email address via Canvas20.0 ptsFull Marks0.0 ptsNo Marks20.0 ptsThis criterion is linked to a Learning OutcomeVisualization 1Age by Gender (provide average age)10.0 ptsFull Marks0.0 ptsNo Marks10.0 ptsThis criterion is linked to a Learning OutcomeVisualization 2 - Map10.0 ptsFull Marks0.0 ptsNo Marks10.0 ptsThis criterion is linked to a Learning OutcomeVisualization 3Two other variables of your choice (i.e. age and marital status)10.0 ptsFull Marks0.0 ptsNo Marks10.0 ptsThis criterion is linked to a Learning OutcomeMake sure you label the "sheets" in your Tableau workbook with meaningful titles that explains your charts.5.0 ptsFull Marks0.0 ptsNo Marks5.0 ptsTotal Points: 60.0