The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm's leading product over the past eight years. Click on the datafile logo to reference the data. DATA file Year Cost/Unit ($) Year Cost/Unit ($) 1 20.00 5 26.60 2 24.50 6 30.00 3 28.20 7 31.00 4 27.50 8 00 36.00 Plot (i) What type of pattern exists in the data? Trend Pattern (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, bo Slope, b1 = MSE = = (c) What is the average cost increase that the firm has been realizing per year? Round your interim computations and final answer to two decimal places. (d) Compute an estimate of the cost/unit for next year. If required, round your answer to two decimal places.

Your university runs many hundreds of courses each semester and needs to keep track of key information on each one. Among the data needed for each course would be the following: - University course identification number - Department course ID and section number (for multiple sections of the same course) - Number of credits for the course Days and times the course meets - Room in which the course meets (building ID and room number) Maximum course enrollment Campus on which the course is held - Name of the course instructor - Number of students currently enrolled and the student ID of each such student - Course status: open (for additional enrollment), closed, or canceled You must be able to change the value of each of these ten data items and, upon request, display all of this information. Initially, the values of the first seven items are known–the last three aren't. Design and implement an abstract data type that can be used to model this university course entity.

Based on the ERD below, display all columns in the JOB table for those job descriptions that have both analysts and engineers within the description name. (Hint: You will use a “Like” phrase.)

A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number • Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale The average price of a computer was sold by the retailer In which months less than 100 computers were sold