Question: Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all

Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are greater than or equal to $10,000.
a. Using SQL, write the view definition for TopLevelCust.
b. Write an SQL query to retrieve the number and name of all customers as well as the difference between their credit limit and balance in the TopLevelCust view.
c. Convert the query you wrote in Question 2b to the query that the DBMS will actually execute.

Step by Step Solution

★★★★★

3.41 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a CREATE VIEW TopLevelCust AS SELECT CustomerNum CustomerName Str... View full answer

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 Database Concepts Questions!

You need to delete the Order Line table from the TAL Distributors database. Will the following command work? Why or why not?

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. In each step, indicate how to use relational algebra to obtain the desired results. 1. List the...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are...

Using data from the Premiere Products database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are...

Create the TopLevelCust view described in Review Question 2. Display the data in the view. Review Question 2 Using data from the Premiere Products database, define a view named TopLevelCust. It...

This is done in SQL view and there's a pic showing the final answer but I'm not sure how to type it out. Here's what I have for question 1a. CREATE VIEW TopLevelCust AS SELECT CustomerNum,...

using SQL Commands 2) Define a view named BASIC_CUSTOMER. It consists of the customer number, name, balance, credit limit, and rep number for every customer whose credit limit is $7,500 or less. Use...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...

The Assembling Department of Mat Liners had 10,000 units in process in December beginning and received 30,000 units from the Sewing Department. During the month, it completed 20,000 units and...

An investor owns two bonds. He owns $30,000 of a bond which matures in 10 years and has a Macaulay Duration of 8 years. He also owns $20,000 of another bond which matures in 4 years and has a...

Michael Canton is 47, married to Sylvia, 46, and has two dependent children, ages three and five. Mr. Canton's W-4 status is married with zero exemptions, and he deducts an additional $75.00 withheld...

9. Which of the following is not a suggestion for illllroving user input? a. Develop a good project selection process for information technology projects b. Have users on the project team c....

The staff of the marketing department at Premiere Products is scheduled to receive some statistical databases, and they need you to explain these databases to them. (A statistical database is a...

The DBA at Premiere Products wants you to investigate biometric identification techniques for potential use at the company for computer authentication purposes. Use books, articles, and/or the...

1. Many computer magazines and Web sites present comparisons of several DBMSs. Find one such DBMS comparison and compare the functions in this chapter to the listed features and functions in the...

In addition to price - weighted and value - weighted indexes, an equally weighted index is one in which the index value is computed fro the average rate of return of the stocks comprising the index....

Which of the following statements regarding a 15-year (180-month) $125,000, fixed-rate mortgage is CORRECT? (Ignore taxes and transactions costs.) 1. The remaining balance after three years will be...

An investor is considering an investment that will pay $ 2 , 2 8 0 at the end of each year for the next 1 0 years. He expects to earn a return of 1 2 percent on his investment, compounded annually....