SQL query and Oracle database design help needed

25 pts.
Tags:
Database design
Oracle development
Oracle SQL
SQL
SQL queries
Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the school as the scope is very huge. (1)one employee can be in many departments(1 TO MANY) and and each department has one manager.(1 to 1) --Created a table for EMPLOyee and department---RELATIONSHIP ---> empl_id and dept_id (2)Also,an employee can work in multiple items/projects(1-MANY) at a time. And a project HAS only one department.(1 to 1) **Projects table created has codes,the Project name ,Planned budget cost/amount, start_date and end_date AND DEPART_ID --Also,Created a table for Project and Employee---RELATIONSHIP ---> proj_id and employee_id This is the full scenario has put above.So,i needed help as I am very confused if i have done the correct relationships. And,these below items are my plans to allow the schema nd tables support it. (2)how will a person see all his manager?***A person can have 2,3 managers.(EMP->MANAGER relationship TABLE) (3)SQL to be able to show a person--->manager-->and their manager's MANAGER (4)How will managers to view all employees reporting to him. (5)SQL to support the increase of salaries of employees in a department by percentage or amount wise. (6)SQL to update or change manager of a department/employee. (7)If a employee is removed-then all related details should also be removed. (8)to remove person and department,terminate a person from organisation SHIFTING a person to different department,assign a person to a department Projects /Job table EMPLOYEES TABLE-> SALARY info --job_id --Project_name --Budget Amount

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following