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 TAL Distributors Database.

a) Write what the actual VIEW command would be (in your Word document).

b) Execute the SELECT portion of the VIEW

c) Save the query that you create as BASIC_CUSTOMER.

d) Write and execute the command to retrieve the customer number and name of each customer

in the BASIC_CUSTOMER view/query with a balance that exceeds the credit limit.

e) Write and execute the query that the DBMS actual executes.

3) Define a view named CUST_ORDER. It consists of the customer number, customer name, balance, order number, and order date for every order on file. Use TAL Distrubutors Database.

a) Write what the actual VIEW command

b) Execute the SELECT portion of the VIEW command

c) Save the query that you create as CUST_ORDER.

d) Write and execute the command to retrieve the customer number, customer name, order

number, and order date for every order in the CUST_ORDER view/query for only those

customers with balances of no more than $5,000.

e) Write and execute the query that the DBMS actual executes.