Consider the General Hardware relational database shown in Figure 7.19.
a. Write an SQL command to create the CUSTOMER table.
b. Write an SQL command to create a view of the CUSTOMER table that includes only the Customer Number and HQ City attributes.
c. Write an SQL command to discard the OFFICE table.
d. Assume that Customer Number 8429 is the responsibility of Salesperson Number 758. Write an SQL command to change that responsibility to Salesperson Number 311.
e. Write an SQL command to add a new record to the CUSTOMER table for Customer Number 9442. The Customer Name is Smith Hardware Stores, the responsible salesperson is Salesperson Number 577, and the HQ City is Chicago.