Specify and execute the following queries for the database

Assignment Help Basic Computer Science

Reference no: EM131054216

Specify and execute the following queries for the database in Exercise 3.16 using the RA interpreter.

a. Retrieve the names of students who have enrolled in a course that uses a textbook published by Addison-Wesley.

b. Retrieve the names of courses in which the textbook has been changed at least once.

c. Retrieve the names of departments that adopt textbooks published by Addison-Wesley only.

d. Retrieve the names of departments that adopt textbooks written by Navathe and published by Addison-Wesley.

e. Retrieve the names of students who have never used a book (in a course) written by Navathe and published by Addison-Wesley.

Reference no: EM131054216

Questions Cloud

List the names of employees who work on every project : List the names of employees who work on every project.

Current estimate of the volatility : Suppose that the current estimate of the volatility is 1.6% per day and the most recent percentage change in the market variable is 1%.What is the new variance estimate?

What would happen if one the steps were missing : 1. Examine the various steps of a research design and indicate the value that each step brings to the process. what would happen if one the steps were missing? Could these steps occure in a different order?

Question regarding the break-even point : A corporation sold X units of product for $Y each and has $M in total fixed and $L in total variable costs (a) find its break-even point (in units) in terms of L, M, X and Y. (b) use any part of or all of your answer to part (a) to find profit ear..

Specify and execute the following queries for the database : Retrieve the names of students who have enrolled in a course that uses a textbook published by Addison-Wesley.

Approach versus the other : One of the key issues in valuation is whether to value just the equity portion of a firm or to value the entire enterprise. What are the arguments on both sides of this issue. Again, discuss what types of companies/situations might be best suited ..

Bonds expected rate of return : The market price is 1000 for a nine year bond ($1000 par value) that pays 11 percent interest (5.5 percent semiannually). What is the bonds expected rate of return?

Determining the required rate of return : Shelly Inc. bonds have a coupon rate of 8 percent. The interest is paid semiannually, and the bonds mature in 7 years. Their par value is 1000. If your required rate of return is 15 percent, what is the value of the bond? What is the value if the ..

Question regarding the average real return on the stock : You've observed the following returns on SkyNet Data Corporation's stock over the past five years: 13 percent, -8 percent, 16 percent, 16 percent, and 10 percent. Suppose the average inflation rate over this period was 1.5 percent, and the average..

User Account

All Pages