Question: Specify the following views in SQL on the COMPANY database schema. a. A view that has the department name, manager name, and manager salary for

Specify the following views in SQL on the COMPANY database schema.

Specify the following views in SQL on the COMPANY database schema.

a. A view that has the department name, manager name, and manager salary for every department.

b. A view that has the employee name, supervisor name, and employee salary for each employee who works in the ling department name, number of employees, and total hours worked per week on the project for each project.

d. A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project with more than one employee working on it.

Figure 3.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Frame | Minit | Lname Boate Address Sex | Salary Super-san IDno Smith | 123456789 | 1965-01-09 1731 Fondren, Houston, TX! M 13 33445555 5 Frankin! T ng | 333445555| 1955-12081638 Voss, Hou n,TX | M140 988665555 5 Alicia | J | Zelaya | 999837777|1968-01-19|3321 Castie Spring, TX F |25 Jennifer S Waace | 987654321 | 1941-06-20 1 Berry, Be are, TX Ramesh K Narayan 6668844441 1962-09-151975 Fire Oak. Hmble, TX | M |380 3334 455 Joyce | A ligsh | 453453453| 1972-07-3115631 Rice, Heaton, TX F 1250 333445555 Ahmad V laccar | 987987987 | 1969-03-29 Dallas, Houston, TX | M | 250 987654321 | 4 James | E | Borg |888665555| 1937-11-101450 Stone, Houston, TX | M |55000|NULL DEPARTMENT DEPT-LOCATIONS On umber gr_ssn MF-start-date 333445555 1988 0522 Houston Administration 987654321 1995-01-01 Stanard 1981-06-19 Sugarland Houston WORKS-ON PROJECT Pr umber Plocation Dunn 123456789 123456789 75 ProductY Sugarland 666884444 40.0 Produc Houston 453453453 20.0 Computerization! 10 Stafford 458453453 20.0 anation 333445555 10.0 Newbee its 30 Stafford 333445555 10.0 333445555 10.0 DEPENDENT 333445555 20 | 10.0 Dependentiame | Sex- Bdate Relationship 999887777 30.0 333445555 | Aice 1986-0405 | Daughter 999887777 10.0 333445555 Theodore M | lg 3-10-25 | S 987987987 35.0 333445555 | Joy 987987987 5.0 987654321 Abner 1942-02-28 | Spouse 987654321 123456789 |Michael 987654321 20 I 15.0 123456789 | Aice 888665555 20 | NULL 123456789 Elizabeth | 1967-05-05 | Spouse ch hn

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!

Q:

Specify the following views in SQL on the COMPANY database schema shown in Figure 5.5. a. A view that has the department name, manager name, and manager salary for every department. b. A view that...

Q:

Specify the following views in SQL on the COMPANY database schema shown in Figure 5.5. a. A view that has the department name, manager name, and manager salary for every department b. A view that has...

Q:

You need to turn-in successfully tested SQL Views/Queries, along with screen-shots - in a single file (of a .sql or .txt or .doc format) for Part I Part l: 1. Specify the following views in SQL on...

Q:

Specify the following views in SQL on the COMPANY database schema shown in Figure 5.5, view that has the department name, manager name, and manager sal- ary for every department A view that has the...

Q:

1 What update anomalies occur in the EMP _ PROJ and EMP _ DEPT relations of figure given below? 2 What are the different types of SQL injection attacks? What preventive measures are possible against...

Q:

The queries you write to create views should be formatted neatly in a style similar to the one used for problem \#1 above: CREATE VIEW AS SELECT , FROM 1> WHERE > IN (SELECT > WHERE 2>; The above...

Q:

Specify the following views in MySQL on the COMPANY database schema shown in Figure 3.5: A view that has the department name, manager name, and manager salary for every department. A view that has...

Q:

ecify the following views in SQL, on the COMPANY database schema shown in Figure 5.5 . A view that has the department name, manager name, and manager sal- ary for every department A view that has the...

Q:

Need help creating views please! Heres how the database is built. 4. (5 points) Specify the following views in SQL on the IDEALHOME database schema 1) Create a view of staff who manage properties for...

Q:

Write the following queries in SQL on the Company Database Schema. ( 1 0 points ) 1 Retrieve the SSN , Fname, and Lname of employees who have more than two dependents. 2 Retrieve the SSN , Fname, and...

Q:

Why is a Walden reductor always used with solutions that contain appreciable concentrations of HCl?

Q:

Assume that the airline industry's 99% upper and lower control limits for the percentage of flights that are not on time are 10% and 4%, respectively. How do these compare with the MackAir's control...

Q:

The Stewart Company has $ 2 , 0 4 7 , 5 0 0 in current assets and $ 7 5 7 , 5 7 5 in current liabilities. Its initial inventory level is $ 4 5 0 , 4 5 0 , and it will raise funds as additional notes...

Q:

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...

Q:

6. All employees have equal opportunities for job rotation assignments, regardless of their demographic group.

Q:

2. Mentor-protg matching process does not limit the ability of informal relationships to develop. For example, a mentor pool can be established to allow protgs to choose from a variety of qualified...

Q:

6. The length of the program is specified. Mentor and protg are encouraged to pursue the relationship beyond the formal time period.