Given the following database representation: WorksOn Database: Note: Using the description provided above, answer the fo
Posted: Fri Jul 01, 2022 5:37 am
Given the following database representation:
WorksOn Database:
Note:
Using the description provided above, answer the followingquestions:
A. What does the following SQL query do/ return?
SELECT ename
FROM employees
WHERE deptno = 'D1'
ORDER BY salary DESC
B. In the above (WorksOn) database, create a list of allsecondary/foreign keys, the table name where each of thesekeys belongs, and which primary key each secondary key referencesin the other table (state the other table name), in youranswer follow the format in the example below:
WorksOn Database:
Note:
Using the description provided above, answer the followingquestions:
A. What does the following SQL query do/ return?
SELECT ename
FROM employees
WHERE deptno = 'D1'
ORDER BY salary DESC
B. In the above (WorksOn) database, create a list of allsecondary/foreign keys, the table name where each of thesekeys belongs, and which primary key each secondary key referencesin the other table (state the other table name), in youranswer follow the format in the example below: