Utilize the Outdoor Clubs & Product database to create a procedure "ex5b_supplier_update" that contains two input parameters. The first input parameter is a supplier_id attribute value that is used to delete the supplier from the supplier table. The second input parameter is also another supplier_id attribute value that is used to update the deleted supplier entry (of the first input parameter) in the product and purchase_order table with a new supplier value. Create a boolean function "ex5b_supplier_exist" to determine if the two input parameter supplier_id attribute values exists before proceeding with the data manipulations. If the suppliers do not exist, then display a message "Invalid Suppliers. Run program unit again!." If the supplier does exist, then after completing the manipulations display the product_id attribute values that have the new updated supplier entry. Save the procedure and function source as separate script files.

3. (6 pts) internally in the computer, with few exceptions, all numerical computation is done using binary numbers. output, however, often uses ascii, which is formed by appending 011 to the left of a bcd code. thus, an algorithm that directly converts a binary integer to a bcd integer is very useful. here is one such algorithm 1) draw lines to the left of the binary number to bound the expected bcd decades. (each decade is a group of 4 bits.) move the binary number one bit to the left. add 0011 to each bcd decade containing a binary value> 0100 repeat steps 2-3 until the last bit in the binary number has been moved into the least significant decade position. (note that when the last bit has been shifted into bcd decade, step 3 is not repeated.) read the bcd result. 2) 3) 4) 5) a) execute the algorithm for the binary number 1101101 b) execute the algorithm for the binary number 01110101110 4. (4 pts) represent the decimal number 3568 in bcd; excess-3 code; ascil; and hex.

Using least squares fitting, you are to fit the data sets to the following models and solve for the parameters ai , where i is the index of the parameter. the input/output data for the systems are linked in the bblearn site. for each of the systems use matlab to plot the supplied data vs. the model fit on one plot. include your code in the solutions. (a) linear fit "lineardata. mat" y=a1x^3 + a2x^2 + a3x + a4 (b) plant fit "plantdata. mat g(s) = a1/(s + a2)

Technician a says engine assemblies can be mounted longitudinally in a chassis. technician b says engine assemblies can be mounted transversely in a chassis. who is correct?