Question Consider the below schema of the university database (keys are in bold and underline): • Students(stuID: Integer, stuName: String, gender: String, age: Integer, gpa: Float) • Departments(deptName: String, numPhDs: Integer) • ProfessorWorks(profID: Integer, profName: String, deptName: String) • CoursesOffer(cNo: String, cTitle: String, deptName: String) • Majors(deptName: String, stuID: Integer, degreeProgram: String; attendYear: String, attendSemester: String) • Sections(cNo: String, academicYear: String, semester: String, sectNo: Integer, profID: Integer) • Enrolls(stuID: Integer, cNo: String, academicYear: String, semester: String, sectNo: Integer, grade: String) Write the following queries in Relational algebra. Turn in your work to the assignment link. 1. Print the name(s) and sid(s) of the student(s) enrolled in more than three classes in Fall 2016. 2. Print the age difference between the oldest and youngest student(s). 3. Print the age difference between the oldest and youngest student(s) per department. 4. Print the name(s) and GPA(s) of student(s) who major in B.S. in Information Technology in the Computer Technology department, attending the program after Fall 2015. Note that B.S. in Information Technology, Computer Technology, 2013, and Spring are a degree program, a department name, an attending year, and an attending semester, respectively. 5. Find the names of students who have not enrolled in any course yet Fall 2016.

A two-story industrial building includes a factory floor in the ground and open plan office on the first floor. The ground floor area is 150m x 150m with ceiling height of 8m and the upper office area is 50m x 150m with ceiling of 4 m high. This factory contains 250 machines that need to be monitored and controlled from a control system (control algorithm running from a computer server) located in the control room upstairs. Furthermore, the workers in offices need to communicate and exchange information with each other as well as supervisors in the factory floor below. Task is to design a communication network to satisfy the different communication requirements of this scenario. Following are the data rate requirements of the system: 1. Each machine has sensors that generate data at a rate of 10 Mbps for 2 minutes, 8 times every hour and the amount of data coming from the control system back to the machines is at 10 kbps. There are 180 computers in the office and each needs to download 5 Mbytes of data every 10 minutes and 20 kbps upload speed. Assume half the communication is with the outside world. 2. 25 supervisors in the factory floor need to have 10 Mbps downlink (to monitor some machines) and 2 Mbps uplink speeds. What is the general capacity of the equipment required? You are not required to find the exact data requirements. The goal is to get a general feel for the dimension of the network based on blocking probability studies. For example, is 10Mbps capacity enough for the network? Think about factors you would consider in designing a network and justify your answer based on these factors. What is the size of this network?

Accrued Product Warranty Harbour Company disclosed estimated product warranty payable for comparative years as follows: (in millions) Current Year Prior Year Current estimated product warranty payable $13,350 $12,800 Noncurrent estimated product warranty payable 8,120 7,157 Total $21,470 $19,957 Assume that Harbour's sales were $157,449 million in current Year and that the total paid on warranty claims during the current year was $13,763 million a. The distinction between short- and long-term liabilities is important to creditors in order to accurately evaluate the near-term cash the business relative to the quick current assets and other longer-term b. Provide the journal entry for the current Year product warranty expense. Enter your answers in millions. If an amount box does not require an entry, leave it blank. c. What two conditions must be met in order for a product warranty liability to be reported in the financial statements?

7. = = Fig. Q5 shows a convolutional neural network architecture. We have in the first layer a one-dimensional convolution with a single filter of size 3 such that hi s({}=1 V; Xi+j-1). The second layer is fully connected, such that z = {i=1 W;hi. The hidden units' activation function s(x) is the sigmoid function. The output unit is linear with no activation function. We perform gradient descent on the loss function L = (y – z)2 where y is the training label for x. X2 W h2 W3 h3 W4 ht Fig. Q7 (a) What is the total number of parameters in this neural network? Note that convolutional layers share weights and there are no bias terms. (b) Backpropagation is a widely used algorithm for training feedforward neural networks. Briefly describe how backpropagation works. (c) Compute awi al

Payroll System Using Inheritance and PolymorphismYou need to implement the following harder file and classes. 1. Define the following constants in a header file called Employee.hFACULTY_MONTHLY_SALARY = 5000.00STAFF_MONTHLY_HOURS_WORKED = 1602. Implement an abstract class Employee with the following requirements:Attributeslast name (String)first name (String)ID number (String)Default argument constructor and argument constructors.Public methodsputData that displays the following information:ID Employee number :_________Employee name: __________pure virtual method monthlyEarning that returns the monthly earning. 3. Implement a class called Staff extending from the class Employee with the following requirements:AttributeHourly rateDefault argument and argument contructorsPublic methodsget and setThe method monthlyEarning returns monthly salary (hourly rate times 160)putData that displays the following information:ID Employee number :_________Employee name: __________Full TimeMonthly Salary: _________4. Implement a class Education with the following requirements:AttributesDegree (MS or PhD ) String typeMajor (Engineering, Chemistry, English, etc ... ) String typeResearch (number of researches)Default argument and argument constructors.Public methodsget and setImplement a class Faculty extending from the class Employee with the following requirements:AttributesLevel (use enum statement)"AS": assistant professor"AO": associate professor"FU": professorEducation objectDefault argument and argument constructorPublic methodsget and setThe method monthlyEarning returns monthly salary based on the faculty's level.AS - faculty monthly salaryAO - 1.2 times faculty monthly salaryFU - 1.4 times faculty monthly salaryputData that displays the following information:ID Employee number :_________Employee name: __________XXXXX Professor where XXXXX can be Assistant, Associate or FullMonthly Salary: _________Implement a class called Partime extending from the class Staff with the following requirements:AttributesHours worked per weekDefault argument and argument constructorsPublic methodsset and getThe method monthlyEarning returns monthly salary which hourly rate multiplied hours worked per week multiplied four.putData that displays the following information:ID Employee number :_________Employee name: __________Hours works per month: ______Monthly Salary: _________Implement a test driver program that creates an array or a vector of class Employees to store the objects Staff, Faculty, and Partime.Using polymorphism, display the following outputs:a. Employee information using the method putData. All employees StaffFacultyPart-timeb. Total monthly salary for all employees.Use the following data to create Employee objects in your program. StaffLast name: AllenFirst name: PaitaID: 123Hourly rate: $50.00Last name: ZapataFirst Name: StevenID: 456Hourly rate: $35.00Last name:RiosFirst name:EnriqueID: 789Hourly rate: $40.00FacultyLast name: JohnsonFirst name: AnneID: 243Level: FullDegree: Ph.DMajor: EngineeringReseach: 3Last name: BourisFirst name: WilliamID: 791Level: AssociateDegree: Ph.DMajor: EnglishReseach: 1Last name: AndradeFirst name: ChristopherID: 623Level: AssistantDegree: MSMajor: Physical EducationResearch: 0Part-timeLast name: GuzmanFirst name: AugustoID: 455Hourly rate: $35.00Hours worked per week: 30Last name: DepirroFirst name: MartinID: 678Hourly rate: $30.00Hours worked per week:15Last name: AldacoFirst name: MarqueID: 945Hours worked per week: 35Runtime output ID Employee number: 123Employee name: Paita AllenFull TimeMonthly Salary: 8000ID Employee number: 456Employee name: Steven ZapataFull TimeMonthly Salary: 5600ID Employee number: 789Employee name: Enrique RiosFull TimeMonthly Salary: 6400ID Employee number: 243Employee name: Anne JohnsonFull ProfessorMonthly Salary: 7000ID Employee number: 791Employee name: William BourisAssociate ProfessorMonthly Salary: 6000ID Employee number: 623Employee name: Christopher AndradeAssistant ProfessorMonthly Salary: 5000ID Employee number: 455Employee name: Augusto GuzmanHours work per month: 120Monthly Salary: 4200ID Employee number: 678Employee name: Martin DepirroHours work per month: 60Monthly Salary: 1800ID Employee number: 945Employee name: Marque AldacoHours work per month: 140Monthly Salary: 2800Total monthly salary for all employees: $46800

(C++) (can you just make the main.cpp since I already have the employee.h part done) Payroll System Using Inheritance and PolymorphismYou need to implement the following harder file and classes. 1. Define the following constants in a header file called Employee.hFACULTY_MONTHLY_SALARY = 5000.00STAFF_MONTHLY_HOURS_WORKED = 1602. Implement an abstract class Employee with the following requirements:Attributeslast name (String)first name (String)ID number (String)Default argument constructor and argument constructors.Public methodsputData that displays the following information:ID Employee number :_________Employee name: __________pure virtual method monthlyEarning that returns the monthly earning. 3. Implement a class called Staff extending from the class Employee with the following requirements:AttributeHourly rateDefault argument and argument contructorsPublic methodsget and setThe method monthlyEarning returns monthly salary (hourly rate times 160)putData that displays the following information:ID Employee number :_________Employee name: __________Full TimeMonthly Salary: _________4. Implement a class Education with the following requirements:AttributesDegree (MS or PhD ) String typeMajor (Engineering, Chemistry, English, etc ... ) String typeResearch (number of researches)Default argument and argument constructors.Public methodsget and setImplement a class Faculty extending from the class Employee with the following requirements:AttributesLevel (use enum statement)"AS": assistant professor"AO": associate professor"FU": professorEducation objectDefault argument and argument constructorPublic methodsget and setThe method monthlyEarning returns monthly salary based on the faculty's level.AS - faculty monthly salaryAO - 1.2 times faculty monthly salaryFU - 1.4 times faculty monthly salaryputData that displays the following information:ID Employee number :_________Employee name: __________XXXXX Professor where XXXXX can be Assistant, Associate or FullMonthly Salary: _________Implement a class called Partime extending from the class Staff with the following requirements:AttributesHours worked per weekDefault argument and argument constructorsPublic methodsset and getThe method monthlyEarning returns monthly salary which hourly rate multiplied hours worked per week multiplied four.putData that displays the following information:ID Employee number :_________Employee name: __________Hours works per month: ______Monthly Salary: _________Implement a test driver program that creates an array or a vector of class Employees to store the objects Staff, Faculty, and Partime.Using polymorphism, display all employees using the method putData. Use the following data to create Employee objects in your program. StaffLast name: AllenFirst name: PaitaID: 123Hourly rate: $50.00Last name: ZapataFirst Name: StevenID: 456Hourly rate: $35.00Last name:RiosFirst name:EnriqueID: 789Hourly rate: $40.00FacultyLast name: JohnsonFirst name: AnneID: 243Level: FullDegree: Ph.DMajor: EngineeringReseach: 3Last name: BourisFirst name: WilliamID: 791Level: AssociateDegree: Ph.DMajor: EnglishReseach: 1Last name: AndradeFirst name: ChristopherID: 623Level: AssistantDegree: MSMajor: Physical EducationResearch: 0Part-timeLast name: GuzmanFirst name: AugustoID: 455Hourly rate: $35.00Hours worked per week: 30Last name: DepirroFirst name: MartinID: 678Hourly rate: $30.00Hours worked per week:15Last name: AldacoFirst name: MarqueID: 945Hours worked per week: 35Runtime output ID Employee number: 123Employee name: Paita AllenFull TimeMonthly Salary: 8000ID Employee number: 456Employee name: Steven ZapataFull TimeMonthly Salary: 5600ID Employee number: 789Employee name: Enrique RiosFull TimeMonthly Salary: 6400ID Employee number: 243Employee name: Anne JohnsonFull ProfessorMonthly Salary: 7000ID Employee number: 791Employee name: William BourisAssociate ProfessorMonthly Salary: 6000ID Employee number: 623Employee name: Christopher AndradeAssistant ProfessorMonthly Salary: 5000ID Employee number: 455Employee name: Augusto GuzmanHours work per month: 120Monthly Salary: 4200ID Employee number: 678Employee name: Martin DepirroHours work per month: 60Monthly Salary: 1800ID Employee number: 945Employee name: Marque AldacoHours work per month: 140Monthly Salary: 2800

a. Bank A offers three-year loans at 3.6% compounded quarterly. What nominal interest rate compounded monthly would a local bank have to offer you so that you would not be disadvantaged by choosing it? % Round to two decimal places b. Bank B offers four-year loans at 4.8% compounded monthly. What nominal interest rate compounded semi-annually would a local bank have to offer you so that you would not be disadvantaged by choosing it? % Round to two decimal places