Answered step by step
Verified Expert Solution
Question
1 Approved Answer
HR - Entity Relationship Diagram REGIONS EMPLOYEES JOBS employee_id job_id NUMBER regionid NUMBER (6.0) VARCHAR2(10) VARCHAR2/35) NOT NULL first_name job_title VARCHAR2(20) NOT NULL region_name VARCHAR2(25)
HR - Entity Relationship Diagram REGIONS EMPLOYEES JOBS employee_id job_id NUMBER regionid NUMBER (6.0) VARCHAR2(10) VARCHAR2/35) NOT NULL first_name job_title VARCHAR2(20) NOT NULL region_name VARCHAR2(25) last_name VARCHAR2(25) NOT NULL min_salary NUMBER(6,0) emal VARCHAR2(25) NOT NULL max_salary NUMBER(6,0) phone_number VARCHAR2:20) COUNTRIES hire_date DATE NOT NULL country_id CHAR(2) VARCHAR2(10) NOT NULL job_id Salary NUMBER(82) country_name VARCHAR2(25) region_id NUMBER commissiom_pat NUMBER(2, 2) - manager_id NUMBER[6, 0) department_id NUMBER(4.0) LOCATIONS JOB HISTORY DEPARTMENTS employee_id NUMBER(6,0) start_date DATE NOT NULL location id NUMBER 4 0 street address VARCHAR2(40) postal_code VARCHAR2(12) VARCHAR2(30) NOT NULL state province VARCHAR225) Los department_id NUMBER40) department_name VARCHAR2(30) NOT NULL manager_id NUMBER(6,0) location_id NUMBER (4,0) end_date DATE NOT NULL job_id VARCHAR(10) NOT NULL department_id NUMBER (4,0) country_id CHARIZ) Q3. Write a query to show the average salary at each location of all the employees who work in shipping or accounting Q4. Write a query to show the number of employees in each country except for Canada (ie don't show Canada in your result). Q5. A data row in relational database is equivalent to which of the following in MongoDB: a. A record b. An object c. A class d. A document e. A collection
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started