Question (10 Part II. Analysis (Answer all questions) Marks) 1. Find the following parallel schedule.[5 Marks] T2 T read(A) write(A) read(A) write(A) read(B) write(B) read(B) write(B) Convert the above parallel schedule to serial schedule. State whether given schedule is conflict serializable or not.

Scenario and Database Model: InstantStay InstantStay is the new online marketplace to find accommodation in various cities and states. It focuses on gathering the house owners and tenants together as a trusted platform. Hosts join to the system with their houses to be rented out. Similarly, guests join to the system to rent available houses. In addition, channels such as travel agencies, newspapers join InstantStay for connecting customers from different platforms. In the OWNER table, data for the house owners are collected with their personal information as shown in the following table: OWNER Table In the HOUSE table, all houses in InstantStay are collected with detailed address and respective characteristics about the houses: HOUSE Table Guests are the customers registered to the platform to access information, offers and stay at houses in InstantStay. Data of the guests are collected in the GUEST table: GUEST Table As a large platform, InstantStay hosts multiple channels with different commission rates. The channels related information is collected in the CHANNEL table: CHANNEL Table Finally, each reservation in the system is collected in STAY table. Reservations are collected with the corresponding house, guest and channel, start date, and end date. The price information with discount are also tracked in this table. Negative prices indicate the cancellations and the required repayments. Collected data for reservations are as follows: STAY Table You are assigned as the database administrator to collect and manage transactional data of the InstantStay operations. Your main task is to create SQL scripts to help other teams in InstantStay to retrieve the required data. In the following tasks, you will collect the requested data to help other teams be successful on their business operations.

(1 point) Determine the average rate of change of the following function between the given values of the variable: f(x) = x4 - - X; x = -2, x = 3 Average rate of change = .

Question Suppose three point masses are placed in the xy-plane as follows (assume coordinates are given in meters): mi = 5 kg, placed at (-2, -3) m2 = 3 kg, placed at (2,3) 'm3 = 2 kg, placed at (-3, -2) Find the center of mass of the system. Write your answer as an ordered pair Provide your answer below:

let f(x)= x^2-5, g(x)= 2x^3+x and p(x)= f(x)g(x). a) computedp/dx b) compute f'(x)g'(x)

10. A box is lying on top of a trailer, which is parked on the road. According to Newton's third law, what is the reaction force to the gravitational pull of the box on the trailer? The normal force of the trailer on the box The gravitational pull of the trailer on the box The gravitational pull of the trailer on Earth The normal force of the road on the trailer The weight of the trailer The normal force of the trailer on the road The gravitational pull of the box on Earth The weight of the box

Suppose that a company is developing a new touch-screen cell phone. Historically, 70% of their new phones have resulted in high consumer demand, whereas 30% have resulted in low consumer demand. The company has the decision of choosing between two models with different features that require different amount of investment and have different sales potential. Estimated profit/loss are shown in the payoff table below. State of Nature High demand, ($) Low demand, ($) Model 1 300,000 -40,000 Model 2 275,000 -15000 Now suppose the firm conducts a market research study to obtain sample information and better understand the nature of consumer demand. The market research cost $10,000 Analysis of past market research studies, conducted prior to introducing similar products, has found that the survey response will be either high or low. There is a 69% chance that the survey will return a high survey response (results) and there is a 31% chance that the survey will result in lo-demand response (results). The relevant conditional probabilities are as follows: P (high consumer demand, high survey response = 0.913) P (low consumer demand, low survey response = 0.087) P (high consumer demand, high survey response = 0.226) P (low consumer demand, low survey response = 0.774) Calculate the expected value of sample information (EVSI). Develop a decision tree and analyze using QM for Windows. Determine the optimal solution.