Answer all the question in Oracle Database. 

Kindly write simple notes, it makes easy for me to understand and for revision. 

In Oracle Database.

 

Transcribed Image Text:

Consider the following relations for a database that keeps track of employees' involvement in the project and their dependents. EMPLOYEE (ENumber, EName, BirthDate, Address, Salary, DNumber) DEPARTMENT (DNumber, DName, EmpManager) DEPENDENT (ENumber, DepNum, DepName, Relationship) WORK ON (ENumber, PNumber, Hours) PROJECT (PNumber, PName, PLocation, DNumber) a. Retrieve all information of the employee(s) whose salary is between RM3000 and RM4000. b. Retrieve the name and address of all employees who work for the "Research" department. c. For every project located in "Shah Alam". list the project number, the controlling department number, and the department manager's name and birth date. d. Display the names of all employees who did not have any dependents. e. Retrieve the project number, the project name, and the number of employees who work on the project more than five employees. f. Create table DEPENDENT with integrity requirements. Consider the following relations for a database that keeps track of employees' involvement in the project and their dependents. EMPLOYEE (ENumber, EName, BirthDate, Address, Salary, DNumber) DEPARTMENT (DNumber, DName, EmpManager) DEPENDENT (ENumber, DepNum, DepName, Relationship) WORK ON (ENumber, PNumber, Hours) PROJECT (PNumber, PName, PLocation, DNumber) a. Retrieve all information of the employee(s) whose salary is between RM3000 and RM4000. b. Retrieve the name and address of all employees who work for the "Research" department. c. For every project located in "Shah Alam". list the project number, the controlling department number, and the department manager's name and birth date. d. Display the names of all employees who did not have any dependents. e. Retrieve the project number, the project name, and the number of employees who work on the project more than five employees. f. Create table DEPENDENT with integrity requirements.