see see attached

1 answer below »

see see attached

module-four-lab-guidelines-and-rubrichtml-gj5qjml2.zip

Answered 3 days After May 28, 2022

Solution

Mohd Abas answered on Jun 01 2022

93 Votes

1. Retreve employees information :
Describe employees;
A. Select employees from san Francisco and New York
SQL Command:
SELECT firstName, lastName, jobTitle,offices.city
FROM employees                                 INNER JOIN offices
ON
Employees.officeCode = offices.officeCode
    WHERE offices.state ='CA';
Office.state = New York:
SQL COMMAND:
SELECT firstName, lastName, jobTitle, offices.city
FROM employees                                 INNER JOIN offices
ON
Employees.officeCode = offices.officeCode
    WHERE offices.state ='NY';
2. Retrieve Order details :
Description of Order Table:
A. Retrieve order details using select query with WHERE clause:
SQL Command:
SELECT * From orders where orderNumber = 10330;
SELECT * From orders where orderNumber = 10338;
SELECT * From orders where orderNumber = 10194;
B. Validating the query A by screenshots above attached.
C. Identifying Cardinality using ERD:
D. ..
3. Delete Record from payment table for customerNumber = 103;
A. Describe statement to identify the fields of payments Table:
SQL Command used:
Describe payments;
B. Select payment records for customerNumber = 103
SQL Command:
Select * From payments where customerNumber =103;
C. Delete the records for customerNumber = 103:
SQL Command :
DELETE from payments where customerNumber=103;
D. Select records to validate that customerNumber=103;
4. Retereive customer records using select From ,inner join, and where:
B. Use Ba
y’s employeeNumber=1504 and perform join between customer and...

SOLUTION.PDF

see see attached

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment