Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is the second time that I submit this project, the solution was wrong, if you would be so kind to solve the project for

image text in transcribed

This is the second time that I submit this project, the solution was wrong, if you would be so kind to solve the project for me correctly and completely and in SQL language with a screenshot of the output and the code written and photographed, please, please, please, please, please. SQL SQL SQL CODE CODE CODE PLZ ..

1- Create new user 2- Give the user privileges such as (CONNECT, RESOURCE, DBA...) 3-Use the new account that you created. (connect to DB using this user) 4-Save all SQL commands and the Output of these commands Project: Write the correct SQL commands to do the following: Given a company that have many departments each with (department id, name) each department contains many employees with employee id, employee name, salary, hire_date, job_id and department_id) and Jobs (jobid, jobnam) Department Employee DeptiD DeptNam DeptLocation empid 1 1 1 3 SE Building 10 4 Multimedia Building 11 4 Zarga Networks 5 1 Building 12 02/02/2002 2 empades deptid obid CS CIS empNam All Ahmad Salary 90 Amman 1 omdat 01/01/2019 15/03/2018 10/11/2003 1010 Aqaba 2 3 4 3 3 Sami 300 3 2 3 All 500 6 5 6 5 85 Irbid 01/01/2020 1 AI Rami Ahmad Ahmad Ali 5 4 600 Karak 2 Job jobld jobNam 1 Manager 2 Accountant 3 Driver 4 Supervisor 5 HR 6 Project manager 7 7 8 8 Generate the required relations (tables) for this company, and build the relationship betweenthem when needed. Create the above ratio and specify the type of each field (..., date, varchar2, number) and create relationships between the ratio as needed and must be taken into account Consider the following limitations: The name of the department must be entered without repetition the employee's name must be entered Appointment date must be entered. Determine the field that is used (primary key (and fields) foreign master) in the above ratio. Find the suitable primary keys and foreign keys. Build the suitable constraints for each table. Salary must be greater than 260 and less than 1500. 2) Add new attribute to department table as location. 3) Add new attribute to employee table called employee address) 4) List down the tables created in your user account. 5) List down each table description. 6) Insert the following data for each table. 7) Display department information. 8) Retrieve employee number and employee name and salary for all employees that have a salary within (750, 1200) 9) Return all employee names with addresses that contains Amman 10) List down all department without location 11) Modify all salaries less than 260 to become 260 JOD. 12) Modify all empty department locations to become Amman. 13) Remove all job records with empty job name. 14) List employee name and salary that works for department id = 1. 15) List employee name and salary that works for department name = SE 16) Find all the department numbers that have employees. 17) List employee name and Job name for all employees in department 1. 18) List employee name and department name and Job name for all employees. 1- Create new user 2- Give the user privileges such as (CONNECT, RESOURCE, DBA...) 3-Use the new account that you created. (connect to DB using this user) 4-Save all SQL commands and the Output of these commands Project: Write the correct SQL commands to do the following: Given a company that have many departments each with (department id, name) each department contains many employees with employee id, employee name, salary, hire_date, job_id and department_id) and Jobs (jobid, jobnam) Department Employee DeptiD DeptNam DeptLocation empid 1 1 1 3 SE Building 10 4 Multimedia Building 11 4 Zarga Networks 5 1 Building 12 02/02/2002 2 empades deptid obid CS CIS empNam All Ahmad Salary 90 Amman 1 omdat 01/01/2019 15/03/2018 10/11/2003 1010 Aqaba 2 3 4 3 3 Sami 300 3 2 3 All 500 6 5 6 5 85 Irbid 01/01/2020 1 AI Rami Ahmad Ahmad Ali 5 4 600 Karak 2 Job jobld jobNam 1 Manager 2 Accountant 3 Driver 4 Supervisor 5 HR 6 Project manager 7 7 8 8 Generate the required relations (tables) for this company, and build the relationship betweenthem when needed. Create the above ratio and specify the type of each field (..., date, varchar2, number) and create relationships between the ratio as needed and must be taken into account Consider the following limitations: The name of the department must be entered without repetition the employee's name must be entered Appointment date must be entered. Determine the field that is used (primary key (and fields) foreign master) in the above ratio. Find the suitable primary keys and foreign keys. Build the suitable constraints for each table. Salary must be greater than 260 and less than 1500. 2) Add new attribute to department table as location. 3) Add new attribute to employee table called employee address) 4) List down the tables created in your user account. 5) List down each table description. 6) Insert the following data for each table. 7) Display department information. 8) Retrieve employee number and employee name and salary for all employees that have a salary within (750, 1200) 9) Return all employee names with addresses that contains Amman 10) List down all department without location 11) Modify all salaries less than 260 to become 260 JOD. 12) Modify all empty department locations to become Amman. 13) Remove all job records with empty job name. 14) List employee name and salary that works for department id = 1. 15) List employee name and salary that works for department name = SE 16) Find all the department numbers that have employees. 17) List employee name and Job name for all employees in department 1. 18) List employee name and department name and Job name for all employees

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

Which are non projected Teaching aids in advance learning system?

Answered: 1 week ago

Question

How do Excel Pivot Tables handle data from non OLAP databases?

Answered: 1 week ago