Question

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

Answer 1

Answer:

a. CREATE VIEW TopLevelCust ASSELECT CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimitFROM CustomerWHERE CreditLimit >= 10000b. SELECT CustomerNum, CustomerNameFROM TopLevelCustWHERE Balance > CreditLimit;c. SELECT CustomerNum, CustomerNameFROM TopLevelCustWHERE CreditLimit >= 10000AND Balance > CreditLimit;

Explanation: