Suppose you have created tables in assignment 1 as follows Tables: Company(cid, cname, city, state) /* city is the company’s location, cname is state) /* city is the company’s location, cname is company name */ Employee(eid, ename, street, city, state, salary, cid) /* city is where the employee lives*/
Manages(eid, mid) /* mid is manager’s ID*/ Please write PL/SQL program for the following problems.
1: Please create a PL/SQL procedure that given a company name, print out names of employees working at that company. Test your procedure with a company name you have in your company table. 2: Please create a PL/SQL function get_manager that returns the manager’s mid given the name of an employee. If an employee does not have a manger, return a null value. Please write an anonymous PL/SQL program to call this function with some employee name as input, and print out the results. You can assume that each employee has at most one manager.
We can offer a similar ASSIGNMENT at a reasonable price. All our papers are written from the scratch and 100% plagiarism free.