Question: 1-) Write SQL code display the project names and duration days 2-)Write SQL code display all of the employee whose salary is the highest 3-)

1-) Write SQL code display the project names and duration days 2-)Write SQL code display all of the employee whose salary is the highest 3-) Write SQL code display the name and number of employee in each project 4-) Decrease the salary of the employee 1000 TL whose salary is the highest 5-) Delete record of the project(s) from tblPROJECT table whose startDate is in year 2015

B. (Total points: 30) There are 3 tables as described in Figure 1. tbIEMPLOYEE tblEMPPROJECT tbIPROJECT emplD empName job salary_In TL PID pName startDate endDate emplD plD Figure 1. Tables and relationship Content of the table tbIEMPLOYEE empID empName job salary_In TL yk Computer Engineer 10000 Electronics Engineer 7500 Grkem 3AycaIndustrial Engineer 11000 Mechanical Engineer 6000 Industrial Engineer 3000 4 Kaan 5 k Content of the table tbiPROJECT pID pName startDate endDate Mobile phone 2016.12.07 2018.05.24 2018.05.02 2019.07.01 2015.01.05 2019.03.05 Drone 3 Satellite Content of the table tblEMPPROJECT ID empID pID 2 3 5 6 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Answer the following questions: 1- Write SQL code to list all employees who are working more than 17 years.(2 Marks 2 Write SQL code to list all assignments of employee whose first name start with...

1. Write SQL code to create a STUDENT table that includes the following attributes: Student ID First Name Last Name Street Address City State Zip Code Phone Email In the code remember to include data...

CREATE TABLE LOCATION ( Location _ ID INT PRIMARY KEY, City VARCHAR ( 5 0 ) ) ; INSERT INTO LOCATION ( Location _ ID , City ) VALUES ( 1 2 2 , 'New Yo Simple Queries: 1 . List all the employee...

For the conceptual schemata of the database, establish an environment for the execution of simple and advanced queries in Oracle. The global schemata is as below EMP (ENUM, NAME, SAL, TAX, MGR, DNUM)...

DATABASE | PLEASE NEED YOUR OWN ANSWER! DO NOT PROVIDE ME COPIED OR OTHER PEOPLE ASNWER...THANKS Creation of tables: CREATE TABLE place( PLACEID INT PRIMARY KEY, CITY VARCHAR(30), COUNTRY CHAR(2) );...

Worksheet Query Builder select * from staff Worksheet Query Builder select * from place 1 1 2 3 Script Output Query Result SQL | All Rows Fetched: 11 in 0.003 seconds STAFFID FNAME 1 LNAME SALARY 95...

DATABASE: Creation of tables: CREATE TABLE place( PLACEID INT PRIMARY KEY, CITY VARCHAR(30), COUNTRY CHAR(2) ); CREATE TABLE staff( STAFFID INT PRIMARY KEY, FNAME VARCHAR(30), LNAME VARCHAR(30),...

Write SQL code for the following queries. please do it fast within an hour. Patient Doctor Pld P_Name Gender Age D ld D_Fname D_Lname Salary City 1 Aqib Male 25 1 Laiba Hafeez 50000 Rwp 2 Saima...

Create a query that retrieves total number of allergies per patient. Your query must display patient first and last names. Your output must resemble the one below Question 1 [05] Create a query that...

Moon Hardware is planning to factor some of its receivables. The cash received will be used to pay for inventory purchases. The factor has indicated that it will require recourse on the sold...

Country or sovereign risk may be caused by the actions of a foreign government that affect the business environment in that country. True false question. True False

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

5. Wyeth Pharmaceuticals

2. Go to www.quality.nist.gov, the Web site for the National Institute of Standards and Technology (NIST). The NIST oversees the Malcolm Baldrige Quality Award. Click on Criteria for Performance...

4. Conduct a phone or personal interview with a manager. Ask this person to describe the role that training plays in his or her company.