1. Write the following queries in SQL, using the university schema. a. Find the

Question

1. Write the following queries in SQL, using the university schema.

a. Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result.

b. Find the IDs and names of all students who have not taken any course offering before spring 2009.

c. For each department, nd the maximum salary of instructors in that department. You may assume that every department has at least one instructor.

d. Find the lowest, across all departments, of the per-department maximum salary computed by the preceding query.

2. List two reasons why null values might be introduced into the database.

3. What are two advantages of encrypting data stored in the database?

4. Explain following terms in brief;

    a. Cookie

    b. Audit Trial

    c. Single Sign-on

Explanation / Answer

1. Write the following queries in SQL, using the university schema. a. Find the

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.