Using data from the tal distributors database define a view


Using data from the TAL Distributors database, define a view named Top Level Cust. 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 Top Level Cust.

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 Top Level Cust view.

c. Convert the query you wrote in Question 2b to the query that the DBMS will actually execute.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Using data from the tal distributors database define a view
Reference No:- TGS01600360

Expected delivery within 24 Hours