Please written by computer source 1. For this project, you need to create the company database and populate it with the data given in the Oracle SQL PLUS environment (if you have not done so) 2. Your SQL commands should be placed in file(s) and run from the file(s). 3. Implement Triggers on all the tables to change character data to uppercase in the character data type columns. 4. Implement a Function that returns Dname from Department for any give employee. The parameter to the function would be the SSN. 5. Implement a Function that returns manager’s full name for any given department. The parameter to the function would be the department name. 6. Implement another Function that returns manager’s full name for any given department. The parameter to the function would be the department number. 7. Implement a Procedure that increases an employee salary by x%. Employee is identified by SSN and the percentage of increase is given as an input. 8. Implement a Package that contains the following methods: - Count the number of dependents for a particular valid employee – ssn is the input (test first if the employee ssn is valid). - Average number of dependents of employees working for a particular valid department – department name is the input (test first if the department name is valid). - Remove a dependent for a particular valid employee – ssn, dependent_name are the input (need to test first if the employee ssn is valid).
Please written by computer source
1. For this project, you need to create the company
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
