Consider the following view, dept_summary, defined on the company database in figure 5.6: create view dept_summary (d, c, total_s, average_s) as select dno, count (*), sum (salary), avg (salary) from employee group by dno; state which of the following queries and updates would be allowed on the view. if a query or update would be allowed, show what the corresponding query or update on the base relations would look like, and give its result when applied to the database in figure 5.6.
a. select * from dept_summary;
b. select d, c from dept_summary where total_s > 1; 238 chapter 7 more sql: complex queries, triggers, views, and schema modification.
c. select d, average_s from dept_summary where c > ( select c from dept_summary where d = 4);
d. update dept_summary set d = 3 where d = 4; e. delete from dept_summary where c > 4;

This first part of the film shows the early history of motion pictures. how accurate do you think the portrayal of the early motion picture industry is? why? is historical accuracy important in films and theatre productions? explain. in the scene where don is going to the party (starting at time code 14: 51), we see a street scene as he first rides with cosmo and then with kathy. what aspects did the filmmaker include to make the scene look and feel like don, cosmo, and kathy are riding in a car on a street? think about elements such as scenery, sound, props, lighting, and so on. a "talkie" picture is shown starting around time code 21: 15. how does the audience in the film react to the "talkie"? what influence do audiences have on film and theatre performances? how do film and theatre actors influence audiences? in the musical scene with cosmo (starting at time code 27: 00), how does the actor use props? what is the result? do you think the use of props effectively fulfilled the artistic vision for this musical number? why or why not?

What part of the interface displays the external references contained in a selected cell? the status bar the review tab the scroll bar the formula bar

The value of sin(x) (in radians) can be approximated by the alternating infinite series create a function (prob3_2) that takes inputs of a scalar angle measure (in radians) and the number of approximation terms, n, and estimates sin(x). do not use the sin function in your solution. you may use the factorial function. though this can be done without a loop (more efficiently), your program must use (at least) one. you may find the mod() function useful in solving the problem.