An artificial neural network consists of only two layers. Three neurons are in the input layer and (0.1' one in the output layer. The initial weights are w =( 0.1 \0.1. Use the following algorithm to determine the new weights after one iteration for an input x = (9.0) 6.0 if the desired output is 0. 1 Use f(net)= 1+ net = Ex,w. %3D %3D - net e Let the learning factor } = 1.0 Solution: 1- Calculate the actual output actual _output =f(net) = %3D 2- Calculate the differentiation of f (net) at the output neuron f(net) =f(net) (1-f(net)) = 3- Calculate the error term at the output neuron 8 = (desired – actual _output)'f (net) = 4- Update the weights (there are 3 weights to be updated) AW=G * input * 8 Wnew = Wold+AW

Function is in pl/sql

C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…

Determine the kind of books in the library's current collection. Each category should include just a single entry.