Assume that we are using STCF scheduling and we have the following schedule of arriving transactions and durations Job Arrival Name Time A B C 1 0 10 Duration 10 13 100 Please complete the following measures (round each answer to the closest integer, if necessary) What is the average turnaround time (show your work)? What is the average response time (show your work)?

Table 1. 4 processes arriving shown in Operating System Scheduling PDF for Shortest Job Next, non- preemptive Process Arrival Times Execution Times Service Times sequence Wait Times calculations PO 0 12 P1 21 9 P2 41 6 P3 6 3 Total wait time = ? Here the 4 processes of the PDF are repeated in Table 1, with arrival times changed to 0, 2, 4, and 6 respectively. Also, the execution times are changed to 12, 9, 6, and 3. You will be asked to fill table 1 with the numbers like the service times (when is each process serviced), the sequence of executions of these 4 processes in part (a) and part (b) below. Also, you will compute the total wait time. Note for FCFS, it is 1, 2, 3, 4 for P0, P1, P2, and P3; • for the SJN or Shortest Job Next with non-preemptive, PO is #1, P1 may not be #2; for SRT, or shortest remaining time, the preemptive version of SJN, PO is #1, but after 2 time units when P1 comes, P1 kicks out PO since its execution time is 4 < 9- 2 = 7; and P1 may be preempted by P2 later…

Consider the process of reserving a bus ticket over the phone and write a step by step use case description/ elaboration of the case study given below: When a customer calls the Agent on the phone, they are asked about the Arrival date and time, and the Destination city. The agent then informs the customer about the available route timings. The customer then selects the appropriate route timings and number of seats he wants to reserve. The agent confirms if seats are available, then asks the customer for his name and phone number. Finally, the agent informs to the customer about successful reservation.

Explain the relationship between these pieces of code CREATE SEQUENCE Customers_Sequence; _______________________________________________________________________ CREATE TRIGGER Customers_Sequence_Trigger BEFORE INSERT ON Customers FOR EACH ROW WHEN (new.CustomerID IS NULL) BEGIN   SELECT Customers_Sequence.NEXTVAL   INTO   :new.CustomerID   FROM   dual; END; ________________________________________________________________________ CREATE TABLE Customers (     CustomerID int ,     CustFirstName varchar (25) NULL ,     CustLastName varchar (25) NULL ,     CustStreetAddress varchar (50) NULL ,     CustCity varchar (30) NULL ,     CustState varchar (2) NULL ,     CustZipCode varchar (10) NULL ,     CustAreaCode smallint DEFAULT 0 NULL ,     CustPhoneNumber varchar (8) NULL  ); _________________________________________________________________ INSERT INTO Customers   (CustomerID, CustFirstName, CustLastName, CustStreetAddress,     CustCity, CustState, CustZipCode, CustAreaCode,…