Provide SQL instructions for each of the following questions 1. Create the database schema.
2. Find the name of professors that work for the cs department.
3. Find those students (sid) enrolled in courses in the cs department.
4. List ssn and name of profes

In this lab, you complete a prewritten c program that calculates an employee’s productivity bonus and prints the employee’s name and bonus. bonuses are calculated based on an employee’s productivity score as shown below. a productivity score is calculated by first dividing an employee’s transactions dollar value by the number of transactions and then dividing the result by the number of shifts worked.